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.
|
|---|
DB2Command1.Connection=DB2Connection1;
using (TransactionScope transScope = new TransactionScope()) {
DB2Connection1.Open();
DB2Command1.ExecuteNonQuery();
transScope.Complete();
}
DB2Connection1.Close();
- or -
DB2Command1.Connection=DB2Connection1;
DB2Connection1.Open();
using (TransactionScope transScope = new TransactionScope()) {
DB2Connection1.EnlistTransaction(Transaction.Current);
DB2Command1.ExecuteNonQuery();
transScope.Complete();
}
DB2Connection1.Close();
- or -
CommittableTransaction cmtTx = new CommittableTransaction();
DB2Connection1.Open();
DB2Connection1.EnlistTransaction(cmtTx);
DB2Command1.ExecuteNonQuery();
DB2Connection1.Close(); |
|
|---|
Me.DB2Command1.Connection = Me.DB2Connection1
Using transScope = New Transactions.TransactionScope
Me.DB2Connection1.Open()
Me.DB2Command1.ExecuteNonQuery()
transScope.Complete()
End Using
Me.DB2Connection1.Close()
- or -
Me.DB2Command1.Connection = Me.DB2Connection1
Me.DB2Connection1.Open()
Using transScope = New Transactions.TransactionScope
Me.DB2Connection1.EnlistTransaction(Transactions.Transaction.Current)
Me.DB2Command1.ExecuteNonQuery()
transScope.Complete()
End Using
Me.DB2Connection1.Close()
- or -
Dim cmtTx As New Transactions.CommittableTransaction
Me.DB2Connection1.Open()
Me.DB2Connection1.EnlistTransaction(cmtTx)
Me.DB2Command1.ExecuteNonQuery()
Me.DB2Connection1.Close() |
See Also
