static void IndexFiltering() { var query = MusicFestival.GetMusicians().Where((m, index) => m.Name.StartsWith("N") && index > 5); foreach (var m in query) { Console.WriteLine("{0}\n", m.Name); } }
static void GetAliveMusiciansNames() { Console.WriteLine("This is GetAliveGroups...\n"); var query = from m in MusicFestival.GetMusicians() where m.IsDead == false select m; foreach (var m in query) { Console.WriteLine("{0}\n", m.Name); } }
static void GetDeadMusicGroups() { Console.WriteLine("This is GetDeadMusicGroups...\n"); var query = from m in MusicFestival.GetMusicians() where m.PeopleCount > 1 && m.IsDead select m; foreach (var m in query) { Console.WriteLine(m.ToString("All")); } }
static void AllDeadMusicians() { Console.WriteLine("\nAll dead musicians:\n"); var query = from m in MusicFestival.GetMusicians() where m.IsDead == true orderby m.Id descending select m.Name; foreach (var m in query) { Console.WriteLine(m); } }
static void VeryHollowQuery() { Console.WriteLine("\nVery Strange Query:\n"); var query = from m1 in (from m1 in MusicFestival.GetMusicians() where m1.Birthyear >= 2010 select new { m1.Name, m1.PeopleCount }) join m2 in (from m2 in MusicFestival.GetMusicians() where m2.Birthyear < 2010 && m2.IsDead select new { m2.Name, m2.PeopleCount }) on m1.PeopleCount equals m2.PeopleCount select new { m1.Name, m2.PeopleCount }; foreach (var m in query) { Console.WriteLine("Name:{0}\tPeople Count:{1}", m.Name, m.PeopleCount); } }