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?

	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.
	Call the SaveChanges method of the DbContext instance, specifying the UpdateBehavior.All enumeration value for the Update behavior.
	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.