Chapter 12. Guaranteeing Data Integrity
After completing this chapter, you will be able to:
Understand ADO.NET’s use of optimistic concurrency
Perform transactions that include multiple record updates
Spread transactions across multiple databases
Database programming would be a meaningless task if there were no way to guarantee the integrity of the data. Having a single user update a single record with no one else to interrupt the process is one thing. But what happens when you have dozens—or hundreds—of users all trying to update records in the same tables, or even the same records, at the same time?
Welcome to the world of transactions—database operations that enable multiple record updates to be treated as a single unit. This chapter introduces ...