首页 > 其他 > 详细

一、分组查询

时间:2019-06-24 16:54:56      阅读:77      评论:0      收藏:0      [点我收藏+]

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

            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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!