title: Efficient way to do bulk insert/update with Entity Framework
body: <p>I have a list of entities and I want to insert them into a database. If the entity already exists in the database as is then it needs to be skipped. If its in the database but with different values then it needs to be updated.</p>
  
  <p>Is there any way to do this other than do a db call per item?</p>
  
  <p>My plan is to try an insert, if a unique constraint exception on the key is thrown then do an update.</p>