How to perform group by in LINQ and get a Iqueryable or a Custom Class Object?

Question

Here is my query -

var data = Goaldata.GroupBy(c => c.GoalId).ToList();

This returns a Igrouping object and I want an Iqueryable object which I can directly query to get the data while in this case I have to loop through using a foreach() and then get the data. Is there another way to group by in LINQ which returns directly as a list of Iqueryable or a List as similar to what happens for order by in LINQ.

Answer 1

The easiest way is probably

var data = Goaldata.GroupBy(c => c.GoalId).SelectMany(c => c).ToList();

In the OO sense they aren't really grouped, but they are ordered with the groups together.

Answer 2

Or .GroupBy(c => c.GoalId).AsQueryable()...

Answer 3

Whilst the accepted answer is correct, it seems to be unnecessarily complicated. Assuming GoalId is an int you can just use OrderBy:

var data = Goaldata.OrderBy(c => c.GoalId).ToList();