sum column with linq to sql

Question

Hey all,

I have a DataView in which I would like to sum a column called "Amount"

Now I know I can iterate thru the columns and get the sum but I was wondering if is possible using Linq to Sql?

String sum = Linq to Sql stuff here (doesn't have to be a string, can be any type)

Thanks, rodchar

Answer 1

Assuming the Amount column is a double (could be another type)

double sum = Table.Select(t => t.Amount ?? 0).Sum();

Or

double sum = Table.Sum(t => t.Amount ?? 0).Sum();

Using the null coelescing operator will give you a default of 0 if t.Amount is null.

Answer 2

Excuse me for dataContext call syntax...

var sum = dataContext.Sum(x => x.Amount);

If you want to sum strings, you may want to use

var sum = string.Join(", ", dataContext.Select(x => x.StringColumn).ToArray());

Hope this works.