title: How entity framework works for large number of records?
body: <p>I see already a un-answered question <a href="https://stackoverflow.com/questions/14205033/entity-dealing-with-large-number-of-records-35-mlns">here on</a>.</p>
  
  <p>My question is -</p>
  
  <blockquote>
    <p>Is EF really production ready for large application?</p>
  </blockquote>
  
  <p>The question originated from these underlying questions -</p>
  
  <ol>
  <li>EF pulls all the records into memory then performs the query
  operation. How EF would behave when table has around ~1000 records?</li>
  <li>For simple edit I have to pull the record edit it and
      then push to db using <code>SaveChanges()</code></li>
  </ol>