Transaction Processing

A transaction is simply a group of tasks that either succeed or fail as a unit. For instance, suppose that your application runs a nightly import process to update its product-specification data. The specification data is stored in a set of six tables that are interrelated. That is, if you update one table, you must ensure that all new data makes it into the associated tables. These six tasks represent a transaction. They either all succeed (commit), or in the event of a failure, they all must fail (rollback). Imagine the chaos if you updated the model line but it still had the old colors and dimensions—or worse, prices. With proper transaction processing, no operation is permanent until all have successfully completed. ...

Get Visual Basic® Programmer's Guide to the .NET Framework Class Library 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.