VistaDB 6
VistaDB.Provider Namespace / VistaDBConnection Class
Fields Properties Methods Events


In This Topic
    VistaDBConnection Class Members
    In This Topic

    The following tables list the members exposed by VistaDBConnection.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Fields
     NameDescription
    Public Fieldstatic (Shared in Visual Basic)System table name  
    Public Fieldstatic (Shared in Visual Basic)System table type name  
    Public Fieldstatic (Shared in Visual Basic)User table type name  
    Top
    Public Properties
     NameDescription
    Public PropertyGets the CompatibilityMode setting from the connection string for this connection. Read only, may not be changed after opening the connection.  
    Public PropertyOverridden. Gets or sets the string used to open the connection.Gets or sets the string used to open the connection.  
    Public PropertyGets the time to wait while establishing a connection before terminating the attempt and generating an error. (Inherited from System.Data.Common.DbConnection)
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyUsed only inside CLR stored procedures. If it is set to true the context connection is used.  
    Public PropertyOverridden. Gets the name of the current database after a connection is opened, or the database name specified in the connection string before the connection is opened. Get the name of the database.  
    Public PropertyOverridden. Gets the name of the database server to which to connect. Get the name of the database.  
    Public PropertyIf it is set to true the database placed in isolated storage.  
    Public PropertyAn integer value that represents the time in seconds as the maximum time a transaction is locked. 10 seconds is the default, negative values reset to default. Maximum time is one hour.  
    Public PropertyGets a value that indicates connection open mode.  
    Public Property(BETA ONLY) Get the current optimization setting of this (open) VistaDBConnection as a string. This string value will be an option which can be used with the "SET OPTIMIZATION {0}" command.  
    Public Property(BETA ONLY) Get the current optimization setting of this (open) VistaDBConnection as a version string (or "Off"). This string value will be the approximate version equivalent of the current optimization setting.  
    Public PropertyGet the PageSize of the currently open database. Will return 0 if the connection is not open.  
    Public PropertyGet the string used for the base of the encryption key.  
    Public PropertyControl lifetime of .lck files on hard drive. If it is set to true this connection will not try to delete these files upon table closing. It may give some performance boosting in multi-user environment.  
    Public PropertyGets the ProcessProtection setting from the connection string for this connection. Read only, may not be changed after opening the connection.  
    Public PropertyOverridden. Gets a string that represents the version of the server to which the object is connected. VistaDB version for connection information (We only really need major / minor here for client compatibility)  
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyOverridden. Gets a string that describes the state of the connection. Gets a value that describes the state of the connection.  
    Public PropertyGets the current TransactionMode for this connection. Read only, may not be changed after opening the connection. Class VistaDBConnection Class VistaDBConnectionStringBuilder  
    Top
    Protected Properties
     NameDescription
    Protected Property (Inherited from System.ComponentModel.Component)
    Protected PropertyOverridden. Gets the System.Data.Common.DbProviderFactory for this System.Data.Common.DbConnection. DB Provider Factory object  
    Protected Property (Inherited from System.ComponentModel.Component)
    Protected Property (Inherited from System.ComponentModel.Component)
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded. Backup the current database to a file.  
    Public MethodOverloaded. Starts a database transaction on the current connection. Because BeginTransaction creates a new transaction and associates it with the current connection that created it, you can simplify your code by using this method rather than allocating a new transaction and then assigning it manually. Class VistaDBConnection  
    Public MethodOverridden. Changes the current database for an open connection. This method is not supported and should not be called.  
    Public Methodstatic (Shared in Visual Basic)Clear all connection pools for this embedded VistaDB engine (process).  
    Public Methodstatic (Shared in Visual Basic)Clear a specific connection pool associated with the specified connection instance.  
    Public MethodOverridden. Closes the connection to the database. This is the preferred method of closing any open connection. Closes the connection to the database.  
    Public MethodCreates and returns a new VistaDBCommand object associated with the current connection.  
    Public MethodCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Overridden. Dispose the object and release all resources. A best practice for performing this automatically is to put all your VistaDBConnection objects within Using() statements to ensure they are cleaned up in a timely manner.  
    Public MethodEnlists in the specified transaction. (Inherited from System.Data.Common.DbConnection)
    Public MethodRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Overridden. Returns schema information for the data source of this System.Data.Common.DbConnection. Returns schema information for the data source of this VistaDBConnection. See the MSDN Topic "Understanding the Common Schema Collections" for in depth information about Schema collections.  
    Public MethodGets the schema for a given table from the current open connection.  
    Public MethodObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodCheck SQL command of the constraint to validate it is correct.  
    Public MethodCheck SQL command correctness. This does not actually execute the command or validate the structures on disk. It only parses the command and attempts to verify that the parser can split the tokens or not.  
    Public MethodCheck SQL command correctness of CREATE VIEW statement  
    Public MethodOverridden. Opens a database connection with the settings specified by the System.Data.Common.DbConnection.ConnectionString.Opens a database connection with the settings specified by the ConnectionString.  
    Public MethodOverloaded. An asynchronous version of System.Data.Common.DbConnection.Open, which opens a database connection with the settings specified by the System.Data.Common.DbConnection.ConnectionString. This method invokes the virtual method System.Data.Common.DbConnection.OpenAsync(System.Threading.CancellationToken) with CancellationToken.None. (Inherited from System.Data.Common.DbConnection)
    Public Methodstatic (Shared in Visual Basic)Overloaded. Pack a specified database with support for making an optional backup and use of callbacks for progress reporting.  
    Public Methodstatic (Shared in Visual Basic)Overloaded. Attempt to repair a partially corrupted database file (which may be encrypted) using optional callbacks for progress reporting.  
    Public Methodstatic (Shared in Visual Basic)Overloaded. Restores a database from a backup file created by BackupDatabase(String)  
    Public Method(BETA ONLY) Change the current optimization setting of this (open) VistaDBConnection. This setting can also be changed by executing the "SET OPTIMIZATION {0}" SQL command with the desired option.  
    Public Method (Inherited from System.ComponentModel.Component)
    Top
    Protected Methods
     NameDescription
    Protected MethodOverridden. Starts a database transaction. Starts a database transaction.  
    Protected MethodOverridden. Creates and returns a System.Data.Common.DbCommand object associated with the current connection. Create a new DbCommand object from the current VistaDBConnection.  
    Protected Method (Inherited from System.ComponentModel.Component)
    Protected Method (Inherited from System.ComponentModel.Component)
    Protected MethodOverloaded. Creates a shallow copy of the current System.MarshalByRefObject object. (Inherited from System.MarshalByRefObject)
    Protected MethodRaises the System.Data.Common.DbConnection.StateChange event. (Inherited from System.Data.Common.DbConnection)
    Top
    Public Events
     NameDescription
    Public Event (Inherited from System.ComponentModel.Component)
    Public EventCallback event for SQL PRINT Statements Class VistaDBConnection Class VistaDBInfoMessageEvent VistaDBInfoMessageEventEventArgs.Message  
    Public EventOccurs when the state of the event changes. (Inherited from System.Data.Common.DbConnection)
    Top
    See Also