# IT:AD:EF/CodeFirst:HowTo:Queries/Include Nested Tables #



<callout type="Navigation" class="small">

* [[../|(UP)]]
{{indexmenu>.#2|nsort tsort}}


</callout>


<panel title="Summary">

There are a couple of different ways to do it.


</panel>


## Process ##

There's the old string way:

<sxh csharp>
using (AppDbContext context = new AppDbContext())
{
var invoice = context.Invoices.Include("LineItems.Product").FirstOrDefault();
var product = invoice.LineItems.First().Product;
Debug.Assert(product!=null);
}

</sxh>

and the include/select:

<WRAP tip>
Note how it can be nested indefinately...
</WRAP>

<sxh csharp>

using (AppDbContext context = new AppDbContext())
{
  var lineItem = context.Invoices
                        .Include(i => i.LineItems.Select(li => li.Product))
                        .FirstOrDefault();
  var product = invoice.LineItems.First().Product;
  Debug.Assert(product != null);
}

</sxh>