I’ve just found out how to combine .Sum() with a where clause, and all it took was a further step into the murky world of Linq.

I got my tip-off from a fellow BlogEngine.NET blog user Gary Kilminster – – although it doesn’t look like his blog has been updated for a while.

I had a list of custom objects, and wanted to get the sum of all their ‘Cost’ values as long as they had a specific property in common. The bit of Gary’s code that really made it click for me was:

        string londonNames = (from c in db.Customers
where c.City == "London"
select c.CompanyName).Sum();

In my case, it became:

        int result = (from o in objectList
where o.OptionGroupId == specificId
select o.Cost).Sum();

It’s just so simple and easy. Hooray!

Leave a comment

Your email address will not be published. Required fields are marked *