title: Collect All Children of a parent from given table
body: <p>I want to collect all child rows with a given parent from this table in TSQL.</p>
  
  <pre><code>ID     Name   parentID
  ------ ------ ---------
   1     ABCD          0
   2     xyz           1
   3     efg           1
   4     lm            2
  </code></pre>
  
  <p>Please let me know how can get in hierarchy list using linq.</p>