PrepAway - Latest Free Exam Questions & Answers

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.

PrepAway - Latest Free Exam Questions & Answers

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.

One Comment on “What action should be taken?

  1. John Galt says:

    I believe the answer is incomplete. Check the following link:
    http://msdn.microsoft.com/en-us/library/bb387001%28v=vs.110%29.aspx

    It looks like you need to do the following:
    A. Add a try/catch statement around SubmitChanges
    B. Catch ChangeConflictException (really bad type in the question above – took a while to figure it out)
    C. Use method base.SubmitChanges(ConflictMode.ContinueOnConflict)

    The answer specified will only rollback the conflicts, but won’t let you detect them (and enumerate them).




    0



    0

Leave a Reply