title: LINQ include multiple children
body: <p>I have a construction that store databases metadata</p>
  
  <pre><code>public class Database {
      public string ConnectionString { get; set; }
      public virtual ICollection&lt;Table&gt; Tables { get; set; }
  }
  
  public class Table {
      public string TableName { get; set; }
      public virtual ICollection&lt;ForeingKey&gt; ForeingKeys { get; set; }
      public virtual ICollection&lt;Field&gt; Fields { get; set; }
  }
  </code></pre>
  
  <p>I would like to retrieve all database related data in one only query with LINQ
  I can query tables and one child entity from databases</p>
  
  <pre><code>            var qry = from d in context.Databases
                           .Include(x =&gt; x.Tables.Select( c =&gt; c.Fields))
                        select d;
  </code></pre>
  
  <p>But, how can I read two childs from Tables collection? Something like this</p>
  
  <pre><code> var qry = from d in context.Databases
               .Include(x =&gt; x.Tables.Include(t =&gt; t.Fields).Include(t =&gt; t.ForeingKeys))
             select d;
  </code></pre>