How can I return a object with the sum of all objects from a list using Linq?

Question

If I have a list of an object called Spendline with two properties, Year and Amount and BudgetID. How can I best convert the following List:

Year      Amount      BudgetID
2000      100         1
2001      100         1
2002      100         1
2003      100         1
2001      100         2
2002      100         2
2003      100         2

To this:

Year      Amount      
2000      100         
2001      200         
2002      200       
2003      200

Using Linq?

Jon Skeet · Accepted Answer · 2012-02-27 13:58:01Z

4

Looks like you want something like:

var query = items.GroupBy(x => x.Year, x => x.Amount)
                 .Select(g => new { Year = g.Key, Amount = g.Sum() };

Or as a query expression:

var query = from item in items
            group item.Amount by item.Year into g
            select new { Year = g.Key, Amount = g.Sum() };

(Call ToList on the query to get a List<T> of course.)

answered Feb 27, 2012 at 13:58

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

musefan · Accepted Answer · 2012-02-27 14:00:19Z

0

I think you can do this with GroupBy and Sum functions

An example of getting this data with a loop might look like this:

foreach(var group in SpendlineList.GroupBy(x => x.Year))
{
   int year = group.Key;
   int ammount = group.Sum(x => x.Ammount);
}

answered Feb 27, 2012 at 14:00

musefan

48.5k21 gold badges144 silver badges193 bronze badges

Collectives™ on Stack Overflow

How can I return a object with the sum of all objects from a list using Linq?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related