| Name | Description | |
|---|---|---|
 | MsAccessProvider Constructor | Perform initialization of the Provider |
The following tables list the members exposed by MsAccessProvider.
Public Constructors
Public Properties
| 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. MS Access 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 Access @ |
| SupportComments | Overridden. Returns true if the provider supports comments |
| 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) |
Protected Properties
| Name | Description | |
|---|---|---|
 | IsBatchMode | Returns true if batch mode is active (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
Public Methods
| Name | Description | |
|---|---|---|
 | BeginTransaction | Begin a new transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| BuildDatabaseSpecificConnectionString | Overridden. Build a connection string based on the passed in database. (For MS Access it just returns the connection string) |
| ChangeDatabase | Overridden. Change database. Currently not supported |
| 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. Overridden. Execute a query and return the number of affected records |
| ExecuteScalar | Overloaded. Execute the passed query and return the first column of the first row (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| 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 | Overridden. Get the SQL for adding a column to an existing table |
| 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 | Overridden. MS Acess doesn't support comments |
| GetCommentSeparatorLine | Overridden. MS Acess doesn't support comments |
| 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 the generic database type for the specific database type |
| GetDbTypeForClrType | Overridden. Get the database field type for the passed standard DbType |
| GetDropSequenceSql | Overridden. Currently not supported |
| GetDropTableSql | Overridden. Get the sql to drop a table |
| GetDropTriggerSql | Overridden. Currently not supported |
| GetFieldType | Overridden. Get the .NET type for a database column type |
| GetIdentity | Get the identity for the last inserted record |
| GetIdentitySql | Get the SQL used to get the identity for the last inserted record |
| GetIndexesForTable | Get the indexes for a 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 |
| 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 | Detect if an index exists |
| Load | Overloaded. Get a list of records using the passed SQL (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider) |
| 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) |
| 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) |
Protected Methods
Top
See Also