MVC Foreach distinct value from database

Question

I have a table in my database that looks a bit like this:

Links

LinksID

TvID(foreign Key)

Season

Episode

Link

Now I'm trying to have a foreach statement in my view so that it will look something like this on my page.

Season 1

Episode 1

Episode 2

Episode 3

Season 2

Episode 1

Episode 2

Episode 3

However all I can get is

Season 1 Episode 1

Season 1 Episode 2

Season 1 Episode 3

Season 2 Episode 1

Season 2 Episode 2

Season 2 Episode 3

So after some googling I have now got my foreach like this however it obviously only display the first episode which is not what I'm after.

@foreach (var item in Model.Links.GroupBy(x => x.Season).Select(s => s.First()))
{
<p>Season @Html.DisplayFor(modelItem => item.Season) @Html.DisplayFor(modelItem => item.Episode)</p>
}

what am I doing wrong?

- have you tried @foreach (var item in Model.Links.GroupBy(x => x.Season).Select(s => s)). - Or you can create a Dictionary where the Key is the season, and the value is all the episodes of that season. — Omar.Alani
– Omar.Alani, Commented Oct 27, 2014 at 3:23
If I use the foreach you mentioned I get this error 'System.Linq.IGrouping<int,ScreenhostLive.Models.Links>' does not contain a definition for 'Season' and no extension method 'Season' accepting a first argument of type 'System.Linq.IGrouping<int,ScreenhostLive.Models.Links>' could be found (are you missing a using directive or an assembly reference?). How would I create the dictionary idea as I have never done that before — niko619
– niko619, Commented Oct 27, 2014 at 3:30

DLeh · Accepted Answer · 2014-10-27 03:29:51Z

3

You want something like this:

@{
    var myList = Model.Links
        .GroupBy(x => x.Season)
        .Select(x => new { Season = x.Key, Episodes = x });
}
@foreach (var season in myList)
{
   <strong>Season @Html.DisplayFor(modelItem => season.Season)</strong>
   foreach(var episode in season.Episodes)
   {
        @Html.DisplayFor(modelItem => item.Episode)
   }
}

answered Oct 27, 2014 at 3:29

DLeh

24.6k17 gold badges96 silver badges141 bronze badges

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

2 Comments

niko619 Over a year ago

Yes that worked, thank you. Just so I understand better what does this section actually do? Select(x => new { Season = x.Key, Episodes = x });

DLeh Over a year ago

you specify what you're selecting from the grouping that you're interested in. in this case, you need to know what season it is (so you select x.Key, "Season", which was key you used for grouping). The other thing you need is the results of the grouping, which is the actual episodes. So then you enumerate through each season, and then enumerate each episode in the grouped season. This will probably help: stackoverflow.com/questions/7325278/group-by-in-linq

diy · Accepted Answer · 2014-10-27 10:42:28Z

1

You just try this code

            @foreach (var item in Model.Links.GroupBy(x => x.Season).tolist()))
    {
    Season @Html.DisplayFor(modelItem => item.Season) 

    @foreach (var items in Model.Links.where(z=>z.season==itme.season))

    {
            @Html.DisplayFor(modelItem => item.Episode)
    }
    }

answered Oct 27, 2014 at 10:42

diy

1191 gold badge1 silver badge10 bronze badges

Collectives™ on Stack Overflow

MVC Foreach distinct value from database

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related