mcs/class/System.Data/System.Data.SqlClient/SqlTransaction.cs

   1 //
   2 // System.Data.SqlClient.SqlTransaction.cs
   3 //
   4 // Author:
   5 //   Tim Coleman (tim@timcoleman.com)
   6 //
   7 // Copyright (C) Tim Coleman, 2002
   8 //
   9
  10 //
  11 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
  12 //
  13 // Permission is hereby granted, free of charge, to any person obtaining
  14 // a copy of this software and associated documentation files (the
  15 // "Software"), to deal in the Software without restriction, including
  16 // without limitation the rights to use, copy, modify, merge, publish,
  17 // distribute, sublicense, and/or sell copies of the Software, and to
  18 // permit persons to whom the Software is furnished to do so, subject to
  19 // the following conditions:
  20 //
  21 // The above copyright notice and this permission notice shall be
  22 // included in all copies or substantial portions of the Software.
  23 //
  24 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  25 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  26 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  27 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  28 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  29 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  30 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  31 //
  32
  33 using System;
  34 using System.Data;
  35 using System.Data.Common;
  36
  37 namespace System.Data.SqlClient {
  38         public sealed class SqlTransaction : MarshalByRefObject, IDbTransaction, IDisposable
  39         {
  40                 #region Fields
  41
  42                 bool disposed = false;
  43                 SqlConnection connection;
  44                 IsolationLevel isolationLevel;
  45                 bool isOpen;
  46                 bool isRolledBack = false;
  47
  48                 #endregion
  49
  50                 #region Constructors
  51
  52                 internal SqlTransaction (SqlConnection connection, IsolationLevel isolevel)
  53                 {
  54                         this.connection = connection;
  55                         this.isolationLevel = isolevel;
  56                         isOpen = true;
  57                         isRolledBack = false;
  58                 }
  59
  60                 #endregion // Constructors
  61
  62                 #region Properties
  63
  64                 public SqlConnection Connection {
  65                         get { return connection; }
  66                 }
  67
  68                 internal bool IsOpen {
  69                         get { return isOpen; }
  70                 }
  71
  72                 public IsolationLevel IsolationLevel {
  73                         get { return isolationLevel; }
  74                 }
  75
  76                 IDbConnection IDbTransaction.Connection {
  77                         get { return Connection; }
  78                 }
  79
  80                 #endregion // Properties
  81
  82                 #region Methods
  83
  84                 public void Commit ()
  85                 {
  86                         if (!isOpen)
  87                                 throw new InvalidOperationException ("The Transaction was not open.");
  88                         connection.Tds.Execute ("COMMIT TRANSACTION");
  89                         connection.Transaction = null;
  90                         isOpen = false;
  91                 }
  92
  93                 private void Dispose (bool disposing)
  94                 {
  95                         if (!disposed)  {
  96                                 if (disposing) {
  97                                         if (isOpen) // in case it is called in the dispose of the class, then the isOpen is already false
  98                                                 Rollback ();
  99                                 }
 100                                 disposed = true;
 101                         }
 102                 }
 103
 104                 public void Dispose ()
 105                 {
 106                         Dispose (true);
 107                         GC.SuppressFinalize (this);
 108                 }
 109
 110                 public void Rollback ()
 111                 {
 112                         Rollback (String.Empty);
 113                 }
 114
 115                 public void Rollback (string transactionName)
 116                 {
 117                         if (!isRolledBack) {
 118                                 if (!isOpen)
 119                                         throw new InvalidOperationException ("The Transaction was not open.");
 120                                 connection.Tds.Execute (String.Format ("ROLLBACK TRANSACTION {0}", transactionName));
 121                                 isRolledBack = true;
 122                                 isOpen = false;
 123                         }
 124
 125                 }
 126
 127                 public void Save (string savePointName)
 128                 {
 129                         if (!isOpen)
 130                                 throw new InvalidOperationException ("The Transaction was not open.");
 131                         connection.Tds.Execute (String.Format ("SAVE TRANSACTION {0}", savePointName));
 132                 }
 133
 134                 #endregion // Methods
 135         }
 136 }