title: How to display grandparent when child is given
body: <p>How to display grandparent when 'childItemNo' is given.</p>
  <p>Below is my model: Any record (ItemNo) can become a grandparent, parent or child.</p>
  <pre><code>public partial class item
  {      
      public string ItemNo { get; set; }         
      public string ParentItemNo { get; set; }     
  }
  </code></pre>
  <p>Below query returns parent when childItemNo is given: Would like to display grandparent as well.</p>
  <pre><code>  var result =  DbContext.ItemTables.Where(p =&gt; p.ItemNo== childItemNo).Select(p =&gt; p.ParentItemNo).ToListAsync(); 
  </code></pre>
  <p>Thank you.</p>