GroupBy in Enumerable method

Question

I want to make a list of Report class from persons list with group by

class Report
{
    public string Country { get; set; }
    public double SumAge { get; set; }
}

class Person
{
    public int Age { get; set; }
    public string Name { get; set; }
    public string Country { get; set; }
}

var list = new List<Person>
{
    new Person {Age = 35, Country = "Spain", Name = "John"},
    new Person {Age = 45, Country = "Spain", Name = "Alex"},
    new Person {Age = 55, Country = "Hungary", Name = "Bob"},
    new Person {Age = 23, Country = "Spain", Name = "Eve"},
    new Person {Age = 39, Country = "India", Name = "Rose"},
    new Person {Age = 25, Country = "India", Name = "Peter"},
    new Person {Age = 51, Country = "Hungary", Name = "Rob"},
    new Person {Age = 23, Country = "India", Name = "Jeff"},
};
list.GroupBy(p => p.Country, p => p)
   .Select(p => new Report 
{
    Country = p.Key,
    SumAge = p.Sum() //????
});

There is something wrong in select statement, how can I count a sum of ages?

Have a look at this answer http://stackoverflow.com/questions/19285443/group-by-count-and-lambda-expression — CheGueVerra, Feb 07 '15 at 15:48

score 4 · Accepted Answer · answered Feb 07 '15 at 15:24

4

You need to specify which property to sum:

var res = list.GroupBy(p => p.Country, p => p)
    .Select(p => new Report
    {
         Country = p.Key,
         SumAge = p.Sum(x => x.Age)
    });

answered Feb 07 '15 at 15:24

Flat Eric

7,971
9
36
45

GroupBy in Enumerable method

1 Answers1