Share via

  • Article

PipelineComponent.ReleaseConnections Method

Frees the connections established during AcquireConnections. Called at design time and run time.

Namespace:  Microsoft.SqlServer.Dts.Pipeline
Assembly:  Microsoft.SqlServer.PipelineHost (in Microsoft.SqlServer.PipelineHost.dll)

Syntax

'Declaration
Public Overridable Sub ReleaseConnections
'Usage
Dim instance As PipelineComponent

instance.ReleaseConnections()

public virtual void ReleaseConnections()

public:
virtual void ReleaseConnections()

abstract ReleaseConnections : unit -> unit 
override ReleaseConnections : unit -> unit 

public function ReleaseConnections()

Remarks

Called repeatedly during component design, and at the end of component execution. Components should release any connections that were opened and maintained in AcquireConnections.

Examples

private System.Data.OleDb.OleDbConnection oledbConnection;
public override void ReleaseConnections()
{
    if (oledbConnection != null && oledbConnection.State != ConnectionState.Closed )
        oledbConnection.Close();
}

Private oledbConnection As System.Data.OleDb.OleDbConnection 

Public Overrides Sub ReleaseConnections() 
 If Not (oledbConnection Is Nothing) AndAlso Not (oledbConnection.State = ConnectionState.Closed) Then 
   oledbConnection.Close 
 End If 
End Sub