PipelineComponent.AcquireConnections(Object) Metode

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Pipeline

Rakitan:

Microsoft.SqlServer.PipelineHost.dll

Membuat koneksi ke manajer koneksi.

public:
 virtual void AcquireConnections(System::Object ^ transaction);

public virtual void AcquireConnections (object transaction);

abstract member AcquireConnections : obj -> unit
override this.AcquireConnections : obj -> unit

Public Overridable Sub AcquireConnections (transaction As Object)

Parameter

transaction

Object

Transaksi yang diikuti koneksi.

Contoh

Contoh berikut menunjukkan komponen yang tersambung ke pengelola koneksi ADO.NET selama AcquireConnections.

public override void AcquireConnections(object transaction)  
{  
    if (ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager != null)  
    {  
            // Convert the native IDTSConnectionManager100 to the managed ConnectionManager,  
            // then retrieve the underlying connection through the InnerObject.  
            ConnectionManager cm = Microsoft.SqlServer.Dts.Runtime.DtsConvert.ToConnectionManager(ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager);  
            ConnectionManagerAdoNet cmado = cm.InnerObject  as ConnectionManagerAdoNet;  

            // If the InnerObject is not an ConnectionManagerAdoNet, then  
            // the cmado object is null.  
            if( cmado == null )  
                throw new Exception("The ConnectionManager " + cm.Name + " is not an ADO.NET connection.");  

            // Get the underlying connection object.  
            this.oledbConnection = cmado.AcquireConnection(transaction) as OleDbConnection;  

            if( this.oledbConnection == null )  
                throw new Exception("The ConnectionManager " + cm.Name + " is not an ADO.NET connection.");  

            isConnected = true;  
    }  
}  

Public Overrides Sub AcquireConnections(ByVal transaction As Object)   
 If Not (ComponentMetaData.RuntimeConnectionCollection(0).ConnectionManager Is Nothing) Then   
   ' Convert the native IDTSConnectionManager100 to the managed ConnectionManager,  
   '  then retrieve the underlying connection through the InnerObject.  
   Dim cm As ConnectionManager = Microsoft.SqlServer.Dts.Runtime.DtsConvert.ToConnectionManager(ComponentMetaData.RuntimeConnectionCollection(0).ConnectionManager)   
   Dim cmado As ConnectionManagerAdoNet = CType(ConversionHelpers.AsWorkaround(cm.InnerObject, GetType(ConnectionManagerAdoNet)), ConnectionManagerAdoNet)   
   ' If the InnerObject is not an ConnectionManagerAdoNet, then  
   '  the cmado object is null.  
   If cmado Is Nothing Then   
     Throw New Exception("The ConnectionManager " + cm.Name + " is not an ADO.NET connection.")   
   End If   
   ' Get the underlying connection object.  
   Me.oledbConnection = CType(ConversionHelpers.AsWorkaround(cmado.AcquireConnection(transaction), GetType(OleDbConnection)), OleDbConnection)   
   If Me.oledbConnection Is Nothing Then   
     Throw New Exception("The ConnectionManager " + cm.Name + " is not an ADO.NET connection.")   
   End If   
   isConnected = True   
 End If   
End Sub  

Keterangan

AcquireConnections dipanggil selama desain komponen dan eksekusi. Komponen yang terhubung ke sumber data eksternal harus membangun koneksi mereka selama metode ini. Koneksi apa pun yang dibuat selama metode ini harus di-cache dalam variabel anggota lokal dan dirilis dalam ReleaseConnections metode . Koneksi hanya boleh dibuat selama AcquireConnections.