title: How to implement SQL Server paging using C# and entity framework?
body: <p>I have to update every row in a Sql Server table with about 150,000 records using entity framework.  To reduce the amount of hits the server takes, I would like to do this in separate batches of 1000 rows.  I need entity framework to:</p>
  
  <ol>
  <li>Select the first 1000 rows from the DB.</li>
  <li>Update those rows.</li>
  <li>Call SaveChanges() method.</li>
  <li>Get next 1000 rows.</li>
  <li>Repeat.</li>
  </ol>
  
  <p>Whats the best way to achieve this?</p>
  
  <p>I'm using entity framework 4 and SQL Server 2012.  </p>