我该如何将这个语句转换为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();
var sum = db.account.Where(a => a.name == "stocks" && a.userid == 290)
.Sum(a => a.Balance);
像这样:
myBalanceSum = account.Where(x => x.name == 'stocks' && x.userid == 290 ).Sum(x => x.Balance);