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 ...

Get Microsoft® ADO.NET 4 Step by Step 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.