如何在 Linq 中使用 Sum() 函数？

Question

我该如何将这个语句转换为LINQ？

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

- user1719311

---

你自己尝试了什么？你现在遇到了哪段代码的问题？ - J. Steen

与您的第一个问题类似，同样的主题，同样（糟糕）的质量。 - Michal Klouda

感谢您（不太好的）信息.... @Michal Klouda - user1719311

Answer 1

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

- John Woo

Answer 2

var sum = db.account.Where(a => a.name == "stocks" && a.userid == 290)
                    .Sum(a => a.Balance);

- Sergey Berezovskiy

Answer 3

像这样：

myBalanceSum = account.Where(x => x.name == 'stocks' && x.userid == 290 ).Sum(x => x.Balance);

- Gary Barrett