title: Entity framework linq query Include() multiple children entities
body: <p>This may be a really elementry question but whats a nice way to include multiple children entities when writing a query that spans THREE levels (or more)?</p>
  
  <p>i.e. I have 4 tables: <code>Company</code>, <code>Employee</code>, <code>Employee_Car</code> and <code>Employee_Country</code></p>
  
  <p>Company has a 1:m relationship with Employee.</p>
  
  <p>Employee has a 1:m relationship with both Employee_Car and Employee_Country.</p>
  
  <p>If i want to write a query that returns the data from all 4 the tables, I am currently writing:</p>
  
  <pre><code>Company company = context.Companies
                           .Include("Employee.Employee_Car")
                           .Include("Employee.Employee_Country")
                           .FirstOrDefault(c =&gt; c.Id == companyID);
  </code></pre>
  
  <p>There has to be a more elegant way! This is long winded and generates horrendous SQL</p>
  
  <p>I am using EF4 with VS 2010</p>