一、分组查询

一、查询(简单查询、分组查询)

            var myList = [
             { Name: "Jim", Age: 20 },
             { Name: "Kate", Age: 21 },
             { Name: "Lilei", Age: 18 },
             { Name: "John", Age: 14 },
             { Name: "LinTao", Age: 25 }
            ];
            var arrRes = Enumerable.From(myList).Where(x=>x.Name == 'Jim').ToArray();

            var list=[
              {id:1,name:"lily",gender:0,o:{id:123}},
              {id:2,name:"lucy",gender:0,o:{id:456}},
              {id:3,name:"lilei",gender:1,o:{id:123}},
              {id:4,name:"hanmeimei",gender:0,o:{id:789}}                            
            ];
            var res = Enumerable.From(list).GroupBy(x=>x.o.id).Select(x=>({ key: x.Key(), source: x.Count() })).ToArray();

  

原文地址:https://www.cnblogs.com/fger/p/11077736.html