Group by and order by
        Posted  
        
            by Simon Thompson
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Simon Thompson
        
        
        
        Published on 2010-03-24T15:59:21Z
        Indexed on 
            2010/03/24
            16:03 UTC
        
        
        Read the original article
        Hit count: 531
        
using LINQ to NHibernate does anybody know how to use group by and order by in the same expression. I am having to execute the group by into a list and then order this, seem that I am missing soemthing here ???
Example:-
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
© Stack Overflow or respective owner