title: How to iterate large query
body: <p>I know how to make pagination but it doesn't fit my requirements because underlying query of pagination is updating itself whenever i need next paged result. So i am looking simple solution to iterate one by one whole results of query efficiently. Please take a look below example.</p>
  
  <pre><code>var urls = db.Websites.Select(s =&gt; s.Website)
               .Except(db.OldWebsites.Select(s =&gt; s.Website));
  
  foreach (var url in urls)
  {
     //process items
  }
  </code></pre>
  
  <p>I just want to know that the solution is really efficiently does iteration whole results or not. I am not exactly sure that the solution is loading rows one by one without loading all results to memory.</p>
  
  <p>Can someone verify this or suggest better solution ?</p>