There is an update query in progress, the transaction is started at a higher level on the connection. In order to ensure that all server data is in a valid state for the update, i need to do a couple reads. Transactionscope offer broader options, begintransaction has a simpler api transactionscope allows to customize the transaction timeout, support nested transactions with various …

New in. net 2. 0, the transactionscope object (system. transactions. dll) allows use over a range of operations (suitable providers will automatically … Transaction must be atomic (it is one unit of work and does not dependent on previous and following transactions), consistent (data is either committed or roll back, no “in-between” case where … Begin transaction / commit extends this locking functionality to the work done by multiple statements, but it adds nothing to single statements. However, the database transaction log is …