How to calculate sum of a DataTable's Column in LINQ (to Dataset)?

Question

I'm just started to read up on LINQ and I want to start incorporating it into my code. I know how to compute the sum of a DataTable's column by either "Foreach"-ing through the rows or by doing a compute.sum on the specific column. How do I do the equivalent with LINQ to DataSet?

Answer 1

If untyped (replace int with the correct data type):

 var sum = table.AsEnumerable().Sum(x=>x.Field<int>(3));

or:

 var sum = table.AsEnumerable().Sum(x=>x.Field<int>("SomeProperty"));

If typed:

 var sum = table.Sum(x=>x.SomeProperty);

Answer 2

If you data field is integer

var sum = TableData.Sum(x => x.FieldName);

If your data field is string then you need to parse it as integer

var sum = TableData.Sum(x => Int32.Parse(x.FieldName));

If your data field is string and you want to store result as string

var sum = TableData.Sum(x => Int32.Parse(x.FieldName)).ToString();