Transaction Support

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
digitall
Posts: 4
Joined: Thu 30 Oct 2008 18:02

Transaction Support

Post by digitall » Fri 31 Oct 2008 20:58

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?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 03 Nov 2008 10:17

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

digitall
Posts: 4
Joined: Thu 30 Oct 2008 18:02

Post by digitall » Mon 03 Nov 2008 13:04

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?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 04 Nov 2008 09:38

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

Post Reply