Compartir vía


CommittableTransaction Constructores

Definición

Inicializa una nueva instancia de la clase CommittableTransaction.

Sobrecargas

CommittableTransaction()

Inicializa una nueva instancia de la clase CommittableTransaction.

CommittableTransaction(TimeSpan)

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

CommittableTransaction(TransactionOptions)

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

CommittableTransaction()

Source:
CommittableTransaction.cs
Source:
CommittableTransaction.cs
Source:
CommittableTransaction.cs

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)

Source:
CommittableTransaction.cs
Source:
CommittableTransaction.cs
Source:
CommittableTransaction.cs

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

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

El tiempo máximo que la transacción puede existir, antes de anularse.

Se aplica a

CommittableTransaction(TransactionOptions)

Source:
CommittableTransaction.cs
Source:
CommittableTransaction.cs
Source:
CommittableTransaction.cs

Inicializa una nueva instancia de la clase CommittableTransaction 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 utilizar para la nueva transacción.

Excepciones

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