Partager via


CommittableTransaction Constructeurs

Définition

Initialise une nouvelle instance de la classe CommittableTransaction.

Surcharges

CommittableTransaction()

Initialise une nouvelle instance de la classe CommittableTransaction.

CommittableTransaction(TimeSpan)

Initialise une nouvelle instance de la classe CommittableTransaction avec la valeur timeout spécifiée.

CommittableTransaction(TransactionOptions)

Initialise une nouvelle instance de la classe CommittableTransaction avec les options de transaction spécifiées.

CommittableTransaction()

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

Initialise une nouvelle instance de la classe CommittableTransaction.

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

Exemples

L’exemple suivant crée une instance de CommittableTransaction et la valide.

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

S’applique à

CommittableTransaction(TimeSpan)

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

Initialise une nouvelle instance de la classe CommittableTransaction avec la valeur timeout spécifiée.

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

Paramètres

timeout
TimeSpan

Délai maximal pendant lequel la transaction peut exister avant d'être abandonnée.

S’applique à

CommittableTransaction(TransactionOptions)

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

Initialise une nouvelle instance de la classe CommittableTransaction avec les options de transaction spécifiées.

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)

Paramètres

options
TransactionOptions

Structure TransactionOptions qui décrit les options de transaction à utiliser pour la nouvelle transaction.

Exceptions

options n'est pas valide.

Exemples

L’exemple suivant crée une instance de avec des CommittableTransaction options et l’abandonne.

S’applique à