Name | Description | |
---|---|---|
SqLiteProvider Constructor | Perform initialization of the Provider |
The following tables list the members exposed by SqLiteProvider.
Name | Description | |
---|---|---|
SqLiteProvider 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. SqLite 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 SqLite @ | |
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 the connection string for SqLite) | |
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) | |
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 | 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 the passed in 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 the 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 last inserted identity | |
GetIdentitySql | Get the SQL for the identity of the last inserted row | |
GetIndexesForTable | Get the indexes for a table | |
GetLimitClause | Get a limit clause for a provider | |
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. | |
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) |