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

c# linq datatable sum
rivera.reyrivera picture rivera.reyrivera · Feb 15, 2009 · Viewed 93.6k times · Source

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

Marc Gravell picture Marc Gravell · Feb 15, 2009

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

Related questions

LINQ query on a DataTable

I'm trying to perform a LINQ query on a DataTable object and bizarrely I am finding that performing such queries on DataTables is not straightforward. For example: var results = from myRow in myDataTable where results.Field("RowNo") == 1 select results; This …

Read More
Get all column names of a DataTable into string array using (LINQ/Predicate)

I know we can easily do this by a simple loop, but I want to persue this LINQ/Predicate? string[] columnNames = dt.Columns.? or string[] columnNames = from DataColumn dc in dt.Columns select dc.name;

Read More
How to convert DataTable to class Object?

I have already developed an application which returns DataTable everywhere. Now my client wants to convert (use some part using service stack), so I need to return DTO (objects) in my application. I don't want to change my existing stored …

Read More