title: Retrieve all Children and their Children, recursive SQL
body: <p>Consider the following rows in a database:</p>
  
  <pre><code>Id      |   Parent
  __________________
  1           null
  2           1
  3           2
  4           3
  5           null
  6           5
  </code></pre>
  
  <p>Each <code>Id</code> that has  a <code>null</code>  <code>Parent</code> is the "Owner"/"Super Parent".</p>
  
  <p>What would be the best approach, performance wise, to collect the parents and their children ? Should I use <strong>LINQ</strong> or <strong>Stored Procedures</strong> ?</p>
  
  <p>I want the end result to be <code>IEnumerable&lt;IEnumerable&lt;int&gt;&gt;</code>.</p>