Distributed transactions on .NET 7 on Windows

[K-Wojciechowski]

.NET 7 (which was recently released) has added support for distributed transactions on Windows using MSDTC (dotnet/runtime#715). Is support for this feature planned in ODP.NET Core? This would help resolve issues with opening multiple connections to a server (eg. #198).

[hiou1210]

We really need that feature.

[mihaimyh]

What about linux, is it supported?

[alexkeh]

.NET distributed transactions on Linux is not yet supported.

dotnet/runtime#71769

[alexkeh]

There's a new feature in managed ODP.NET and ODP.NET Core 23.7 called session transactions that can address some distributed transaction use cases. This feature allows one session to suspend a transaction in one session, then resume the same transaction in a new session, continue DML work, and commit.

If you have a distributed transaction that spans two or more sessions connecting with the same user to the same DB, you can use a sessionless transaction to replace it. The sessionless transaction will be lighter weight than the distributed transaction, and it's possible to use it in .NET Core on any platform.

You will need Oracle Database 23.6 and higher as well.