title: Entity Framework Query Help
body: <p>Ok so I am just trying to learn some of this fun stuff now, and was wondering if I could get some feedback?</p>
  
  <p>Tables
  Categories
  Postings
  Postings_Categories(Join Table)</p>
  
  <p>I need to figure out how to recurse through all of the categories and get the number of postings in each category. As well, if it can all be done with one query, I need to list the subcategories of each parent category. </p>
  
  <p>Categories table has CategoryID, CategoryName, CategoryDescription, ParentCategoryID</p>