如何通过LINQ使用group

本文关键字：group 使用 LINQ 何通过 | 更新日期: 2023-09-27 17:59:37

我需要显示公司名称和每个员工人数（人数）。

var result2 = (from c in NoOfEntities.listOfCompanies
               join s in NoOfEntities.listOfStores on c.Id equals s.CompanyId
               join p in NoOfEntities.listOfPersons on s.Id equals p.StoreId
               group c by c.Name into newGroup
               select newGroup );

我需要加员工人数，但我不知道如何加那个计数器。

如何通过LINQ使用group

var result2 = (from c in NoOfEntities.listOfCompanies
                join s in NoOfEntities.listOfStores on c.Id equals s.CompanyId
                join p in NoOfEntities.listOfPersons on s.Id equals p.StoreId
                group p by c.Name into newGroup
                select new
                {
                    CompanyName = newGroup.Key,
                    NumberOfEmployees = newGroup.Count()
                });