dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlConnectionStringBuilder Class / ValidateConnection Property

In This Topic
    ValidateConnection Property
    In This Topic
    Indicates whether to validate connections that are being taken from the pool.
    Syntax
    'Declaration
     
    Public Property ValidateConnection As Boolean
    public bool ValidateConnection {get; set;}

    Property Value

    true, if the connection should be validated when it is taken from the pool; false otherwise.
    Remarks

    If true, each time when a connection is taken from the pool, it is checked for validity. If the connection is not valid, it is destroyed and a new one is created.

    If this parameter is true, the connection pool manager background validation is disabled in this case as it is not needed. In such case we always have a valid connection, however the performance is not optimal.

    This behaviour may be useful when the physical connection is unstable and connection can be lost in a short period of time. Pool manager validates pool connections every 30 seconds, so it is possible that connection will become invalid during this interval and the application will take it from the pool before the validation. If the physical connection is stable, pool manager validation is enough to ensure that the connection is valid, so it is better not to use this property. Use this property only if necessary because it causes a round-trip to the database to validate each connection immediately before it is provided to the application.

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also