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 {
  39         public sealed class SqlTransaction : DbTransaction, IDbTransaction, IDisposable
  40         {
  41                 #region Fields
  42
  43                 bool disposed;
  44                 SqlConnection connection;
  45                 IsolationLevel isolationLevel;
  46                 bool isOpen;
  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                 }
  58
  59                 #endregion // Constructors
  60
  61                 #region Properties
  62
  63                 public
  64                 new
  65                 SqlConnection Connection {
  66                         get { return connection; }
  67                 }
  68
  69                 internal bool IsOpen {
  70                         get { return isOpen; }
  71                 }
  72
  73                 public
  74                 override
  75                 IsolationLevel IsolationLevel {
  76                         get {
  77                                 if (!isOpen)
  78                                         throw ExceptionHelper.TransactionNotUsable (GetType ());
  79                                 return isolationLevel;
  80                         }
  81                 }
  82
  83                 protected override DbConnection DbConnection {
  84                         get { return Connection; }
  85                 }
  86
  87                 #endregion // Properties
  88
  89                 #region Methods
  90
  91                 public
  92                 override
  93                 void Commit ()
  94                 {
  95                         if (!isOpen)
  96                                 throw ExceptionHelper.TransactionNotUsable (GetType ());
  97
  98                         connection.Tds.Execute ("COMMIT TRANSACTION");
  99                         connection.Transaction = null;
 100                         connection = null;
 101                         isOpen = false;
 102                 }
 103
 104                 protected override
 105                 void Dispose (bool disposing)
 106                 {
 107                         if (!disposed) {
 108                                 if (disposing) {
 109                                         if (isOpen) // in case it is called in the dispose of the class, then the isOpen is already false
 110                                                 Rollback ();
 111                                 }
 112                                 disposed = true;
 113                         }
 114                 }
 115
 116
 117                 public
 118                 override
 119                 void Rollback ()
 120                 {
 121                         Rollback (String.Empty);
 122                 }
 123
 124                 public void Rollback (string transactionName)
 125                 {
 126                         if (disposed)
 127                                 return;
 128
 129                         if (!isOpen)
 130                                 throw ExceptionHelper.TransactionNotUsable (GetType ());
 131
 132                         if (connection.Tds.IsConnected)
 133                                 connection.Tds.Execute (String.Format ("IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION {0}",
 134                                                                         transactionName));
 135                         isOpen = false;
 136                         connection.Transaction = null;
 137                         connection = null;
 138                 }
 139
 140                 public void Save (string savePointName)
 141                 {
 142                         if (!isOpen)
 143                                 throw ExceptionHelper.TransactionNotUsable (GetType ());
 144                         connection.Tds.Execute (String.Format ("SAVE TRANSACTION {0}", savePointName));
 145                 }
 146
 147                 #endregion // Methods
 148         }
 149 }