我如何在Linq订购小组结果? [英] How do I order a Group result, in Linq?
本文介绍了我如何在Linq订购小组结果?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下linq查询,它工作正常。我不确定我是如何订购组的结果的。
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) }
结果目前按UserId升序排列。
the results are currently ordered by UserId ascending. I'm after Score descending.
谢谢:)
推荐答案
只需添加orderby子句;)
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 };
这篇关于我如何在Linq订购小组结果?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文