title: Entity Framework slow with large datasets
body: <p>I am using entity framework to retrieve a large dataset.</p>
  
  <p>The dataset set has a parent/child relationship, and I need to bring back the child information at the same time as the parent.</p>
  
  <p>What I am finding is that EF sends one query initially to get the list of parent objects, and then iterates through each parent object and queries the DB for the child information.</p>
  
  <p>So if I have 1000 parent objects, I end up with a total 1001 calls to the DB (once for each parent object, plus the original query that gets the list of parents).</p>
  
  <p>Is there anyway to make EF query this is a more efficient manner?  Something like:</p>
  
  <pre><code>SELECT * FROM CHILD_OBJECT_TABLE WHERE PARENTID IN (LIST OF PARENT_IDS HERE)
  </code></pre>