Distributed transaction

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
maros522
Posts: 1
Joined: Wed 11 Dec 2019 13:32

Distributed transaction

Post by maros522 » Wed 11 Dec 2019 14:04

Hello, we are using .net core with devart. In our test we open two connection with same connection string but under one using (TransactionScope transScope = new TransactionScope()). This creates distributed transaction but at .net core there is no support for distributed transaction (at the db there are two connections which are tightly coupled). How this feature works in context of .net core? Do you have own distribution coordinator which is part of devart dll? Does the commit of .net transaction works as commit on distributed transaction (two phase)? ....

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Distributed transaction

Post by Shalex » Fri 13 Dec 2019 18:47

https://www.nuget.org/packages/devart.data.oracle > the Dependencies section

There are two sets of Devart assemblies:

1) .NET Standard 1.3 -> TransactionScope is not supported

2) .NET Standard 2.0 -> TransactionScope is supported but its workability depends on the run-time.
* If you install our package to the .NET Framework 4.7/4.8 project, TransactionScope will work successfully using full .NET Framework implementation.
* In the case of .NET Core project, there is no corresponding implementation at the moment: https://github.com/dotnet/runtime/issues/715.

Post Reply