EntityFramework + TransactionScope + rollback problem

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
ak78
Posts: 1
Joined: Wed 17 Dec 2014 09:53

EntityFramework + TransactionScope + rollback problem

Post by ak78 » Wed 17 Dec 2014 10:14

It looks like provider 8.1.55.0 has bugs. Trial 8.4.303 works as 8.1.55.0.
This is an example of pseudo code
...
var conn = (EntityConnection)context.Connection;
conn.Open();
using (var scope = new TransactionScope()
{
// inserts successfully data to table A
// here I can see the result in table A via another connection
// run invalid sql query
scope.Complete();
}
// here I can see the result in table A via another connection
How can it be???
Please, help investigate & solve this problem.

P.S. I have found similar problem, but "Enlist" parameter in connection string did not help me...

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

Re: EntityFramework + TransactionScope + rollback problem

Post by Shalex » Mon 22 Dec 2014 13:16

Thank you for your report. I cannot reproduce the described problem in our environment at the moment. Please send us a small test project with the corresponding DDL/DML script for reproducing.

Post Reply