Questions tagged [system.transactions]
37 questions
1
vote
2 answers
SqlClient.SqlTransaction vs System.Transactions
We have some constant issues with MSDTC setting up, now considering replacing SystemTransactions with SqlTransactions.
I am interested in differences of the above, and possible issues we might have doing that.

user1117513
- 21
- 3
0
votes
3 answers
How to atomic select rows in Mysql?
I have 5+ simultaneously processes selecting rows from the same mysql table. Each process SELECTS 100 rows, PROCESS IT and DELETES the selected rows.
But I'm getting the same row selected and processed 2 times or more.
How can I avoid it from…

newx
- 595
- 7
- 16
0
votes
2 answers
Execute code only if parent transaction completes
The code below will output:
Event published
Command executed
Using System.Transactions how can I have the EventPublisher enlist in a parent transaction such that it only executes if the CommandHandler completes. The output would therefore…

Ben Foster
- 34,340
- 40
- 176
- 285
0
votes
0 answers
.NET transactions, Mongo DB, 2 phase commit vs. single phase commit
We are integrating Mongo DB as the database in our .NET based system.
Since data consistency is required in our system, we need to support transactions.
Mongo DB v4.0 supports transactions, but in order to integrate it with the .NET…

Metheny
- 1,112
- 1
- 11
- 23
0
votes
1 answer
How to verify TransactionScope works with MySQL?
I want to add read uncommitted isolation level.i know it is possible to do with SQL statement. but I want to try with TransactionScope and I tried but not getting any isolation statements on MySQL general logs.
Questions
1 does transactionscope…

Atulya
- 153
- 1
- 11
0
votes
1 answer
TransactionScope throws TransactionAbortedException when Disposed
I have the following scenario:
Parent process start TransactionScope, a token identifying the transaction is created using TransactionInterop.GetTransmitterPropagationToken, inserts data to database. TransactionScope completes.
Another process is…

Adam
- 45
- 1
- 6
-1
votes
1 answer
error CS0234 The type or namespace name 'Transactions' does not exist in the namespace 'System' (are you missing an assembly reference?)
I just upgraded from VS2015 to VS2017 Professional and my solution which was building fine on VS2015 is now failing to build on VS2017 with the following error:
error CS0234: The type or namespace name 'Transactions' does not exist in the namespace…

Masoud Safi
- 102
- 1
- 6