Sorting / Ordering in asp.net mvc 4 with linq

Question

I currently have a controller that's returning a list of results. Some results get multiple hits, for example:

result x,
result x,
result x,
result y,
result z

I'm then trying to sort these results by the number of hits they have with this code here:

(orgs.Organisations is a list of Organisations i.e. results)

orgs.Organisations = orgs.Organisations
                         .GroupBy(f => f.Name)
                         .SelectMany(c => c.OrderByDescending(p => p.Name.Count()))
                         .ToList();

This is the closest I think I have gotten but its still not returning them in the correct order. Any guidance would be greatly appreciated.

MarcinJuraszek · Accepted Answer · 2014-03-31 00:38:54Z

1

Your current query orders items within group, not the groups. Make OrderBy call before SelectMany:

orgs.Organisations = orgs.Organisations
                         .GroupBy(f => f.Name)
                         .OrderBy(g => g.Count())
                         .SelectMany(g => g)
                         .ToList();

answered Mar 31, 2014 at 0:38

MarcinJuraszek

126k15 gold badges199 silver badges267 bronze badges

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

Collectives™ on Stack Overflow

Sorting / Ordering in asp.net mvc 4 with linq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related