Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TransactionScope and SQL Server Locks
Message
De
11/04/2012 01:04:58
 
 
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
01540816
Message ID:
01540986
Vues:
46
>>Yes, that was stated in the last paragraph in my original post (what I quoted above). This is a new Transaction (TransactionScopeOptions.RequiresNew) ... therefore, I assumed that it would not be dragged into the ambient distributed transactions. Is this a valid assumption?
>>
>>~~Bonnie
>
>From the point of SQL Server, if one transaction is started and not yet committed, everything that starts in the middle of it will be part of that transaction. I am not sure how distributed transactions work in .NET, but I assume this would hold true also.


After further testing, I discovered that the TransactionScopeOption.RequiresNew means that the new Transaction doesn't get enlisted in the existing Distributed Transactions, so I'm good to go now. I hoped that was the case and I'm glad I was right.

~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform