简单的 Linq 分组

Question

如何在 Linq 中使用group by。

SqlServer Sample

select 
    ActionGroupName,  
    sum(cast(isnull(solicit_count,0) as int)) as 'SolicitCount' 
from 
    [solicits]
group by
    ActionGroupName

我的 linq 版本

var groupbyfilter = from v in lstSale
                    group v by v.ActionGroupName into g
                    select g.ActionGroupName, sum(g.solicit_count)

我没有以正确的方式获取它。

Answer 1

尝试：

var groupbyfilter = from v in lstSale
                    group v by v.ActionGroupName into g
                    select new 
                    { 
                      ActionGroupName = g.Key, 
                      Sum = g.Sum(x => x.solicit_count)
                    };