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