有人知道如何在同一个表达式中使用group by和order by吗?使用LINQ to NHibernate。我不得不将group by执行到一个列表中,然后对这个进行排序,似乎我在这里错过了一些东西?
示例:-
Private function LoadStats(...) ...
Dim StatRepos As DataAccess.StatsExtraction_vwRepository = New DataAccess.StatsExtraction_vwRepository
return (From x In StatRepos.GetAnswers(Question, Questionnaire) _
Group x By xData = x.Data Into Count() _
Select New ChartData
With {.TheData = xData,
.TheValue = xData.Count}
).ToList.OrderBy(Function(x) x.TheData)
End Sub发布于 2010-03-25 00:19:40
我不是Visual Basic专家,但是您应该能够在Select子句中使用别名来创建临时变量,这样您就可以在后面的子句(如Order By )中引用它。除非NHibernate中有某些限制,否则以下内容应该可以工作:
return From x In StatRepos.GetAnswers(Question, Questionnaire) _
Group x By xData = x.Data Into Count() _
Select res = New ChartData With _
{ .TheData = xData, _
.TheValue = xData.Count } _
Order By res.TheData _
Select res我猜在某些情况下,这可能比将Order By子句移到Select子句之前更具可读性。
https://stackoverflow.com/questions/2509216
复制相似问题