title: Linq to SQL to return parent rows
body: <p>I have a table format of</p>
  
  <pre><code>Id (int)
  ParentId (int)
  </code></pre>
  
  <p>I need to query out all rows that are related to each other so ParentId = Id but nested multiple times</p>
  
  <p>I am a bit stuck on how to tackle this one, I may revert to a stored procedure but I really wanted to try this in pure linq to sql.</p>