Linq to SQL - 分组依据和计数 [英] Linq to SQL - Group By and Count

问题描述

我正在尝试转换此查询(已在运行)

I'm trying to convert this query (already working)

SELECT Building.NAME, COUNT([User].ID)
FROM BuildingUser
INNER JOIN Building ON Building.ID = BuildingUser.ID_BUILDING
INNER JOIN [User] ON [User].ID = BuildingUser.ID_USER
GROUP BY Building.NAME

到 Linq to SQL，但我不知道我做错了什么.看看我的努力

To Linq to SQL, but I don't know what I'm doing wrong. Look at my trying

from buildinguser in db.GetTable<BuildingUser>()
join building in db.GetTable<Building>()
on buildinguser.ID_BUILDING equals building.ID
join user in db.GetTable<User>()
on buildinguser.ID_USER equals user.ID
group building by building.NAME into grpBuilding
select new
{
    building = grpBuilding.Key,
    users = 
};

我只需要对我的建筑物进行分组并计算每个建筑物有多少用户.

I just need to group my Buildings and count how many users each one has.

推荐答案

只需使用Count方法:

from buildinguser in db.GetTable<BuildingUser>()
join building in db.GetTable<Building>()
on buildinguser.ID_BUILDING equals building.ID
join user in db.GetTable<User>()
on buildinguser.ID_USER equals user.ID
group building by building.NAME into grpBuilding
select new
{
    building = grpBuilding.Key,
    users = grpBuilding.Count()
};

这篇关于Linq to SQL - 分组依据和计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！