Språk

CommittableTransaction Konstruktorer

Definition

Initierar en ny instans av CommittableTransaction klassen.

Överlagringar

Name Description
CommittableTransaction()

Initierar en ny instans av CommittableTransaction klassen.

CommittableTransaction(TimeSpan)

Initierar en ny instans av CommittableTransaction klassen med det angivna timeout värdet.

CommittableTransaction(TransactionOptions)

Initierar en ny instans av CommittableTransaction klassen med de angivna transaktionsalternativen.

CommittableTransaction()

Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs

Initierar en ny instans av CommittableTransaction klassen.

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

Exempel

Följande exempel skapar en ny instans av CommittableTransaction och checkar in den.

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

Gäller för

CommittableTransaction(TimeSpan)

Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs

Initierar en ny instans av CommittableTransaction klassen med det angivna timeout värdet.

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

Parametrar

timeout
TimeSpan

Den maximala tiden som transaktionen kan finnas innan den avbryts.

Gäller för

CommittableTransaction(TransactionOptions)

Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs
Källa:
CommittableTransaction.cs

Initierar en ny instans av CommittableTransaction klassen med de angivna transaktionsalternativen.

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)

Parametrar

options
TransactionOptions

En TransactionOptions struktur som beskriver de transaktionsalternativ som ska användas för den nya transaktionen.

Undantag

options är ogiltigt.

Exempel

Följande exempel skapar en ny instans av CommittableTransaction med alternativ och avbryter den.

Gäller för