Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
-
pdebruin
- Posts: 1
- Joined: Thu 01 Jun 2006 12:19
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
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: 9543
- 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: 9543
- 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.