tags:

views:

55

answers:

1
Q: 

TransactionScope how can I tell if a Connection has been enlisted

I have a method that has a connection as one of it's parameters:

e.g. public void Foo(SqlConnection pConn) { }

within Foo is it possible to determine if pConn is enlisted in any transactionscope?

A: 

If its sql server issue a select @@trancount would be one way

Andrew  2009-10-16 18:28:06
I don't think this will work unless you execute it on from within the connection that's supposed to be attached to the transaction. If, for example, while you have a break-pointed code in the middle of a transaction, and you do 'select @@trancount' in SSMS, it'll return 0.
Yoopergeek  2009-11-06 21:45:33

related questions

Why does the following SQL Server insert deadlock when run within a transaction?
TransactionInDoubtException using System.Transactions on SQL Server 2005
How to know if the code is inside TransactionScope?
Using TransactionScope with MySQL and Read Lock
Is there a way to use TransactionScope with an existing connection?
new System.Transactions.TransactionScope() on background thread halts program
MSMQ Vista x64
Why doesn't TransactionScope work with Entity Framework?
How do I use TransactionScope in C#?
TransactionScope timeout wierdness with TransactionScopeOption.RequiresNew
Trying to understand TransactionScope
HRESULT: 0x8004D00E using TransactionScope - C#
TransactionScope, linq and strange transaction manager issue (HRESULT: 0x8004D024)
TransactionScope and Isolation Level
Nesting transaction scopes for integration tests using Rhino Commons UnitOfWork
NHibernate with TransactionScope
Inner Transactionscope error: "Communication with the underlying transaction manager has failed"
High volumn site using ADO.NET TransactionScope vs ExecuteCommand on NOLOCK, READ UNCOMMITTED directly?
In .Net, can I specify a default application wide Isolation Level?
SharePoint 2007: How can I perform a series of operations within a transaction?
How does TransactionScope roll back transactions?
TransactionScope not rolling back transaction
Is this safe? - NUnit base class opens and rollsback a TransactionScope
TransactionScope Error against Sql Server 2000 - The partner transaction manager has disabled its support for remote/network transactions.
SQL Server 2000 and System.Transactions.TransactionScope()