SqlConnection.ClearPool Method (System.Data.SqlClient)

ClearPool Method

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

SqlConnection..::.ClearPool Method

Empties the connection pool associated with the specified connection.

Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)

Syntax

Visual Basic (Declaration)

Public Shared Sub ClearPool ( _
    connection As SqlConnection _
)

Visual Basic (Usage)

Dim connection As SqlConnection

SqlConnection.ClearPool(connection)

public static void ClearPool(
    SqlConnection connection
)

Visual C++

public:
static void ClearPool(
    SqlConnection^ connection
)

JScript

public static function ClearPool(
    connection : SqlConnection
)

Parameters

connection: Type: System.Data.SqlClient..::.SqlConnection
The SqlConnection to be cleared from the pool.

Remarks

ClearPool clears the connection pool that is associated with the connection. If additional connections associated with connection are in use at the time of the call, they are marked appropriately and are discarded (instead of being returned to the pool) when Close is called on them.

Platforms

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Version Information

.NET Framework

Supported in: 3.5, 3.0, 2.0

Reference

SqlConnection Class

SqlConnection Members

System.Data.SqlClient Namespace

Other Resources

SQL Server Connection Pooling (ADO.NET)