title: How to order the items in a nested LINQ-provided collection
body: <p>I've got a (SQL Server) database table called Category.
  And another database table called SubCategory.</p>
  
  <p>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.</p>
  
  <p>If I want to sort the <em>Categories</em> alphabetically, I can just do:</p>
  
  <pre><code>return db.Categories.OrderBy(c =&gt; c.Name);
  </code></pre>
  
  <p>However, I have no idea how to order the <em>SubCategories</em> collection inside each Category.</p>
  
  <p>My goal is to return a collection of Categories, where all of the SubCategory collections inside of them are ordered alphabetically by Name.</p>