title: Linq System.OutofMemoryException
body: <p>I have a long running process in C# that hits a Sql table anywhere from 10 to 200 times.  When the process exceeds about 50 hits and queries greater than about 100,000 rows from the same table each time, it will throw a System Out of Memory Exception at this line, specifically at the bottom where it converts the IQuery object to a List:</p>
  
  <pre><code>var cht = from p in _db.TickerData
            where p.Time &gt;= Convert.ToDateTime(start) &amp;&amp;
            p.Time &lt;= Convert.ToDateTime(end)
            orderby p.Time
            select p;
  
  _prices = cht.ToList();    &lt; this is where the System.OutofMemoryException occurs &gt;
  </code></pre>
  
  <p>What can I do to prevent this error??</p>