How do I order a Group result, in Linq?

linq sql-order-by group-by
Pure.Krome picture Pure.Krome · Apr 16, 2009 · Viewed 39.3k times · Source

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

Arjan Einbu picture Arjan Einbu · Apr 16, 2009

Just add the orderby clause ;-)

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 };

Related questions

Linq order by, group by and order by each group?

I have an object that looks something like this: public class Student { public string Name { get; set; } public int Grade { get; set; } } I would like to create the following query: group grades by student name, order each student group by …

Read More
LINQ Orderby Descending Query

I'm sure this will be a relatively simple one. I have a LINQ query that I want to order by the most recently created date. See: var itemList = from t in ctn.Items where !t.Items && t.DeliverySelection …

Read More
Multiple "order by" in LINQ

I have two tables, movies and categories, and I get an ordered list by categoryID first and then by Name. The movie table has three columns ID, Name and CategoryID. The category table has two columns ID and Name. I …

Read More