C#, Finding 2 columns sum together in linq

Question

I am bit new to linq .

How do I get the total sum of two columns in my data table.

Let say 2 columns are A& B . I want numeric sum of entire column A and entire column B (i.e totalSum= sum(A)+sum(B))

IMP : If I have any field in either of 2 columns a non numeric field (eg AB,WH,DBNULL) . That field should be considered as zero while summing up the values so that it wont throw any exception.

This will answer your question http://stackoverflow.com/questions/2432281/get-sum-of-two-columns-in-one-linq-query — Bobby, Oct 03 '11 at 07:51

aL3891 · Answer 1 · 2011-10-03T08:26:40.653

4

For each row or the sum of entire column A and entire column B?

In the first case you could do a select:

var resultWithSum = from row in table
select new{ 
  A = row.A, //optional
  B = row.B, //optional
  sum = row.A + row.B
}

Otherwise you can do:

  result = table.Sum(row => row.A + row.B)

edited Oct 03 '11 at 08:26

answered Oct 03 '11 at 07:51

aL3891

6,205
3
33
37

@Nithesh: This won't compile if the +-operator is not defined for the datatypes of A or B. – Jan Oct 03 '11 at 08:01
Your syntax is off on your anonymous type declaration. – Joe Enos Oct 03 '11 at 08:03
@ aL3891 i was referring to 2nd case. – Kuntady Nithesh Oct 03 '11 at 08:22
ah, yes, i wrote that from memory, i fixed it now – aL3891 Oct 03 '11 at 08:28
@NitheshHebri yes, that is true. [Here](http://msdn.microsoft.com/en-us/library/system.linq.enumerable.sum.aspx) are the types you're allowed to return – aL3891 Oct 03 '11 at 08:30

C#, Finding 2 columns sum together in linq

1 Answers1