EnlistTransaction Method

In This Topic

Enlists in the specified transaction.

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides Sub EnlistTransaction( _
   ByVal transaction As Transaction _
)

public override void EnlistTransaction( 
   Transaction 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

SalesforceCommand1.Connection=SalesforceConnection1;
using (TransactionScope transScope = new TransactionScope()) {
 SalesforceConnection1.Open();
 SalesforceCommand1.ExecuteNonQuery();
 transScope.Complete();
}
SalesforceConnection1.Close();

- or -

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

- or -

CommittableTransaction cmtTx = new CommittableTransaction();
SalesforceConnection1.Open();
SalesforceConnection1.EnlistTransaction(cmtTx);
SalesforceCommand1.ExecuteNonQuery();
SalesforceConnection1.Close();

Visual Basic

Me.SalesforceCommand1.Connection = Me.SalesforceConnection1
Using transScope = New Transactions.TransactionScope
  Me.SalesforceConnection1.Open()
  Me.SalesforceCommand1.ExecuteNonQuery()
  transScope.Complete()
End Using
Me.SalesforceConnection1.Close()

- or -

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

- or -

Dim cmtTx As New Transactions.CommittableTransaction
Me.SalesforceConnection1.Open()
Me.SalesforceConnection1.EnlistTransaction(cmtTx)
Me.SalesforceCommand1.ExecuteNonQuery()
Me.SalesforceConnection1.Close()

Reference

DbConnectionBase Class
DbConnectionBase Members

Send Feedback