SqlTransaction and Sql server named transactions

  • Thread starter Thread starter Ben Fidge
  • Start date Start date
B

Ben Fidge

I've noticed that one of the overloaded constructors for SqlTransaction
takes a transaction name as a string. How do these "named" transactions work
and how are they intended to be used?

Thanks

Ben
 
The named transactions are used with save points to which you can roll back.
It's instead of nested transactions, which you use with the OleDB .NET Data
Provider.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SqlTransactions vs. transactions in the SQL code 1
Business Layer and Transactions in the Data Layer 5
transaction problems 2
Nested transactions with SQL connection object - how? 0
SqlTransaction question 3
Using SqlTransaction with MSSQL Trans? 3
What type of transactions do you use now? 1
Transaction Isolation Level 1

Back
Top