vdhant

Hi guys

I have been playing round with the transaction scope for some work that i am doing at the moment and i found that the biggest problem i was coming across with the connection problems. When i looked around on this topic, i found that DBConnectionScope. Now this seems perfect but when i was taking a closer look at the code i noticed that it uses [ThreadStatic] variable to store the connections. Now not that i have had that much experience with ThreadStatic and asp.net but i know some of the treading scenarios are a bit different. Thus is it safe to use the DBConnectionScope class if it relies on a ThreadStatic variable to manage its connections.

Also just wondering has there been any change in thoughts in this area recently in regards to solving the problem that DBConnectionScope aims to face Are there any better solutions out there or is this the best one Reason I ask is that I noticed that this was created a little while ago and just thought that there might be some changes.

Thanks

Anthony



Re: Transactions Programming TransactionScope and DBConnectionScope in ASP.net

vdhant

anyone got any ideas on this one

Thanks

Anthony





Re: Transactions Programming TransactionScope and DBConnectionScope in ASP.net

Florin Lazar - MSFT

DBConnectionScope or similar is the best you can do today. I'm sure the SQL Server team is working on improving the experience with multiple connections in a future release.






Re: Transactions Programming TransactionScope and DBConnectionScope in ASP.net

vdhant

Thanks for your help

Anthony