title: Self join in Entity Framework
body: <p>I want to have following type of query in entity frame work</p>
  
  <pre><code>SELECT  c2.* 
  FROM    Category c1 INNER JOIN Category c2
  ON      c1.CategoryID = c2.ParentCategoryID
  WHERE   c1.ParentCategoryID is NULL
  </code></pre>
  
  <p>How to do the above work in Entity framework...</p>