Re: [Advanced-ado-users] Transactions

[Ricard <ri...@ga...>]

Hello !
I submitted a patch some time ago about Transactions in adp.

I made another little modification in order to make them work in access 
databases:


--- adp-0.9.4-orig/src/AdpConnection.cs    2004-10-26 16:24:44.000000000 
+0200
+++ adp-0.9.4/src/AdpConnection.cs    2004-12-28 10:27:47.531250000 +0100
@@ -161,7 +161,7 @@
         /// <returns>A interface to <see cref='IDbTransaction'/>.</returns>
         IDbTransaction System.Data.IDbConnection.BeginTransaction()
         {
-            return 
((IDbConnection)this).BeginTransaction(IsolationLevel.Unspecified);
+            return 
((IDbConnection)this).BeginTransaction(IsolationLevel.ReadCommitted);
         }
 
         /// <summary>

the problem is that MS Access doesn't accept IsolationLevel.Unspecified.

I don't know if there's a proper way to detect MS Access databases and 
act accordingly. But just in case someone faces the same problem, here's 
the solution.



En/na Everaldo Canuto ha escrit:

>Olá Ricard,
>
>Thanks for your patch, I will include it today :)
>For the next days I have plan to release a new version with a lot of new
>resources. Wait and you will see :)
>
>If you have any problem with ADP feel free to contact me, I like to see
>your experience with ADP.
>
>Thanks,
>Everaldo.
>
>
>Em Qui, 2004-12-30 às 09:19 +0100, Ricard escreveu:
>  
>
>>Hello!
>>
>>After all, "obrigado" for this piece of software.
>>
>>I sent a patch to make it even better.
>> http://sourceforge.net/tracker/index.php?
>>func=detail&aid=1092088&group_id=114652&atid=669036
>>
>>It solves  a little problem with transactions.
>>
>>Regards.
>>
>>
>>______________________________________________________________________
>>
>>
>>I think there's a bug in the AdpCommand constructor
>>that prevents transactions to work properly.
>>
>>The constructor that works is :
>>public AdpCommand(string cmdText, AdpConnection connection, AdpTransaction transaction)
>>{
>>this.Connection = connection;
>>this.Transaction = transaction;
>>this.CommandText = cmdText;
>>}
>>
>>
>>
>>
>>Note that I use "this.Connection" not "this.connection" and
>>"this.Transaction" not "this.transaction" to initialize the variables
>>properly.
>>
>>
>>
>>    
>>
>
>  
>