title: how to show hierarchical data from table with hierarchyid data type in tree view in vb.net?
body: <p>I have a table with this structure :  </p>
  
  <pre><code> create table shajare (
      node hierarchyid PRIMARY KEY CLUSTERED ,
  level AS node.GetLevel() PERSISTED,
  person_id int Unique,
  person_name Nvarchar(30) Not null);
  </code></pre>
  
  <p>and I use this in SQL Server to show all children of a given parent:</p>
  
  <pre><code>select * 
  from shajare as parent
  inner join shajare as child on child.node.IsDescendantOf(parent.node) = 1
  where parent.person_id = 12      
  </code></pre>
  
  <p>How can I show the children of a parent in a tree view by do not using recursive function or using some thing like that SQL code but by linq ? My boss asked for linq???</p>
  
  <p>Please !!</p>