Name | Description | |
---|---|---|
![]() | OleDbProvider Constructor | Perform initialization of the Provider |
The following tables list the members exposed by OleDbProvider.
Name | Description | |
---|---|---|
![]() | OleDbProvider Constructor | Perform initialization of the Provider |
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 (Always returns just the ConnectionString for OleDbProvider) |
![]() | 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. Currently not supported |
![]() | 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) |
![]() | 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 (Always returns null for OleDbProvider) |
![]() | 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 |
![]() | 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) |
![]() | GetRecordsFromSproc | Get records from stored procedure using passed parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseStoredProcedureProvider) |
![]() | GetServerNameFromConnectionString | Overridden. Get the server name from the connection string (Always returns null for OleDbProvider) |
![]() | GetTruncateSql | Overridden. Get the sql to truncate a table. |
![]() | GetUpdateTablesSql | Get the SQL to update the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
![]() | 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 | Overridden. For OLEDB table names and field names are not wrapped in square brackets or back ticks |