using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;

 namespace Test
 {
     class Program
     {
         static void Main(string[] args)
         {
             List<Test> listData = new List<Test>{
                 new Test { Name = "jiangjing", Age = 18, Sex = "boy"},
                 new Test { Name = "wenting", Age = 17, Sex = "girl"},
                 new Test { Name = "caihong", Age = 80, Sex = "boy"},
                 new Test { Name = "caiyun", Age = 90, Sex = "boy"}
             };

             //string[] names = {"jiangjing", "wenting", "caihong", "test"};
             //1.使用查询方式
             //var res = from n in names
             //          where n.EndsWith("g")
             //          orderby n.Substring(n.Length-1)
             //          select n;

             //2.使用方法方式
             //var res = names.OrderBy(n=>n).Where(n=>n.EndsWith("g"));
             //foreach (var name in res)
             //    Console.WriteLine(name);

             //3.聚合函数的相关使用,分析大型数据结果
             //var resultData = listData.Where(t=>t.Age<20).Select(t=>t.Age);

             //4.投影:在查询中新建对象
             //var resultData = listData.Where(t => t.Sex == "boy").Select(t => new { Name = t.Name, Age = t.Age });
             //foreach (var item in resultData)
             //    Console.WriteLine(item);

             //5.单值选择:Distinct()函数
             //var resultData = listData.Where(t => t.Sex == "boy").Select(t => new { Name = t.Name, Age = t.Age }).Distinct();
             //foreach (var item in resultData)
             //    Console.WriteLine(item);

             //6.Any和All方法
             //bool falg1 = resultData.Any(t=>t.Name=="jiangjing");
             //bool falg2 = resultData.All(t => t.Name == "jiangjing");
             //Console.Write("{0} {1}", falg1, falg2);

             //7.多级排序,使用方法也行orderby,thenby...，不过写起来还没这个清晰
             //var resultData = from t in listData
             //                 orderby t.Age, t.Name
             //                 select new { Name = t.Name, Age = t.Age};
             //foreach (var item in resultData)
             //    Console.WriteLine(item);

             //8.组合查询
             //var resultData = from t in listData
             //                 group t by t.Sex into tg
             //                 select new { SumAge = tg.Sum(t => t.Age), Sex = tg.Key };

             //foreach (var item in resultData)
             //    Console.WriteLine(item);

             //9.查询结果使用take函数或者skip函数

             //var resultData = listData.Where(t=>t.Age<20);

             //foreach (var item in resultData.Take(1))//take函数是取结果集的前n个
             //    Console.WriteLine(item);

             //foreach (var item in resultData.Skip(1))//skip函数则是跳过结果集的前n个
             //    Console.WriteLine(item);

             Console.ReadKey();
         }
     }

     class Test
     {
         public string Name { get; set; }
         public int Age { get; set; }

         public string Sex { get; set; }

         public override string ToString()
         {
             return "名字：" + Name + "\n" + "年龄：" + Age;
         }
     }
 }