nerdexam
Microsoft

70-516 · Question #252

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. You load records from a table named…

The correct answer is B. P1. SourceVersion = System.Eata.DataRowVersion.Original. See the full explanation below for the reasoning.

Question

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. You load records from a table named Products to a DataTable named dataTable. You populate a SqIDataAdapter by using the following code:

You need to ensure that optimistic concurrency is enforced on the Update call. Which code should you insert at line 08?

Exhibit

70-516 question #252 exhibit

Options

  • AP1.SourceVersion = System.Data.DataRowVersion.Current;
  • BP1. SourceVersion = System.Eata.DataRowVersion.Original;
  • CP1.SourceVersion = System.Data.DataRowVersion.Default;
  • DP1.SourceVersion = System.Data.DataRowVersion.Proposed;

How the community answered

(52 responses)
  • A
    15% (8)
  • B
    73% (38)
  • C
    4% (2)
  • D
    8% (4)

Community Discussion

No community discussion yet for this question.

Full 70-516 Practice