title: What does the entity framework do with locking sql server
body: <p>I'm not a real database expert, and i was wondering if you could tell me what kind of lock Sql server uses in combination with the entity framework in the following cases:</p>
  
  <p>I read 40 records from a table, update them in code and call SaveChanges to the context</p>
  
  <p>I read 1 record from a table, update it in code and call SaveChanges to the context</p>
  
  <p>I create 1 new record (object) in code and call SaveChanges to the context</p>
  
  <p>I create 40 new records (object) in code and call SaveChanges to the context</p>
  
  <p>I also wondered, is it somehow possible to see which locks are used (set?) by Sql Server?</p>
  
  <p>Michel</p>