Question

Query and manipulate data - by using Data Provider for Entity Framework

The application you’re working on uses the EF to generate a specific DbContext instance. The application enables users to edit several items in a grid and then submit the changes. Because the database is overloaded, you frequently experience situations that result in only partial updates. What should you do?

	Create a Transaction instance by calling the BeginTransaction method of the DbContext Database property. Call the SaveChanges method; if it is successful, call the Commit method of the transaction; if not, call the Rollback method.
	Call the SaveChanges method of the DbContext instance, specifying the UpdateBehavior.All enumeration value for the Update behavior.
	Use a TransactionScope class to wrap the call to update on the DbContext instance.
	Use a TransactionScope class to wrap the call to SaveChanges on the DbContext. Call Complete if SaveChanges completes without an exception.