Using Transactions

Summary

In this chapter you learned what transactions are and when to use them. You learned about the ACID properties of transactions and that transactions either complete successfully and are committed or fail at some point and are rolled back so the database is left in its original state before the transaction began. You then learned that you can write database transactions in SQL and in VB .NET. You also learned about concurrency and locks; these are key topics in the realm of transactions, as without them you would have no guarantee that information held in databases would remain consistent with the real world.