CommittableTransaction Constructores

Definición

Espacio de nombres:
System.Transactions
Ensamblado:
System.Transactions.dll
Ensamblado:
netstandard.dll

Inicializa una nueva instancia de la clase CommittableTransaction.

Sobrecargas

Nombre Description
CommittableTransaction()

Inicializa una nueva instancia de la clase CommittableTransaction.
CommittableTransaction(TimeSpan)

Inicializa una nueva instancia de la CommittableTransaction clase con el valor especificado timeout .
CommittableTransaction(TransactionOptions)

Inicializa una nueva instancia de la CommittableTransaction clase con las opciones de transacción especificadas.

CommittableTransaction()

Inicializa una nueva instancia de la clase CommittableTransaction.

public:
 CommittableTransaction();
public CommittableTransaction();
Public Sub New ()

Ejemplos

En el ejemplo siguiente se crea una nueva instancia de CommittableTransaction y se confirma.

//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;

tx = New CommittableTransaction

Dim myConnection As New SqlConnection("server=(local)\SQLExpress;Integrated Security=SSPI;database=northwind")
Dim myCommand As 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
Dim c As ConsoleKeyInfo
While (True)
    Console.Write("Commit or Rollback? [C|R] ")
    c = Console.ReadKey()
    Console.WriteLine()

    If (c.KeyChar = "C") Or (c.KeyChar = "c") Then
        tx.Commit()
        Exit While
    ElseIf ((c.KeyChar = "R") Or (c.KeyChar = "r")) Then
        tx.Rollback()
        Exit While
    End If
End While

myConnection.Close()
tx = Nothing

Se aplica a

CommittableTransaction(TimeSpan)

Inicializa una nueva instancia de la CommittableTransaction clase con el valor especificado timeout .

public:
 CommittableTransaction(TimeSpan timeout);
public CommittableTransaction(TimeSpan timeout);
new System.Transactions.CommittableTransaction : TimeSpan -> System.Transactions.CommittableTransaction
Public Sub New (timeout As TimeSpan)

Parámetros

timeout
TimeSpan

La cantidad máxima de tiempo que puede existir la transacción, antes de anularla.

Se aplica a

CommittableTransaction(TransactionOptions)

Inicializa una nueva instancia de la CommittableTransaction clase con las opciones de transacción especificadas.

public:
 CommittableTransaction(System::Transactions::TransactionOptions options);
public CommittableTransaction(System.Transactions.TransactionOptions options);
new System.Transactions.CommittableTransaction : System.Transactions.TransactionOptions -> System.Transactions.CommittableTransaction
Public Sub New (options As TransactionOptions)

Parámetros

options
TransactionOptions

Estructura TransactionOptions que describe las opciones de transacción que se van a usar para la nueva transacción.

Excepciones

ArgumentException

options no es válido.

Ejemplos

En el ejemplo siguiente se crea una nueva instancia de CommittableTransaction con opciones y se anula.

Se aplica a