Nested GroupBy extension method

Question

Can someone show me a a simple example of a nested GroupBy extension method. I am trying to group an object into a list. I figure it will look something like this:

List<stats> myStats = GetStatsList().GroupBy( d => d.date).GroupBy(t => t.team)
Select(s => new stats
{
Date =
Team =
}).AsEnumerable().ToList();

Thanks in advance.

Vulpes · Answer

Try: List myStats = GetStatsList().GroupBy(s => new { s.date s.team }).Select(g => new stats { Date = g.Key.date  Team = g.Key.team}).AsEnumerable().ToList();

Shen Hengbin · Answer

Instead .GroupBy..GroupBy... You should use GroupBy(new {key1  key2..})... like var result = list.GroupBy(p => new { p. date  p. team }).Select(p=>new { Date = p.Key. date  Team = p.Key. team });

Shen Hengbin · Answer

You can directly use .ToList(); Does it not work ?

Rich · Answer

This does work but is there a way to return it as a List ?