title: Recursive Hierarchy - Recursive Query using Linq
body: <p>I am using Entity Framework (version 6) to map to a recursive hierarchy and it maps nicely.</p>
  
  <p>My issue is that I want to recursively get <strong>ALL</strong> child nodes of a particular node in the hierarchy. </p>
  
  <p>I get the child nodes quite easily using Linq:</p>
  
  <pre><code>var recursiveList = db.ProcessHierarchyItems
              .Where(x =&gt; x.id == id)
              .SelectMany(x =&gt; x.Children);
  </code></pre>
  
  <p>Does anybody know of a clean implementation, that will recursively get all children?</p>