Question about TransactionScope

  • Thread starter Thread starter Max2006
  • Start date Start date
M

Max2006

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
 
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.
 
Back
Top