Chapter 7. Transactions with ODP.NET
When programming systems with data distributed in different locations, your application must take on the responsibility of managing data integrity. In complex systems, such as those of a financial institution, applications have to frequently update data that resides in different databases. If something goes wrong somewhere in the chain, chaos can ensue if nothing is done to ensure that data integrity is maintained.
For example, if you were updating the address of a customer in three different databases, the operation can only be considered complete if all three databases were updated. If any one of these three updates failed, the updates that were successfully done on the other two databases must also be undone. ...
Get Pro ODP .NET for Oracle Database 11g 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.
