O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Workshop

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:Which method of the SqlTransaction object finalizes a transaction? How is this done in T-SQL?
2:In ADO.NET, a database transaction is started by using which object?

Exercise

Try to implement a simple financial transaction example, like the one mentioned in the introduction of this hour. Create two database tables, one for bank A and one for bank B. Then create a procedure that copies the checking and savings balance from one bank to another for a given AccountID. Make sure, of course, to use a transaction to perform the transfer.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required