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."
CommandBuilder will generate UPDATE and DELETE statements following which concurrency model?
True or false: Automatically generated commands will be created for all SelectCommands coded in Visual Basic or C#.
What must be done following the change of a SELECT statement when using CommandBuilder to automatically generate code?
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
The SelectCommand that will be used for the CommandBuilder must:
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.