c# – 复杂的LINQ查询

发布时间：2020-12-15 08:05:26 所属栏目：百科来源：网络整理

导读：考虑一下这个集合 ListPerson people = new ListPerson { new Person{Name = "A",SSN="1",Age = 23},new Person{Name = "A",SSN="2",new Person{Name = "B",SSN="3",Age = 24},new Person{Name = "C",SSN="4",new Person{Name = "D",SSN="5",Age = 23} }; 问

考虑一下这个集合

List<Person> people = new List<Person>
        {
            new Person{Name = "A",SSN="1",Age = 23},new Person{Name = "A",SSN="2",new Person{Name = "B",SSN="3",Age = 24},new Person{Name = "C",SSN="4",new Person{Name = "D",SSN="5",Age = 23}
        };

问题是：如何编写LINQ查询以对Age on Person进行分组,然后计算具有相同名称的每个组中的人数？

我尝试使用group by运算符,嵌套查询所有可能性仍然无法弄清楚确切的查询.

问候,
哎呀

解决方法

怎么样

var ages  = from p in people 
            group p by p.Age into g
            select new { 
                Age = g.Key,Count = g.Count(),Names = from prs in g 
                        group prs by prs.Name
            };

Names属性将具有名称作为Key,然后您可以为每个名称获取Count().

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!