Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Catch 22
Message
From
10/09/2013 12:29:29
 
General information
Forum:
ASP.NET
Category:
Other
Title:
Environment versions
Environment:
C# 4.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01581904
Message ID:
01582725
Views:
38
>I've discussed this problem with David Browne from MS by email and the problem seems to be in the fact that we're opening the connection prior to instantiating this TransactionScope object and so the existed connections will not enlist in the transactions.
>
>I'm going to verify if .NET documentation explicitly states this fact but now what should I do?
>
>Thanks.


That makes sense that it would work this way, I guess. You shouldn't leave connections open for any longer than necessary (but you probably already know that), so the question is *why* is your connection already open? And obviously, that part of your code (opening the connection) needs to also be within a TransactionScope.
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform