Microsoft Exam Questions

What action should be taken?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp uses Data Contexts to access data from the database.
The Data Contexts allows PassGuideApp online changes to be submitted back to the SQL
Server.
PassGuideApp stores Employee data offline.
PassGuideApp enables end users to edit employee records while they are not connected to
PassGuideDB.
PassGuideApp must be able to detect conflicts between the offline and online data.
PassGuideApp must allow rollback of offline updates.
What action should be taken? Select all that apply.

A.
Add a try/catch statement around calls to the Submit Changes method of the Data
Context object.

B.
Catch Change context Exceptions

C.
Use method base.SubmitChanges(ConflictMode.ContinueOnConflict)

D.
Override the Update operation of the Data Context object

E.
Call the Executedynamic Update method to generate the update SQL

Explanation:

Use the Submit Changes method of the Data Context object with parameter System Data LINQ
ConflictMode.ContinueOnConflict.