linq query and results display by category

Question

I want to display list of items which belong to certain category like this:

Category I

• Item 1
• Item 2
• Item 3

Category II

• Item 6
• Item 7

Category III

• Item 10
• Item 11
• Item 12
• Item 13

What is the best (and easiest) way to do this? I started doing this with two queries - one gets all goals, and then in foreach loop (in controller) I call another query which gets all items from this category, but then things got complicated... I have no idea in what type of object to store these items and how to pass all this together to a view.

Any idea?

Thanks!

Answer 1

to select:

var query = from item in itemstable
group item by item.category into y
select new { key = y.Key, grouping = y };

then to access:

foreach(var g in query)
{
    //this is each grouping
    foreach(var item in query.grouping)
    {
        //this is each item in each group
    }
}