Avi,
Are you saying you want the connection to participate in the
transaction, but you don't want it to use DTS? Whether or not it uses DTS
completely depends on a number of factors.
For example, if you are not using SQL Server 2005, then you can't
possibly use kernel mode for the transaction, as SQL Server 2000 doesn't
support kernel-mode transactions.
If you are not using MARS on the connection, and you issue another query
against an open connection in a transaction (say you have a data reader open
and you issue another query) , then you are going to start DTS.
Can you give more information about the setup you have and the
connections you are establishing?
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"Avi" <m@m.comwrote in message news:fi**********@news2.netvision.net.il...
Hi all,
How do I prevent new connections inside a TransactionScope from going up
to the DTS?
using (TransactionScope scope = new
TransactionScope(TransactionScopeOption.Required))
{ Open connection here }
Thanks,
Avi