2 // System.Data.OleDb.OleDbTransaction
5 // Rodrigo Moya (rodrigo@ximian.com)
6 // Tim Coleman (tim@timcoleman.com)
8 // Copyright (C) Rodrigo Moya, 2002
9 // Copyright (C) Tim Coleman, 2002
13 using System.Data.Common;
15 namespace System.Data.OleDb
17 public sealed class OleDbTransaction : MarshalByRefObject, IDbTransaction, IDisposable
21 OleDbConnection connection;
22 IntPtr gdaTransaction;
29 internal OleDbTransaction (OleDbConnection connection, int depth)
30 : this (connection, depth, IsolationLevel.ReadCommitted)
34 internal OleDbTransaction (OleDbConnection connection)
35 : this (connection, 1)
39 internal OleDbTransaction (OleDbConnection connection, int depth, IsolationLevel isolevel)
41 this.connection = connection;
43 gdaTransaction = libgda.gda_transaction_new (depth.ToString ());
46 case IsolationLevel.ReadCommitted :
47 libgda.gda_transaction_set_isolation_level (gdaTransaction,
48 GdaTransactionIsolation.ReadCommitted);
50 case IsolationLevel.ReadUncommitted :
51 libgda.gda_transaction_set_isolation_level (gdaTransaction,
52 GdaTransactionIsolation.ReadUncommitted);
54 case IsolationLevel.RepeatableRead :
55 libgda.gda_transaction_set_isolation_level (gdaTransaction,
56 GdaTransactionIsolation.RepeatableRead);
58 case IsolationLevel.Serializable :
59 libgda.gda_transaction_set_isolation_level (gdaTransaction,
60 GdaTransactionIsolation.Serializable);
64 libgda.gda_connection_begin_transaction (connection.GdaConnection, gdaTransaction);
67 internal OleDbTransaction (OleDbConnection connection, IsolationLevel isolevel)
68 : this (connection, 1, isolevel)
73 #endregion // Constructors
77 public OleDbConnection Connection {
83 IDbConnection IDbTransaction.Connection {
89 public IsolationLevel IsolationLevel {
91 switch (libgda.gda_transaction_get_isolation_level (gdaTransaction)) {
92 case GdaTransactionIsolation.ReadCommitted :
93 return IsolationLevel.ReadCommitted;
94 case GdaTransactionIsolation.ReadUncommitted :
95 return IsolationLevel.ReadUncommitted;
96 case GdaTransactionIsolation.RepeatableRead :
97 return IsolationLevel.RepeatableRead;
98 case GdaTransactionIsolation.Serializable :
99 return IsolationLevel.Serializable;
102 return IsolationLevel.Unspecified;
106 #endregion // Properties
110 public OleDbTransaction Begin ()
112 return new OleDbTransaction (connection, depth + 1);
115 public OleDbTransaction Begin (IsolationLevel isolevel)
117 return new OleDbTransaction (connection, depth + 1, isolevel);
120 public void Commit ()
122 if (!libgda.gda_connection_commit_transaction (connection.GdaConnection,
124 throw new InvalidOperationException ();
130 libgda.FreeObject (gdaTransaction);
131 gdaTransaction = IntPtr.Zero;
135 void IDisposable.Dispose ()
137 throw new NotImplementedException ();
140 public void Rollback ()
142 if (!libgda.gda_connection_rollback_transaction (connection.GdaConnection,
144 throw new InvalidOperationException ();
147 #endregion // Methods