如何在Linq中使用Sum()? [英] How can I use Sum() in Linq?

问题描述

如何将该语句转换为LINQ?

How do I convert this statement into LINQ?

SELECT Sum(Balance) FROM account WHERE name='stocks' AND userid=290;

推荐答案

decimal sumLineTotal = (from od in account
                        where name == 'stocks' && userid == 290
                        select Balance).Sum();

这篇关于如何在Linq中使用Sum()?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！