CommittableTransaction Konstruktorer
Definition
Viktigt
En del information gäller för förhandsversionen av en produkt och kan komma att ändras avsevärt innan produkten blir allmänt tillgänglig. Microsoft lämnar inga garantier, uttryckliga eller underförstådda, avseende informationen som visas här.
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 |
| CommittableTransaction(TransactionOptions) |
Initierar en ny instans av CommittableTransaction klassen med de angivna transaktionsalternativen. |
CommittableTransaction()
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)
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)
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.