Transaction rollback after every OracleTransaction block
Good morning,
We are using traditional ado.net SQL via 32 bit odp.net in a .NET 4 solution. We are noticing what appears to be a rollback statement issued after block of SQL statements within an OracleTransaction. Switching over to TransactionScope from OracleTransaction appears to fix the problem as well as going back to the .NET 2 Microsoft Oracle driver. At this point going back to the Microsoft driver is not an option as it is no longer supported by Microsoft going forward. Is anyone aware of a way to configure odp.net to not issue a rollback statement after every SQL statement(s) without having to switch everything over to using TransactionScope? Thank you.