title: Select multiple nested levels of child tables in Entity Framework Core
body: <p>I want to get multiple nested levels of child tables in Entity Framework Core using eager loading. I don't think lazy loading is implemented yet.</p>
  
  <p>I found an <a href="https://stackoverflow.com/questions/3356541/entity-framework-linq-query-include-multiple-children-entities">answer</a> for EF6.</p>
  
  <pre><code>var company = context.Companies
                   .Include(co =&gt; co.Employees.Select(emp =&gt; emp.Employee_Car))
                   .Include(co =&gt; co.Employees.Select(emp =&gt; emp.Employee_Country))
                   .FirstOrDefault(co =&gt; co.companyID == companyID);
  </code></pre>
  
  <p>My problem is that <code>Select</code> is not recognized in EF Core</p>
  
  <blockquote>
    <p>Error  CS1061  'Employees' does not contain a definition for 'Select' and no extension method 'Select' accepting a first argument of type 'Employees' could be found (are you missing a using directive or an assembly reference?) </p>
  </blockquote>
  
  <p>My included namespaces:</p>
  
  <pre><code>using MyProject.Models;
  using Microsoft.Data.Entity;
  using System.Collections.Generic;
  using System.Linq;
  using System.Threading.Tasks;
  </code></pre>
  
  <p>What is the alternative for <code>Select</code> in EF Core.</p>