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