Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Get sum of two columns in one LINQ query

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)}; 

Surely there is a way to call aggregate functions from LINQ syntax...?

like image 833
Axarydax Avatar asked Mar 12 '10 11:03

Axarydax


People also ask

How do you sum two columns in Linq?

Items select new { Sum(p. Total), Sum(p. Done)};


1 Answers

This will do the trick:

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)  }; 
like image 137
Steven Avatar answered Sep 20 '22 04:09

Steven