c# linq 汇总查询问题

Question

sql = select goodsid,ceiling(qs),sum(money) from md group by goodsid,ceiling(qs)我想问一个ceilling这个功能用linq如何实现呀。谢谢了。

Answer 1

from x in md
group x by new { goodsid, cqs = math.ceiling(qs) } into g
select new { g.key.goodsid g.key.cqs,sum = g.Sum(y => y.money) };