How would I do Subsequent sort on a child table in asp.net mvc2 using Entity Framework

Question

I am trying to do something like this:

 ViewData.Model = _db.Questions  
                     .Include("QType")  
                     .Include("QTags")  
                     .Include("SubQuestions.Options")  
                     .Where(q => q.Active == true)  
                     .Orderby(q => Questions.Order)  
                     .Orderby(sq => SubQuestions.Order)  
                     .ToList(); 

But ofcourse it is not working as I want to. The Ordering works on Question.Order, but I would also the Questions.SubQuestions List to be ordered according to SubQuestions.Order Any blatant mistakes anyone can help me resolve?

Thanks

Answer 1

Is your code accurate? It doesn't look like you're using either q or sq in your order by clauses. I'm pretty sure your problem though is that your second order by should be replaced with the ThenBy operator.