Transactions

Links

• Implementing an Implicit Transaction using Transaction Scope (link)
• Concepts: Managing Connections and Transactions, (link)

System.Transactions

Excellent introduction text: Introducing System.Transactions, by Juval Lowy (online, download)

Isolation Level

Isolation Level of the Transaction decides what type of locks are used on the data.Default value is Serializable.

• IsolationLevel, MSDN (link)
• Snapshot isolation level, MSDN (link)

SQL Server-related

Controlling Transactions and Locks, part 5, Database Journal (link)