How to order the items in a nested LINQ-provided collection
- by Carson McComas
I've got a (SQL Server) database table called Category.
And another database table called SubCategory.
SubCategory has a foreign key relationship to Category. Because of this, thanks to LINQ, each Cateogory has a property called SubCategories and LINQ is nice enough to return all the SubCategories associated with my Category when I grab it.
If I want to sort the Categories alphabetically, I can just do:
return db.Categories.OrderBy(c => c.Name);
However, I have no idea how to order the SubCategories collection inside each Category.
My goal is to return a collection of Categories, where all of the SubCategory collections inside of them are ordered alphabetically by Name.
