OraDirect .NET and TransactionScope

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
pdebruin
Posts: 1
Joined: Thu 01 Jun 2006 12:19

OraDirect .NET and TransactionScope

Post by pdebruin » Thu 01 Jun 2006 12:21

We are currently using your ADO.NET dataprovider for Oracle (v 3.50.9.0) to connect to our Oracle database (v 9.2.0.7).

We are trying to implement transactions using the System.Transactions.TransactionScope which is new in .NET Framework 2.0. However, we are not able to get this working. Is there any sample code for C# 2.0 that you can provide to get us started?

Thanks in advance.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 02 Jun 2006 11:45

Unfortunately, we do not have such sample code. Please refer to MSDN for more information.

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Fri 02 Jun 2006 12:24

OraDirect .NET does not support TransactionScope now. We will investigate this functionality in the future

cstaley
Posts: 3
Joined: Wed 08 Oct 2008 17:06

Post by cstaley » Fri 10 Oct 2008 12:57

It appears that the current version (4.75) still doesn't support TransactionScope. Are there any plans to add this anytime soon?

edstaffin
Posts: 43
Joined: Mon 13 Oct 2008 13:23

Need to know

Post by edstaffin » Mon 13 Oct 2008 13:27

If there is no support for TransactionScope, what is the recommended way of doing transactions with this product?
Thanks ... Ed

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

Post by Shalex » Tue 14 Oct 2008 10:39

TransactionScope will be supported in OraDirect .NET version 5.0. Now we recommend to use OracleConnection.BeginTransaction().

edstaffin
Posts: 43
Joined: Mon 13 Oct 2008 13:23

Post by edstaffin » Tue 14 Oct 2008 10:45

Sounds good. Do you have a timeline for when 5.0 is likely to be available?
Thanks ... Ed

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

Post by Shalex » Tue 14 Oct 2008 12:11

OraDirect .NET version 5.0 will be available in 2 weeks.

Post Reply