D
D
Dmitry Petrov2012-05-02 13:51:07
Microsoft
Dmitry Petrov, 2012-05-02 13:51:07

What are the analogues of TransactionScope?

At work, it became necessary to use transactions in the code that we still support. The architecture of the application is such that queries to the database go from 3-4 different assemblies, in some cases using stored procedures, with 3-4 adapters. Sometimes more.
Tried TransactionScope. On the test local server, it worked without problems, but on the main production server, there were problems with the MSDTC service: it started, but distributed transactions did not start. If you manually execute the “BEGIN DISTRIBUTED TRANSACTION” request, then we get the error “MSDTC on server 'server' is unavailable.”, and the server log says “Resource Manager Creation Failed: 0x8004d01c (error not found)”. The MSDTC service is up and running, checked multiple times. I didn’t rummage through the problem, but the admins say that the problem is in the version of the server - it needs to be updated, and we have problems with this, the server is constantly and quite heavily loaded, reboots are planned in advance for a long time.
I decided to look at alternative methods. The method with creating a separate connection, starting a transaction in it and pushing this connection to all the required adapters does not look very convenient, refused.
Maybe there are other ways that are similar in ease of use to transactionscope?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
mayorovp, 2012-05-04
@mayorovp

Do you have one database or several?
If one, then the use of MSDTC is a serious design error.
Don't nest one TransactionScope within another and everything will work.

D
Dmitry Petrov, 2012-05-04
@Sellec

TransactionScope do not work at all, I wrote above, I need their analogue.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question