Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does TransactionScope Need DTC Service on?

From what I'm reading, in order to use TransactionScope in .NET, you need the Distributed Transaction Coordinator service in Windows to be running. I have that service turned off, and my app seems to be running the same and rolls back transactions no problem.

Am I missing something? How is it able to work? I'm running Windows 7 and running the webapp off VisualStudio 2010.

like image 215
SaltProgrammer Avatar asked Jan 31 '12 05:01

SaltProgrammer


2 Answers

More modern versions of windows have a mini DTC version in kernel. It is not distributed but uses the same API - but it can only handle one ressource per transaction scope.

TransactionScope uses that at a start, then "promotes" the transaction to the real DTC the moment a second resource is added (resource in your case is a database connection). So, as long as your use case is ismple, you avoid the (high) overhead of the DISTRIBUTED part of DTC and can work without the service running.

More information about the Kernel Transaction Managger can be found at http://en.wikipedia.org/wiki/Kernel_Transaction_Manager

MS added it also because NTFS got transactional and it needed to make sure a DTC is aavailable.

http://www.codeguru.com/cpp/article.php/c18309/

like image 52
TomTom Avatar answered Nov 16 '22 04:11

TomTom


MSDTC comes into the play only if you have more than one transaction with different connections

SO, the answer is:

It depends!

  • If you use 1 TranScope per 1 connection - then NO
  • If you use 1 TranScope per more than 1 connection - then YES
  • If you created TransactionScope object which requires Distributed transaction - then YES
like image 36
Oleg Dok Avatar answered Nov 16 '22 04:11

Oleg Dok