sql server 转换成 linq
select sum(money) from B WHERE I>0 GROUP BY SSN 帮我转换成 linq 谢谢 --------------------编程问答-------------------- var query=from b in db.Bwhere b.I>0
group b by b.SSN into g
select g.Sum(t=>t.money); --------------------编程问答-------------------- 学习一下 --------------------编程问答--------------------
学习了!! --------------------编程问答-------------------- var query=from b in db.B
where b.I>0
group b by b.SSN into g
select g.Sum(t=>t.money); --------------------编程问答--------------------
猫哥太快了。 --------------------编程问答-------------------- 必需滴 --------------------编程问答-------------------- --------------------编程问答--------------------
select sum(money) from B WHERE I>0 GROUP BY SSN--------------------编程问答--------------------
(From b in B
where b.I>0
group by ssn
select b.Money).SUM();
这位哥,现在LINQ的select都放后面了吧。。。 --------------------编程问答-------------------- var a = itemses.Where(a => a.I > 0).GroupBy(a => a.SSN).Select(a => a.money).Sum();
给点分吧·
补充:.NET技术 , LINQ