VistaDB 6
VistaDB.Provider Namespace / VistaDBConnection Class / VistaDBConnection Constructor / VistaDBConnection Constructor()


In This Topic
    VistaDBConnection Constructor()
    In This Topic
    Represents an open connection to a VistaDB database. This class cannot be inherited. It is considered a best practice to close the connection as soon as you are finished with it. Do NOT place the .Close() call in a Finalizer or object destructor. Both of those are non-deterministic (you cannot predict when or if they will be called). This leads to connection handle leaks over the lifetime of an application. Class VistaDBConnection VistaDBConnection.ClearAllPools VistaDBConnection.ClearPool
    Syntax
    'Declaration
     
    
    Public Function New()
    'Usage
     
    
    Dim instance As New VistaDBConnection()
    public VistaDBConnection()
    Remarks
    If you have a connection with connection pooling enabled and you wish to close all of them call the static function VistaDBConnection.ClearAllPools(); To clear a single pool instance you call the static function VistaDBConnection.ClearPool( myConnection ); Where myConnection is a properly initialized VistaDBConnection object.
    Example
    The following example creates and opens a VistaDBConnection. <<pre>> public VistaDBConnection OpenConnection(string connectionString) { VistaDBConnection connection = new VistaDBConnection(connectionString); connection.Open(); return connection; } <</pre>>
    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

    Reference

    VistaDBConnection Class
    VistaDBConnection Members
    Overload List
    Class VistaDBConnection
    VistaDBConnection.ClearAllPools
    VistaDBConnection.ClearPool