dotConnect for Mailchimp Documentation
Devart.Common Namespace / DbConnectionBase Class / EnlistTransaction Method
A reference to an existing System.Transactions.Transaction in which to enlist.
Example

EnlistTransaction Method
Enlists in the specified transaction.
Syntax
'Declaration
 
Public Overrides Sub EnlistTransaction( _
   ByVal transaction As Transaction _
) 
 

Parameters

transaction
A reference to an existing System.Transactions.Transaction in which to enlist.
Remarks

Once a connection is explicitly enlisted in a distributed transaction, it cannot be unenlisted or enlisted in another transaction until the first transaction finishes.

Example
These samples demonstrate usage of EnlistTransaction.
MailChimpCommand1.Connection=MailChimpConnection1;
using (TransactionScope transScope = new TransactionScope()) {
 MailChimpConnection1.Open();
 MailChimpCommand1.ExecuteNonQuery();
 transScope.Complete();
}
MailChimpConnection1.Close();

- or -

MailChimpCommand1.Connection=MailChimpConnection1;
MailChimpConnection1.Open();
using (TransactionScope transScope = new TransactionScope()) {
 MailChimpConnection1.EnlistTransaction(Transaction.Current);
 MailChimpCommand1.ExecuteNonQuery();
 transScope.Complete();
}
MailChimpConnection1.Close();

- or -

CommittableTransaction cmtTx = new CommittableTransaction();
MailChimpConnection1.Open();
MailChimpConnection1.EnlistTransaction(cmtTx);
MailChimpCommand1.ExecuteNonQuery();
MailChimpConnection1.Close();
Me.MailChimpCommand1.Connection = Me.MailChimpConnection1
Using transScope = New Transactions.TransactionScope
  Me.MailChimpConnection1.Open()
  Me.MailChimpCommand1.ExecuteNonQuery()
  transScope.Complete()
End Using
Me.MailChimpConnection1.Close()

- or -

Me.MailChimpCommand1.Connection = Me.MailChimpConnection1
Me.MailChimpConnection1.Open()
Using transScope = New Transactions.TransactionScope
  Me.MailChimpConnection1.EnlistTransaction(Transactions.Transaction.Current)
  Me.MailChimpCommand1.ExecuteNonQuery()
  transScope.Complete()
End Using
Me.MailChimpConnection1.Close()

- or -

Dim cmtTx As New Transactions.CommittableTransaction
Me.MailChimpConnection1.Open()
Me.MailChimpConnection1.EnlistTransaction(cmtTx)
Me.MailChimpCommand1.ExecuteNonQuery()
Me.MailChimpConnection1.Close()
See Also