static void Main(string[] args) { var lst = new PersonNuGetPackage.PersonRepositoryRandom().Get10People(); foreach (var p in lst) { Console.WriteLine(p.Name); } Console.WriteLine(); var res1 = from p in lst select p; var res11 = lst; foreach (var p in res11) { Console.WriteLine(p.Name); } Console.WriteLine(); var res2 = from p in lst orderby p.Gender, p.Name select p; var res22 = lst.OrderBy(i => i.Gender).ThenBy(i => i.Name); foreach (var p in res22) { Console.WriteLine(p.Name + " " + p.Gender); } Console.WriteLine(); var res3 = from p in lst where p.Height > 150 && p.IsHealthy == true orderby p.Gender, p.Name select p; var res33 = lst.Where(i => i.Height > 150 && i.IsHealthy) .OrderBy(i => i.Gender) .ThenBy(i => i.Name); foreach (var p in res33) { Console.WriteLine(p.Name + " " + p.Gender); } Console.WriteLine(); //var res4 = from p in lst where p.Height > 150 && p.IsHealthy == true orderby p.Gender, p.Name select p; var res44 = lst.Where(i => i.Height > 150 && i.IsHealthy) .OrderBy(i => i.Gender) .ThenBy(i => i.Name) .Select(i => new { Navn = i.Name, Højde = i.Height }); foreach (var p in res44) { Console.WriteLine(p.Navn); } }
static void Main(string[] args) { // EF (...LINQ2Sql) List <int> tal = new List <int>() { 1, 7, 8, 17, 6, 4, 6 }; var res1 = (from x in tal where x < 10 orderby x select x).ToList(); var res2 = tal.Where(i => i < 10).OrderBy(i => i).ToList(); var res3 = tal.OrderBy(i => i).GroupBy(i => i); var lst = new PersonNuGetPackage.PersonRepositoryRandom().GetPeople(100); //foreach (var item in lst) //{ // Console.WriteLine(item.Name); //} var res4 = lst.Where(i => i.Height < 170 && i.Gender == PersonNuGetPackage.Gender.Female).OrderBy(i => i.Name).ThenBy(i => i.Height); var res5 = lst .OrderBy(i => i.Name) .Where(i => i.Height < 180) .GroupBy(i => i.Gender); }
static void Main(string[] args) { List <int> lst1 = new List <int>(); lst1.Add(1); lst1.Add(5); lst1.Add(6); lst1.Add(66); lst1.Add(33); lst1.Add(789); lst1.Add(2); lst1.Add(7); var r1 = from i in lst1 where i > 4 select i; //List<int> r1 = (from i in lst1 where i > 4 select i).ToList(); foreach (var item in r1) { Console.WriteLine(item); } // brug tolist eller todictionary for at køre udtryk var p = new PersonNuGetPackage.PersonRepositoryRandom().Get10People(); var r2 = from person in p where person.Height > 170 && person.IsHealthy select person.Name; var r4 = from person in p where person.Height > 170 && person.IsHealthy orderby person.Height, person.Name select new { Navn = person.Name, Højde = person.Height }; // sql syntaks var r5 = from person in p where person.Height > 170 && person.IsHealthy select person.Name; // lambda syntaks var r6 = p.Where(i => i.Height > 170 && i.IsHealthy == true). OrderBy(i => i.Height). ThenBy(i => i.Name). Select(i => new { Navn = i.Name, Højde = i.Height }); foreach (var item in r2) { Console.WriteLine(item); } if (System.Diagnostics.Debugger.IsAttached) { System.Console.Write("Press any key to continue . . . "); System.Console.ReadKey(); } }