Share via

  • Article

ConnectionManagerBase.ReleaseConnection Method

Frees the connection established during AcquireConnection. Called at design time and run time.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

'Declaration
Public Overridable Sub ReleaseConnection ( _
    connection As Object _
)
'Usage
Dim instance As ConnectionManagerBase
Dim connection As Object

instance.ReleaseConnection(connection)

public virtual void ReleaseConnection(
    Object connection
)

public:
virtual void ReleaseConnection(
    Object^ connection
)

abstract ReleaseConnection : 
        connection:Object -> unit 
override ReleaseConnection : 
        connection:Object -> unit 

public function ReleaseConnection(
    connection : Object
)

Parameters

Remarks

This method is called repeatedly during component design by the runtime engine and at the end of component execution. The components then release any connections that were opened and maintained in AcquireConnection. This method is called only when OfflineMode is false.

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 oledbConnection <> Nothing And oledbConnection.State <> ConnectionState.Closed Then
        oledbConnection.Close()
    End If
End Sub