Export (0) Print
Expand All

CommittableTransaction Constructor

Initializes a new instance of the CommittableTransaction class.

Namespace:  System.Transactions
Assembly:  System.Transactions (in System.Transactions.dll)

public CommittableTransaction()

ExceptionCondition
PlatformNotSupportedException

An attempt to create a transaction under Windows 98, Windows 98 Second Edition or Windows Millennium Edition.

The following sample creates a new instance of CommittableTransaction and commits it.

				//Create a committable transaction
				tx = new CommittableTransaction();

				SqlConnection myConnection = new SqlConnection("server=(local)\\SQLExpress;Integrated Security=SSPI;database=northwind");
				SqlCommand myCommand = new SqlCommand();

				//Open the SQL connection
				myConnection.Open();

				//Give the transaction to SQL to enlist with
				myConnection.EnlistTransaction(tx);

				myCommand.Connection = myConnection;

				// Restore database to near it's original condition so sample will work correctly.
				myCommand.CommandText = "DELETE FROM Region WHERE (RegionID = 100) OR (RegionID = 101)";
				myCommand.ExecuteNonQuery();

				// Insert the first record.
				myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'MidWestern')";
				myCommand.ExecuteNonQuery();

				// Insert the second record.
				myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'MidEastern')";
				myCommand.ExecuteNonQuery();

				// Commit or rollback the transaction 
				while (true)
				{
					Console.Write("Commit or Rollback? [C|R] ");
					ConsoleKeyInfo c = Console.ReadKey();
					Console.WriteLine();

					if ((c.KeyChar == 'C') || (c.KeyChar == 'c'))
					{
						tx.Commit();
						break;
					}
					else if ((c.KeyChar == 'R') || (c.KeyChar == 'r'))
					{
						tx.Rollback();
						break;
					}
				}
				myConnection.Close();
				tx = null;

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft