例如:
SELECT partName,sum(partWeight) as totalWeight
FROM tblParts
GROUP BY partName
Linq to sql 写法:
var sr = from k in db.tblParts
group by k.partName into g
select new
{
partName = g.Key,
totalWeight = g.Sum(k => k.partWeight)
}
没有评论:
发表评论