Knight Data Access Layer
MsAccessProvider Class Methods


KellermanSoftware.NetDataAccessLayer.Providers Namespace : MsAccessProvider Class

For a list of all members of this type, see MsAccessProvider members.

Public Methods
 NameDescription
Public Method Begin a new transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverridden.  Build a connection string based on the passed in database. (For MS Access it just returns the connection string)  
Public MethodOverridden.  Change database. Currently not supported  
Public MethodOverloaded.  Clear the file log (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Close the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Commit the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Opens and closes the connection to ensure it is valid. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Get the number of records in a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverridden.  Create new database  
Public MethodOverridden.  Check database existance  
Public Method Disable all logging (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Close the connection on Dispose (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Drop (remove) a table from the database (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverloaded.  Log to the console (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverloaded. Overridden.  Execute a query and return the number of affected records  
Public MethodOverloaded.  Execute the passed query and return the first column of the first row (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverloaded.  Fill a data table with the passed sql and parameters (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Returns true if the Foreign Key Exists (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverridden.  Get the SQL for adding a column to an existing table  
Public MethodOverridden.  Get all constraints for the current database  
Public MethodOverridden.  Get portion of SQL used for the column definition for add column and create table sql  
Public MethodOverridden.  MS Acess doesn't support comments  
Public MethodOverridden.  MS Acess doesn't support comments  
Public Method Get the SQL to create an index  
Public MethodOverridden.  Currently not supported  
Public Method Get the SQL for creating a table with the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverridden.  Get the SQL for creating a table with composite keys  
Public MethodOverridden.  Get the SQL for creating a table with a primary key  
Public Method Get the SQL to create the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverridden.  Currently not supported  
Public MethodOverridden.  Get database name from connection string.  
Public MethodOverridden.  Get a list of databases for the database server  
Public MethodOverridden.  Get the current date of the database server  
Public MethodOverridden.  Get a list of tables for the current database  
Public MethodOverridden.  Get the database field type for the passed standard DbType  
Public MethodOverloaded.  Get a datatable from the passed sql (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverridden.  Get the generic database type for the specific database type  
Public MethodOverridden.  Get the database field type for the passed standard DbType  
Public MethodOverridden.  Currently not supported  
Public MethodOverridden.  Get the sql to drop a table  
Public MethodOverridden.  Currently not supported  
Public MethodOverridden.  Get the .NET type for a database column type  
Public Method Get the identity for the last inserted record  
Public Method Get the SQL used to get the identity for the last inserted record  
Public Method Get the indexes for a table  
Public Method Get the maximum value for the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Get the SQL required to get the maximum value of the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Generate SQL that will get a page of records  
Public MethodOverridden.  Get the server name from the connection string  
Public Method Get the top clause for a provider.  
Public MethodOverridden.  Get the sql to truncate a table.  
Public Method Get the SQL to update the tables (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Detect if an index exists  
Public MethodOverloaded.  Get a list of records using the passed SQL (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverloaded.  Get a single record from a table with a parameterized where clause (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Get a page of records for a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverloaded.  Get a limited number of records for a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Mark foreign key columns by convention (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Mark Primary Key in a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Mark primary key columns by convention (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Open the database connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverloaded.  Returns true if the record exists (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Perform a rollback of the current transaction (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public MethodOverridden.  Returns true if the table exists in the database  
Public Method Delete all the records from a table (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Public Method Wrap a table name or field name in square brackets (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Top
Protected Methods
 NameDescription
Protected Method Add constraints. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected Method Adds the foreign key constraints. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected Method Build the sql for fields other than the primary key (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodOverridden.  Adds parameters to the given command  
Protected Method Builds the top records SQL. (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected Method Creates new command with the given command text (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected Method Creates new connection (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected Method Creates data adapter using the given select command (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected Method Get SQL for batch end (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodOverridden.  Get the primary key columns for a table from the schema  
Protected Method Gets records using the given command (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected Method Get SQL for batch start (Inherited from KellermanSoftware.NetDataAccessLayer.BaseDatabaseProvider)
Protected MethodOverridden.  Intercept the SQL and change it with the passed parameters  
Protected MethodOverridden.  Sets parameter using the given parameter value  
Top
See Also

Reference

MsAccessProvider Class
KellermanSoftware.NetDataAccessLayer.Providers Namespace