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

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

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

请您参考如下方法:

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()}