EF Core 2.1 and ambient transactions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Eric_08
Posts: 19
Joined: Wed 11 Jul 2018 21:50

EF Core 2.1 and ambient transactions

Post by Eric_08 » Fri 27 Jul 2018 17:27

I'm trying to use .NET Core TransactionScope() feature. The code compiles and runs against Oracle 12.1, DevArt 9.6.558. When I look in EF Core logs, I see a warning that provider does not support ambient transactions. The warning looks like this:

An ambient transaction has been detected. The current provider does not support ambient transactions. See http://go.microsoft.com/fwlink/?LinkId=800142

I understand ambient transactions support has only been added in EF Core 2.1, so when you are going to support it?

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

Re: EF Core 2.1 and ambient transactions

Post by Shalex » Mon 30 Jul 2018 13:04

We will investigate the question and notify you about the result.

Eric_08
Posts: 19
Joined: Wed 11 Jul 2018 21:50

Re: EF Core 2.1 and ambient transactions

Post by Eric_08 » Thu 09 Aug 2018 12:57

Any updates on this issue?

philippe.camou
Posts: 1
Joined: Thu 06 Mar 2014 11:12

Re: EF Core 2.1 and ambient transactions

Post by philippe.camou » Mon 13 Aug 2018 09:01

Hi Guys.

Same issue and same question : any news on the date to support TranssactionScope ?

Kind regards

Philippe

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

Re: EF Core 2.1 and ambient transactions

Post by Shalex » Tue 14 Aug 2018 12:53

  • The bug with throwing "ORA-02089: COMMIT is not allowed in a subordinate session" when working with distributed transactions in the OCI mode via .NET Standard 2 assemblies is fixed
  • The misleading "The current provider does not support ambient transactions." warning, generated by TransactionScope in EF Core 2.1, is disabled
We will provide the internal build with the fix soon.

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

Re: EF Core 2.1 and ambient transactions

Post by Shalex » Wed 15 Aug 2018 19:06

The internal build with the fix is available at https://www.devart.com/pub/nuget_oracle_9_6_573.zip.

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

Re: EF Core 2.1 and ambient transactions

Post by Shalex » Fri 31 Aug 2018 18:03

New build of dotConnect for Oracle 9.6.584 is available for download now: viewtopic.php?f=1&t=37637.

Post Reply