c# - 在 LINQ 中选择计数

Question

我得到了一个带有列的 SQL Server 表 ResolvedDate和 ResolvedBy .

现在我想选择这两列并计算它们的结果，我想我会这样实现:

_dataContext.Activities
    .Where(a => a.IsResolved && a.ResolvedBy == userId)
    .Select(a => new { a.ResolvedDate, ***COUNT*** });

如您所见，缺少 Count-Part。

我想获取在此 ResolvedDate 中完成的所有事件并对其进行计数。

我该如何实现？

Answer 1

from a in dataContext.Activities
where a.IsResolved && a.ResolvedBy == userId
group a by a.ResolvedDate into g
select new {ResolvedOn=g.Key, NumberResolved= g.Count()}