Links
Excellent introduction text: Introducing System.Transactions, by Juval Lowy (online, download)
Isolation Level of the Transaction decides what type of locks are used on the data.Default value is Serializable.
Controlling Transactions and Locks, part 5, Database Journal (link)