title: How to do the opposite of eager-loading in Entity Framework?
body: <p>I understand in Entity Framework you can specify relationships that need to be joined with <strong>Include</strong>:</p>
  
  <pre><code>Product firstProduct = 
         db.Product.Include("OrderDetail").Include("Supplier").First();
  </code></pre>
  
  <p>But we have the <strong>opposite</strong> issue that a simple LINQ statement is getting making <strong>too <em>many</em> JOINs</strong> on the SQL server. </p>
  
  <p>So how do we do the opposite, i.e. tell Entity to <strong>not</strong> do any deep loading of joined tables when it gets all the orders, so that on the SQL Server it executes:</p>
  
  <pre><code>SELECT * FROM Orders
  </code></pre>