问题描述
我有一个非常简单的 SQL 查询:
I have a very simple SQL query:
SELECT r.SpaceID, Count (*), SpaceCode FROM Rider r JOIN Spaces s ON r.SpaceID = s.SpaceID GROUP BY r.SpaceID, s.SpaceCode
请注意,我的 group by 子句在多个表上,我想在 LINQ 中做同样的事情,我知道如何对单个表进行分组,但我不知道如何对多个表进行分组.
Please note that my group by clause is on multiple tables, I want to do the same in LINQ, I know how to group single table, but about multiple tables I have no idea.
推荐答案
要对多个表进行分组,您可以这样做:
For grouping multiple tables you can do as:
group new { r,s } by new { r.SpaceID, s.SpaceCode }