title: EF - Why doesn't Include work on Properties
body: <p>So I have classes that looks like this.</p>
  
  <pre><code>public class User {
      public virtual IList&lt;Member&gt; Members {get;set;}
  }
  
  public class Member {
      public virtual AnotherTable Another {get;set;}
  }
  
  public class AnotherTable {
      public string Name {get;set;}
  }
  </code></pre>
  
  <p>When I perform the query directly against the DataContext the Include works, but when I do an AsQueryable() on the IList of members the include doesn't work.</p>
  
  <p>Is there a way to have Include/Eager functionality on lazy loaded properties, such as the Members property above, or do I always have to go through the DataContext to get that feature?</p>
  
  <pre><code>User.Members.AsQueryable().Include(a =&gt; a.Another).ToList() // &lt;-- nada, no way Jose
  _db.Members.Include(m =&gt; m.Another).ToList() // &lt;-- all good in the neighborhood
  </code></pre>
  
  <p>I ask cause it can be a huge difference of 1 sql query vs. 100 queries for something result equivalent.</p>
  
  <p>Thanks in advance.</p>