Name | Description | |
---|---|---|
VistaDb4Provider Constructor | Perform initialization of the Provider |
The following tables list the members exposed by VistaDb4Provider.
Name | Description | |
---|---|---|
VistaDb4Provider Constructor | Perform initialization of the Provider |
Name | Description | |
---|---|---|
Connection | Get a reference to the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
ConnectionString | The connection string (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
DatabaseName | Overridden. Returns database name | |
DirtyReadClause | Overridden. VistaDB does not support dirty reads | |
FriendlyProviderName | Overridden. Get a friendly name for the provider | |
IsConnectionOpen | True if the connection is open (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
IsFileBasedDatabase | Overridden. The database is a single file | |
IsInTransaction | True if we are inside a transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
LicenseKey | The license key for the license (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
ParameterPrefix | Overridden. A string to prefix parameters for VistaDB @ | |
SupportComments | Returns true if the provider supports comments (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
Transaction | Get a reference to the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
UserName | The user name for the license (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
Name | Description | |
---|---|---|
IsBatchMode | Returns true if batch mode is active (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
Name | Description | |
---|---|---|
BeginTransaction | Begin a new transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
BuildDatabaseSpecificConnectionString | Overridden. Build a connection string based on the passed in database (just returns Connection string for VistaDb) | |
ChangeDatabase | Overridden. Change database. | |
ClearLog | Overloaded. Clear the file log (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
CloseConnection | Close the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
CommitTransaction | Commit the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
ConnectionValid | Opens and closes the connection to ensure it is valid. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
CountRecordsInTable | Get the number of records in a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
CreateDatabase | Overridden. Create new database | |
DatabaseExists | Overridden. Check database existance | |
DisableLogging | Disable all logging (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
Dispose | Close the connection on Dispose (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
DropTable | Drop (remove) a table from the database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
EnableLogging | Overloaded. Log to the console (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
ExecuteNonQuery | Overloaded. Execute the passed query and return the number of affected records (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
ExecuteNonQuerySproc | Overloaded. Execute the passed stored procedure and return the number of affected records. Output parameters will be set on return. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) | |
ExecuteScalar | Overloaded. Execute the passed query and return the first column of the first row (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
ExecuteScalarSproc | Overloaded. Execute the passed stored procedure and return the first column of the first row (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) | |
FillDataTable | Overloaded. Fill a data table with the passed sql and parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
ForeignKeyExists | Returns true if the Foreign Key Exists (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetAddColumnSql | Get the SQL for adding a column to an existing table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetAllForeignKeyConstraints | Overridden. Get all constraints for the current database | |
GetColumnDefinitionSql | Overridden. Get portion of SQL used for the column definition for add column and create table sql | |
GetCommentLine | Get sql comment using the given comment text (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetCommentSeparatorLine | Get comment separator line (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetCreateIndexSql | Get the SQL to create an index | |
GetCreateSequenceSql | Overridden. Currently not supported | |
GetCreateTableSql | Get the SQL for creating a table with the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetCreateTableSqlWithCompositeKey | Overridden. Get the SQL for creating a table with composite keys | |
GetCreateTableSqlWithPrimaryKey | Overridden. Get the SQL for creating a table with a primary key | |
GetCreateTablesSql | Get the SQL to create the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetCreateTriggerSql | Overridden. Currently not supported | |
GetDatabaseNameFromConnectionString | Overridden. Get database name from connection string. | |
GetDatabases | Overridden. Get a list of databases for the database server | |
GetDatabaseServerDate | Overridden. Get the current date of the database server | |
GetDatabaseTables | Overridden. Get a list of tables for the current database | |
GetDatabaseTypeForDbType | Overridden. Get the database field type for the passed standard DbType | |
GetDataTable | Overloaded. Get a datatable from the passed sql (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetDbType | Overridden. Get a DbType associated with a string from a database | |
GetDbTypeForClrType | Get the DbType for provided ClrType (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetDropSequenceSql | Overridden. Currently not supported | |
GetDropTableSql | Overridden. Get the sql to drop a table | |
GetDropTriggerSql | Overridden. Currently not supported | |
GetFieldType | Overridden. Get a .NET type associated with a string from a database | |
GetIdentity | Get the identity of the last record that was inserted | |
GetIdentitySql | Get the SQL used to get the identity for the last inserted record | |
GetIndexesForTable | Get the indexes for the table | |
GetMaxPrimaryKey | Get the maximum value for the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetMaxPrimaryKeySql | Get the SQL required to get the maximum value of the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
GetPagingSql | Generate SQL that will get a page of records | |
GetRecordsFromSproc | Get records from stored procedure using passed parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) | |
GetServerNameFromConnectionString | Overridden. Get the server name from the connection string. | |
GetTopClause | Get the top clause for a provider. | |
GetTruncateSql | Overridden. Get the sql to truncate a table. | |
GetUpdateTablesSql | Get the SQL to update the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
IndexExists | Returns true if an index exists | |
Load | Overloaded. Get a list of records using the passed SQL (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
LoadFromSproc | Overloaded. Get records by stored procedure with the passed parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) | |
LoadOne | Overloaded. Get a single record from a table with a parameterized where clause (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
LoadPage | Get a page of records for a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
LoadTop | Overloaded. Get a limited number of records for a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
MarkForeignKeys | Mark foreign key columns by convention (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
MarkPrimaryKey | Mark Primary Key in a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
MarkPrimaryKeys | Mark primary key columns by convention (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
OpenConnection | Open the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
RecordExists | Overloaded. Returns true if the record exists (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
RollbackTransaction | Perform a rollback of the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
StoredProcedureExists | Overridden. Returns true if the stored procedure exists in the database | |
TableExists | Overridden. Returns true if the table exists in the database | |
TruncateTable | Delete all the records from a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) | |
Wrap | Wrap a table name or field name in square brackets (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |