Hi,

Does TransactionScope need DTC in situations that the transaction is not 
distributed?
I have a set of non-distributed transactions and I am not sure that 
TransactionScope is the best option for best practice perspective.

Thank you,
Max

Usually applications close connections as soon as possible, and a new
connection in a transaction scope usually causes it to be promoted to DTC.
If you have only one thread to handle data access, you can try the help
class described in
http://blogs.msdn.com/dataaccess/archive/2006/02/14/532026.aspx


-- 
Sheng Jiang
Microsoft MVP in VC++
"Max2006" <alanalan1@newsgroup.nospam> wrote in message
news:umk72bWyHHA.2172@TK2MSFTNGP06.phx.gbl...

> Hi,
>
> Does TransactionScope need DTC in situations that the transaction is not
> distributed?
> I have a set of non-distributed transactions and I am not sure that
> TransactionScope is the best option for best practice perspective.
>
> Thank you,
> Max
>
>

Hello Max,
Thanks for Sheng's cool info.

Just as Sheng's reply, TransactionScope will be promoted to DTC When two 
connections opened in the same transactionscope. Therefore, I would like to 
suggest you use SQLTranscation if you needn't DTC.

Hope this helps. Please feel free to update here if you have any unclear. 
We are glad to assist you.
Have a great day,
Sincerely,
Wen Yuan
Microsoft Online Community Support 
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Max,

This is Wen Yuan again. I just want to check if there is anything we can 
help with.
Please feel free to update here if you have anything unclear. We are glad 
to assist you.

Have a great day,
Sincerely,
Wen Yuan
Microsoft Online Community Support 
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Wen,

I made sure that I am using the same connection and I disabled the DTC NT 
service and the code worked fine. Meaning the application is not using DTC.

Thanks for hlp.
Max



"WenYuan Wang [MSFT]"  wrote in message 
news:GeeFLmfzHHA.360@TK2MSFTNGHUB02.phx.gbl...

> Hello Max,
>
> This is Wen Yuan again. I just want to check if there is anything we can
> help with.
> Please feel free to update here if you have anything unclear. We are glad
> to assist you.
>
> Have a great day,
> Sincerely,
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no 
> rights.
> 

Hello Max,
Thanks for your reply.

It's a great news that the code worked fine.
We are glad to assist you.

If there is anything we can help with, please feel free to update here 
again. 
Have a great day,
Best regards,
Wen Yuan
Microsoft Online Community Support  
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.