Name | Description | |
---|---|---|
VistaDBConnection Constructor | Overloaded. |
The following tables list the members exposed by VistaDBConnection.
Name | Description | |
---|---|---|
VistaDBConnection Constructor | Overloaded. |
Name | Description | |
---|---|---|
SystemSchema | System table name | |
SystemTableType | System table type name | |
UserTableType | User table type name |
Name | Description | |
---|---|---|
CompatibilityModeSetting | Gets the CompatibilityMode setting from the connection string for this connection. Read only, may not be changed after opening the connection. | |
ConnectionString | Overridden. Gets or sets the string used to open the connection.Gets or sets the string used to open the connection. | |
ConnectionTimeout | Gets the time to wait while establishing a connection before terminating the attempt and generating an error. (Inherited from System.Data.Common.DbConnection) | |
Container | (Inherited from System.ComponentModel.Component) | |
ContextConnection | Used only inside CLR stored procedures. If it is set to true the context connection is used. | |
Database | Overridden. 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. | |
DataSource | Overridden. Gets the name of the database server to which to connect. Get the name of the database. | |
IsolatedStorage | If it is set to true the database placed in isolated storage. | |
LockTimeout | An 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. | |
OpenMode | Gets a value that indicates connection open mode. | |
OptimizationLevel | (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. | |
OptimizationVersionLevel | (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. | |
PageSize | Get the PageSize of the currently open database. Will return 0 if the connection is not open. | |
Password | Get the string used for the base of the encryption key. | |
PersistentLockFiles | Control 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. | |
ProcessProtection | Gets the ProcessProtection setting from the connection string for this connection. Read only, may not be changed after opening the connection. | |
ServerVersion | Overridden. 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) | |
Site | (Inherited from System.ComponentModel.Component) | |
State | Overridden. Gets a string that describes the state of the connection. Gets a value that describes the state of the connection. | |
TransactionMode | Gets the current TransactionMode for this connection. Read only, may not be changed after opening the connection. Class VistaDBConnection Class VistaDBConnectionStringBuilder |
Name | Description | |
---|---|---|
CanRaiseEvents | (Inherited from System.ComponentModel.Component) | |
DbProviderFactory | Overridden. Gets the System.Data.Common.DbProviderFactory for this System.Data.Common.DbConnection. DB Provider Factory object | |
DesignMode | (Inherited from System.ComponentModel.Component) | |
Events | (Inherited from System.ComponentModel.Component) |
Name | Description | |
---|---|---|
BackupDatabase | Overloaded. Backup the current database to a file. | |
BeginTransaction | Overloaded. 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 | |
ChangeDatabase | Overridden. Changes the current database for an open connection. This method is not supported and should not be called. | |
ClearAllPools | Clear all connection pools for this embedded VistaDB engine (process). | |
ClearPool | Clear a specific connection pool associated with the specified connection instance. | |
Close | Overridden. Closes the connection to the database. This is the preferred method of closing any open connection. Closes the connection to the database. | |
CreateCommand | Creates and returns a new VistaDBCommand object associated with the current connection. | |
CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject) | |
Dispose | Overloaded. 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. | |
EnlistTransaction | Enlists in the specified transaction. (Inherited from System.Data.Common.DbConnection) | |
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
GetSchema | Overloaded. 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. | |
GetTableSchema | Gets the schema for a given table from the current open connection. | |
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
IsConstraintSyntaxCorrect | Check SQL command of the constraint to validate it is correct. | |
IsSyntaxCorrect | Check 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. | |
IsViewSyntaxCorrect | Check SQL command correctness of CREATE VIEW statement | |
Open | Overridden. 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. | |
OpenAsync | Overloaded. 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) | |
PackDatabase | Overloaded. Pack a specified database with support for making an optional backup and use of callbacks for progress reporting. | |
RepairDatabase | Overloaded. Attempt to repair a partially corrupted database file (which may be encrypted) using optional callbacks for progress reporting. | |
RestoreDatabase | Overloaded. Restores a database from a backup file created by BackupDatabase(String) | |
SetOptimizationLevel | (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. | |
ToString | (Inherited from System.ComponentModel.Component) |
Name | Description | |
---|---|---|
BeginDbTransaction | Overridden. Starts a database transaction. Starts a database transaction. | |
CreateDbCommand | Overridden. Creates and returns a System.Data.Common.DbCommand object associated with the current connection. Create a new DbCommand object from the current VistaDBConnection. | |
Finalize | (Inherited from System.ComponentModel.Component) | |
GetService | (Inherited from System.ComponentModel.Component) | |
MemberwiseClone | Overloaded. Creates a shallow copy of the current System.MarshalByRefObject object. (Inherited from System.MarshalByRefObject) | |
OnStateChange | Raises the System.Data.Common.DbConnection.StateChange event. (Inherited from System.Data.Common.DbConnection) |
Name | Description | |
---|---|---|
Disposed | (Inherited from System.ComponentModel.Component) | |
InfoMessage | Callback event for SQL PRINT Statements Class VistaDBConnection Class VistaDBInfoMessageEvent VistaDBInfoMessageEventEventArgs.Message | |
StateChange | Occurs when the state of the event changes. (Inherited from System.Data.Common.DbConnection) |