title: Iterating through IQueryable with foreach results in an out of memory exception
body: <p>I'm iterating through a smallish (~10GB) table with a foreach / IQueryable and LINQ-to-SQL.
  Looks something like this:</p>
  
  <pre><code>using (var conn = new DbEntities() { CommandTimeout = 600*100})
  {
       var dtable = conn.DailyResults.Where(dr =&gt; dr.DailyTransactionTypeID == 1);
       foreach (var dailyResult in dtable)
       {
          //Math here, results stored in-memory, but this table is very small. 
          //At the very least compared to stuff I already have in memory. :)
       }
  }
  </code></pre>
  
  <p>The Visual Studio debugger throws an out-of memory exception after a short while at the base of the foreach loop. I'm assuming that the rows of dtable are not being flushed. What to do? </p>