EnlistTransaction Method (DbConnectionBase)
On this page
Enlists in the specified transaction.
Syntax
|
|---|
'Declaration
Public Overrides Sub EnlistTransaction( _
ByVal As Transaction _
) |
Parameters
- transaction
- A reference to an existing System.Transactions.Transaction in which to enlist.
Example
These samples demonstrate usage of
EnlistTransaction.
|
|---|
SqlCommand1.Connection=SqlConnection1;
using (TransactionScope transScope = new TransactionScope()) {
SqlConnection1.Open();
SqlCommand1.ExecuteNonQuery();
transScope.Complete();
}
SqlConnection1.Close();
- or -
SqlCommand1.Connection=SqlConnection1;
SqlConnection1.Open();
using (TransactionScope transScope = new TransactionScope()) {
SqlConnection1.EnlistTransaction(Transaction.Current);
SqlCommand1.ExecuteNonQuery();
transScope.Complete();
}
SqlConnection1.Close();
- or -
CommittableTransaction cmtTx = new CommittableTransaction();
SqlConnection1.Open();
SqlConnection1.EnlistTransaction(cmtTx);
SqlCommand1.ExecuteNonQuery();
SqlConnection1.Close(); |
|
|---|
Me.SqlCommand1.Connection = Me.SqlConnection1
Using transScope = New Transactions.TransactionScope
Me.SqlConnection1.Open()
Me.SqlCommand1.ExecuteNonQuery()
transScope.Complete()
End Using
Me.SqlConnection1.Close()
- or -
Me.SqlCommand1.Connection = Me.SqlConnection1
Me.SqlConnection1.Open()
Using transScope = New Transactions.TransactionScope
Me.SqlConnection1.EnlistTransaction(Transactions.Transaction.Current)
Me.SqlCommand1.ExecuteNonQuery()
transScope.Complete()
End Using
Me.SqlConnection1.Close()
- or -
Dim cmtTx As New Transactions.CommittableTransaction
Me.SqlConnection1.Open()
Me.SqlConnection1.EnlistTransaction(cmtTx)
Me.SqlCommand1.ExecuteNonQuery()
Me.SqlConnection1.Close() |
See Also
