代码改变世界

Linq Group By 多个字段

2022-03-04 16:05  idea555  阅读(320)  评论(0)    收藏  举报

var counts = dal.QueryStatisticsCount(condition);
var result =
from p in counts
group p by new { AuctionName = p.AuctionName, StatusName = p.StatusName } into g
select new
{
StatusName = g.Key.StatusName,
Num = g.Sum(c => c.VehicleCount)
};