Having a little trouble here. I am taking a table (Articles) and grouping all the results by the key that references another table (ArticleSectionCategories). I then want to sort these results by the OrderBy field of the referenced table (ArticleSectionCategory.OrderBy). This is what I am using right now but it is not working. Any thoughts?
var GroupedArticles = from A in DC.Articles
where A.PackagesId == packageId
group A by A.ArticleSectionCategoriesId into G
select G.OrderBy(C => C.ArticleSectionCategory.OrderBy);
View Complete Post