title: Sql query for 3 level tree?
body: <p>I have table and I want get 3 lvl tree.
  Example</p>
  
  <pre><code>Node
  Id     ParentId     Name
   1       -1       Test 1
   2       -1       Test 2
   3        1       Test 1.1
   4        1       Test 1.2
   5        3       Test 1.1.1
   6        3       Test 1.1.2
   7        5       Test 1.1.1.1
  </code></pre>
  
  <p>If I filtered <code>ParentId = -1</code> I want get rows <code>ParentId = -1</code> and <code>children's +2</code> 
  lvl. </p>
  
  <p>If I <code>filtered Id = 2</code> I want get row <code>Id = 2</code> and <code>children's +2</code> 
  lvl.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I use MS SQL Server 2008, Entity Framework 6.1.3.
  I understand,  I can use 3 selects. But I looking effective method</p>