Distributed Transaction support - has it been implemented for Net 7?

Howard Reagor 6

My understanding is that Net 7 would have distributed transaction support enabled for Windows only. I installed Net 7 and distributed transaction support does not appear to work. Windows 10 , WPF/MVVM application. Currently running under .Net 6, but the application was originally written in the framework where distributed transactions did work.

Oracle is the main database, but also have some connects to SQL and Progress.

Don Reynolds 0 Reputation points

2023-01-21T00:34:28.1433333+00:00

I had a solution and tests in .NET Framework 4.x that worked fine using system.transactions.

I ported to .NET 6 and they did not work, but the online documentation mentioned system.transactions was not yet ported.

Prior to .NET 7 release I saw articles mentioning that system.transactions would be ported for Windows only.

I ported to .NET and ran my tests again, which still did not work. I'm using all the latest versions of everything (Windows 11, SQL Server 2022, Microsoft.Data.SqlClient 5.1.0, Visual Studio 2022 v17.4.4, etc).

I'm using CommitableTransaction and explicit transactions to SQL Server with Microsoft.Data.SqlClient. I get the following exception whenever the second sql connection enlists:

"System.NotSupportedException: Implicit distributed transactions have not been enabled. If you're intentionally starting a distributed transaction, set TransactionManager.ImplicitDistributedTransactions to true."

This seems like a misleading error message since I'm using an explicit transaction.

I can see the activity in Component Services. The transaction shows up then aborts each time.

Could someone at Microsoft tell us if system.transactions was officially ported and how much functionality is working? Thanks.
Don Reynolds 0 Reputation points

2023-01-21T00:36:29.56+00:00

I implemented explicit distributed transactions in .NET 4.x with SQL Server in Windows, which worked fine.

When I ported to .NET 6, it didn't work and the documentation online said system.transactions was not ported.

I saw an article saying that system.transactions was being ported for Windows only in .NET 7, but I saw nothing about it in release notes, etc.

I tried to run my distributed transaction tests, which uses a CommitableTransaction to create explicit transactions. I get the following exception as soon as the second sql connection tries to enlist:

"System.NotSupportedException: Implicit distributed transactions have not been enabled. If you're intentionally starting a distributed transaction, set TransactionManager.ImplicitDistributedTransactions to true."

It seems like a misleading error message because I'm using explicit transactions.

I can watch the activity in Component Services, which shows the transaction immediately aborting.

Could someone from Microsoft please let the community know if system.transactions was ported to .NET 7 and what functionality should work? Thanks.
Don Reynolds 0 Reputation points

2023-01-21T00:38:28.1266667+00:00

I apologize for duplicate comments. The website lags after you add a comment/answer, so I thought my first one didn't go through, and there is no way to remove them.

2 answers

Bruce (SqlWork.com) 69,501 Reputation points

2022-11-30T21:17:56.61+00:00

MSDTS support was added in net 5.

https://learn.microsoft.com/en-us/dotnet/api/system.transactions.transactionscope?view=net-7.0

also see thread:

https://github.com/dotnet/runtime/issues/715

each .net core native database driver needs to add support. sqlserver has support. see your database vendor for their support.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Howard Reagor 6 Reputation points

2022-12-01T15:31:42.927+00:00

I don't believe it was added in Net 5 actually. The 715 issue you refer to is for the change to occur in .Net 7. I also tried using just SQL database instead of Oracle and in Net 6 I get "This platform does not support distributed transactions.". However, in Net 7 running the same code, I get this error "Implicit distributed transactions have not been enabled. If you're intentionally starting a distributed transaction, set TransactionManager.ImplicitDistributedTransactions to true."

So, it appears it was added in Net 7, and I think SQL would work if that property mentioned above set to true. However, Oracle databases accessed give the same error message in Net 7 as in Net 6. So, I am guessing this is an Oracle driver issue.
Please sign in to rate this answer.
Bruce (SqlWork.com) 69,501 Reputation points

2022-12-01T21:10:16.28+00:00

for sqlserver did you use Microsoft.Data.SqlClient instead of the obsolete System.Data.SqlClient nuget package?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Distributed Transaction support - has it been implemented for Net 7?

2 answers

Your answer