本文介绍了找一个LINQ查询两列的总和的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
让我们说,我有一个称为表 项目(编号INT,完成INT,总INT)
let's say that I have a table called Items (ID int, Done int, Total int)
我可以通过两个查询做到这一点:
I can do it by two queries:
int total = m.Items.Sum(p=>p.Total) int done = m.Items.Sum(p=>p.Done)
但我想这样做在一个查询中,是这样的:
But I'd like to do it in one query, something like this:
var x = from p in m.Items select new { Sum(p.Total), Sum(p.Done)};
当然,有一种方法调用从LINQ语法聚集函数...?
Surely there is a way to call aggregate functions from LINQ syntax...?
推荐答案这将这样的伎俩:
from p in m.Items group p by 1 into g select new { SumTotal = g.Sum(x => x.Total), SumDone = g.Sum(x => x.Done) };更多推荐
找一个LINQ查询两列的总和
发布评论