Hour 19

Quiz Answers

1: CommandBuilder will generate UPDATE and DELETE statements following which concurrency model?
  1. Pessimistic concurrency model

  2. Optimistic concurrency model

  3. Data update concurrency model

A1: b. The optimistic concurrency model, which means that other users can update data that has been selected by your application and your application must check for this before committing your updates.
2: True or false: Automatically generated commands will be created for all SelectCommands coded in Visual Basic or C#.
A2: False. You must explicitly activate this capability by using the CommandBuilder object.
3: What must be done following the change of a SELECT statement when using CommandBuilder to automatically generate code?
  1. Reassign SELECT variables ...

Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.