How do I order a Group result, in Linq?

Question

Hi folks,
I have the following linq query, which works fine. I'm not sure how i order the group'd result.

from a in Audits
join u in Users on a.UserId equals u.UserId
group a by a.UserId into g
select new { UserId = g.Key, Score = g.Sum(x => x.Score) }

the results are currently ordered by UserId ascending. I'm after Score descending.

thanks :)

Answer 1

Just add the orderby clause ;-)

Here's how:

from a in Audits
join u in Users on a.UserId equals u.UserId
group a by a.UserId into g
let score = g.Sum(x => x.Score)
orderby score descending
select new { UserId = g.Key, Score = score };

Answer 2

var results =
 (from a in Audits
join u in Users on a.UserId equals u.UserId
group a by a.UserId into g
select new { UserId = g.Key, Score = g.Sum(x => x.Score) })
.OrderByDescending(p=>p.Score);

Hope this will fix your problem, easier than the top one ;)

Cheers

Answer 3

It just keeps getting better - thanks to this thread I was able to clean up the DetailGroups query using a join - kinda doubtful about how it was written before with the nested from and the where. I learned so much from working on this I'm posting the Nexted ListViews and OnItemDatabound that goes with it, so just skip the rest if the code in my previous post is not of interest.

I ended up not posting, couldn't get the formatting right. If you're interested let me know and I'll email it to you or try again.

Answer 4

perfeito funcionou