SQL语句如下:
SELECT partName,sum(partWeight) as totalWeight
FROM tblParts
GROUP BY partName
SELECT partName,sum(partWeight) as totalWeight
FROM tblParts
GROUP BY partName
在LINQ中如何实现以上功能?
var sr = from k
in
db.tblParts
group by k.partName into g
select
new
{
partName = g.Key,
totalWeight = g.Sum(k => k.partWeight)
}