Devart Forums

Are there any provisions to support transactions via the Entity Framework and Oracle? Using TransactionScope has never worked well with Oracle in the past because it always gets elevated to be a distributed transaction (even when one was not necessary) and Oracle does not handle those efficiently at all.

If the EF doesn't support it, do you guys make some kind of provision for your own transactional support?

The support of TransactionScope is available since dotConnect for Oracle 5.0.1 beta.

Right, but since TransactionScope upgrades a transaction to a distributed transaction (which Oracle doesn't seem to manage so well) are there any other options available? Or does your library ensure it isn't a distributed transaction unless it is truly required?

Our support for transactions is exactly the same as the one that is provided by Oracle.
No additional options are available.