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 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
15 // Permission is hereby granted, free of charge, to any person obtaining
16 // a copy of this software and associated documentation files (the
17 // "Software"), to deal in the Software without restriction, including
18 // without limitation the rights to use, copy, modify, merge, publish,
19 // distribute, sublicense, and/or sell copies of the Software, and to
20 // permit persons to whom the Software is furnished to do so, subject to
21 // the following conditions:
23 // The above copyright notice and this permission notice shall be
24 // included in all copies or substantial portions of the Software.
26 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
27 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
28 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
29 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
30 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
31 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
32 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
36 using System
.Data
.Common
;
38 namespace System
.Data
.OleDb
40 public sealed class OleDbTransaction
: MarshalByRefObject
, IDbTransaction
, IDisposable
44 OleDbConnection connection
;
45 IntPtr gdaTransaction
;
52 internal OleDbTransaction (OleDbConnection connection
, int depth
)
53 : this (connection
, depth
, IsolationLevel
.ReadCommitted
)
57 internal OleDbTransaction (OleDbConnection connection
)
58 : this (connection
, 1)
62 internal OleDbTransaction (OleDbConnection connection
, int depth
, IsolationLevel isolevel
)
64 this.connection
= connection
;
66 gdaTransaction
= libgda
.gda_transaction_new (depth
.ToString ());
69 case IsolationLevel
.ReadCommitted
:
70 libgda
.gda_transaction_set_isolation_level (gdaTransaction
,
71 GdaTransactionIsolation
.ReadCommitted
);
73 case IsolationLevel
.ReadUncommitted
:
74 libgda
.gda_transaction_set_isolation_level (gdaTransaction
,
75 GdaTransactionIsolation
.ReadUncommitted
);
77 case IsolationLevel
.RepeatableRead
:
78 libgda
.gda_transaction_set_isolation_level (gdaTransaction
,
79 GdaTransactionIsolation
.RepeatableRead
);
81 case IsolationLevel
.Serializable
:
82 libgda
.gda_transaction_set_isolation_level (gdaTransaction
,
83 GdaTransactionIsolation
.Serializable
);
87 libgda
.gda_connection_begin_transaction (connection
.GdaConnection
, gdaTransaction
);
90 internal OleDbTransaction (OleDbConnection connection
, IsolationLevel isolevel
)
91 : this (connection
, 1, isolevel
)
96 #endregion // Constructors
100 public OleDbConnection Connection
{
106 IDbConnection IDbTransaction
.Connection
{
112 public IsolationLevel IsolationLevel
{
114 switch (libgda
.gda_transaction_get_isolation_level (gdaTransaction
)) {
115 case GdaTransactionIsolation
.ReadCommitted
:
116 return IsolationLevel
.ReadCommitted
;
117 case GdaTransactionIsolation
.ReadUncommitted
:
118 return IsolationLevel
.ReadUncommitted
;
119 case GdaTransactionIsolation
.RepeatableRead
:
120 return IsolationLevel
.RepeatableRead
;
121 case GdaTransactionIsolation
.Serializable
:
122 return IsolationLevel
.Serializable
;
125 return IsolationLevel
.Unspecified
;
129 #endregion // Properties
133 public OleDbTransaction
Begin ()
135 return new OleDbTransaction (connection
, depth
+ 1);
138 public OleDbTransaction
Begin (IsolationLevel isolevel
)
140 return new OleDbTransaction (connection
, depth
+ 1, isolevel
);
143 public void Commit ()
145 if (!libgda
.gda_connection_commit_transaction (connection
.GdaConnection
,
147 throw new InvalidOperationException ();
153 libgda
.FreeObject (gdaTransaction
);
154 gdaTransaction
= IntPtr
.Zero
;
158 void IDisposable
.Dispose ()
160 throw new NotImplementedException ();
163 public void Rollback ()
165 if (!libgda
.gda_connection_rollback_transaction (connection
.GdaConnection
,
167 throw new InvalidOperationException ();
170 #endregion // Methods