Workshop

for RuBoard

These quiz questions are designed to test your knowledge of the material covered in this chapter. The answers to the quiz questions can be found in Appendix A, "Answers to Quizzes."

Quiz

1:	CommandBuilder will generate UPDATE and DELETE statements following which concurrency model? Pessimistic concurrency model Optimistic concurrency model Data update concurrency model
2:	True or false: Automatically generated commands will be created for all SelectCommands coded in Visual Basic or C#.
3:	What must be done following the change of a SELECT statement when using CommandBuilder to automatically generate code? Reassign SELECT variables Refresh metadata Close connection Open connection
4:	True or false: The following SELECT statement is valid for using with CommandBuilder : SELECT a.*, b.* FROM Customers a, Orders b WHERE a.CustomerID = b.CustomerID
5:	The SelectCommand that will be used for the CommandBuilder must: Include a SELECT Distinct clause Contain all columns in the table Return at least one primary key or unique column Contain a WHERE clause with at least one filter

Exercise

Take (download) the original non- CommandBuilder sample code (19NormalUpd.vb) and manually convert it to use automatically generated commands with CommandBuilder . You can use either the OleDBCommandBuilder or SqlCommandBuilder objects.

After you have completed this conversion (and it works!), add in an insert and delete that also uses the automatically generated commands.

for RuBoard