8,497
社区成员
发帖
与我相关
我的任务
分享
var query = TableA.GroupJoin(TableB, a => a.UserId, b => b.UserId, (a, b) => new
{
a.UserId,
a.UserName,
总科目数 = b.Count(),
简单科目数 = b.Count(s => s.Type == "简单"),
较简单科目数 = b.Count(s => s.Type == "较简单"),
复杂科目数 = b.Count(s => s.Type == "复杂")
});