EnlistTransaction Method

In This Topic

Syntax
Remarks
Example
Requirements
See Also

Enlists in the specified transaction.

Syntax

Visual Basic
C#

public override void EnlistTransaction( 
   Transaction transaction
)

'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.

csharp

Adobe CommerceCommand1.Connection=Adobe CommerceConnection1;
using (TransactionScope transScope = new TransactionScope()) {
 Adobe CommerceConnection1.Open();
 Adobe CommerceCommand1.ExecuteNonQuery();
 transScope.Complete();
}
Adobe CommerceConnection1.Close();

- or -

Adobe CommerceCommand1.Connection=Adobe CommerceConnection1;
Adobe CommerceConnection1.Open();
using (TransactionScope transScope = new TransactionScope()) {
 Adobe CommerceConnection1.EnlistTransaction(Transaction.Current);
 Adobe CommerceCommand1.ExecuteNonQuery();
 transScope.Complete();
}
Adobe CommerceConnection1.Close();

- or -

CommittableTransaction cmtTx = new CommittableTransaction();
Adobe CommerceConnection1.Open();
Adobe CommerceConnection1.EnlistTransaction(cmtTx);
Adobe CommerceCommand1.ExecuteNonQuery();
Adobe CommerceConnection1.Close();

Visual Basic

Me.Adobe CommerceCommand1.Connection = Me.Adobe CommerceConnection1
Using transScope = New Transactions.TransactionScope
  Me.Adobe CommerceConnection1.Open()
  Me.Adobe CommerceCommand1.ExecuteNonQuery()
  transScope.Complete()
End Using
Me.Adobe CommerceConnection1.Close()

- or -

Me.Adobe CommerceCommand1.Connection = Me.Adobe CommerceConnection1
Me.Adobe CommerceConnection1.Open()
Using transScope = New Transactions.TransactionScope
  Me.Adobe CommerceConnection1.EnlistTransaction(Transactions.Transaction.Current)
  Me.Adobe CommerceCommand1.ExecuteNonQuery()
  transScope.Complete()
End Using
Me.Adobe CommerceConnection1.Close()

- or -

Dim cmtTx As New Transactions.CommittableTransaction
Me.Adobe CommerceConnection1.Open()
Me.Adobe CommerceConnection1.EnlistTransaction(cmtTx)
Me.Adobe CommerceCommand1.ExecuteNonQuery()
Me.Adobe CommerceConnection1.Close()

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DbConnectionBase Class
DbConnectionBase Members

Send Feedback