dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace
See Also  Inheritance Hierarchy Send comments on this topic.

Classes

 ClassDescription
ClassSQLiteAggregateFunction Base class for user-defined aggregate functions.
ClassSQLiteAggregateFunction<TResult> Generic base class for user-defined aggregate functions without parameters.
ClassSQLiteAggregateFunction<T1,TResult> Generic base class for user-defined aggregate functions with one parameter.
ClassSQLiteAggregateFunction<T1,T2,TResult> Generic base class for user-defined aggregate functions with two parameters.
ClassSQLiteAggregateFunction<T1,T2,T3,TResult> Generic base class for user-defined aggregate functions with three parameters.
ClassSQLiteAggregateFunction<T1,T2,T3,T4,TResult> Generic base class for user-defined aggregate functions with four parameters.
ClassSQLiteAggregateFunction<T1,T2,T3,T4,T5,TResult> Generic base class for user-defined aggregate functions with four parameters.
ClassSQLiteAggregateFunction<T1,T2,T3,T4,T5,T6,TResult> Generic base class for user-defined aggregate functions with four parameters.
ClassSQLiteAggregateFunction<T1,T2,T3,T4,T5,T6,T7,TResult> Generic base class for user-defined aggregate functions with four parameters.
ClassSQLiteAggregateFunction<T1,T2,T3,T4,T5,T6,T7,T8,TResult> Generic base class for user-defined aggregate functions with four parameters.
ClassSQLiteBlob Represents a variable-length stream of binary data to be stored in or retrieved from a database.
ClassSQLiteCollationFunction Base class for user-defined collation functions.
ClassSQLiteCommand Represents a SQL statement to execute against SQLite.
ClassSQLiteCommandBuilder Automatically generates single-table commands used to reconcile changes made to a System.Data.DataSet with the SQLite.
ClassSQLiteConnection Represents an open connection to SQLite.
ClassSQLiteConnectionStringBuilder Generates automatically connection strings used to connect to SQLite.
ClassSQLiteDataAdapter Represents a set of data commands and a data source connection that are used to fill the System.Data.DataSet and update a SQLite data.
ClassSQLiteDataReader Reads a forward-only stream of rows from SQLite.
ClassSQLiteDataSet Represents an in-memory cache of data with support for SQLite-specific features.
ClassSQLiteDataTable Represents a single object that provides all of the functionality needed to retrieve and manipulate data from a SQLite data source.
ClassSQLiteDump Serves to store a database or its parts as a script and also to restore database from the received script.
ClassSQLiteErrorEventArgs Provides data for the SQLiteConnection.Error event.
ClassSQLiteException The exception that is generated when SQLite returns an error.
ClassSQLiteFunction Base class for user-defined functions.
ClassSQLiteMetaDataCollectionNames Enumerates collection names you can use for metadata retrieval purposes.
ClassSQLiteMonitor Monitors dynamic SQL execution in applications that use dotConnect for SQLite.
ClassSQLiteParameter Represents a parameter to a SQLiteCommand, and optionally, its mapping to System.Data.DataSet columns.
ClassSQLiteParameterCollection Collects all parameters relevant to a SQLiteCommand as well as their respective mappings to System.Data.DataSet columns.
ClassSQLiteProviderFactory Represents a factory required to create inheritors of generic base classes to use with dotConnect for SQLite.
ClassSQLiteRowUpdatedEventArgs Provides data for the SQLiteDataAdapter.RowUpdated event.
ClassSQLiteRowUpdatingEventArgs Provides data for the SQLiteDataAdapter.RowUpdating event. This class cannot be inherited.
ClassSQLiteScalarFunction Base class for user-defined scalar functions.
ClassSQLiteScalarFunction<TResult> Base class for user-defined scalar functions with no parameters.
ClassSQLiteScalarFunction<T1,TResult> Base class for user-defined scalar functions with one parameter.
ClassSQLiteScalarFunction<T1,T2,TResult> Base class for user-defined scalar functions with two parameters.
ClassSQLiteScalarFunction<T1,T2,T3,TResult> Base class for user-defined scalar functions with three parameters.
ClassSQLiteScalarFunction<T1,T2,T3,T4,TResult> Base class for user-defined scalar functions with four parameters.
ClassSQLiteScalarFunction<T1,T2,T3,T4,T5,TResult> Base class for user-defined scalar functions with four parameters.
ClassSQLiteScalarFunction<T1,T2,T3,T4,T5,T6,TResult> Base class for user-defined scalar functions with four parameters.
ClassSQLiteScalarFunction<T1,T2,T3,T4,T5,T6,T7,TResult> Base class for user-defined scalar functions with four parameters.
ClassSQLiteScalarFunction<T1,T2,T3,T4,T5,T6,T7,T8,TResult> Base class for user-defined scalar functions with four parameters.
ClassSQLiteScript Serves to execute series of SQL statements separated by special symbols.
ClassSQLiteSelectLimit Represents SQLite LIMIT clause.
ClassSQLiteSelectStatement Represents SQLite SELECT statement.
ClassSQLiteText Represents a variable-length stream of characters to be stored in or retrieved from the database.
ClassSQLiteTransaction Represents a SQL transaction to be made in the SQLite database.

Structures

 StructureDescription
StructureSQLiteDateTime Represents the SQLite datetime data type.

Delegates

 DelegateDescription
DelegateSQLiteErrorEventHandler Represents the method that will handle the SQLiteConnection.Error event of SQLiteConnection.
DelegateSQLiteProgressCallback Represents the method that can be registered as a callback function to be called periodically during long running calls to the database.
DelegateSQLiteRowUpdatedEventHandler Represents the method that will handle the SQLiteDataAdapter.RowUpdated event of an SQLiteDataAdapter.
DelegateSQLiteRowUpdatingEventHandler Represents the method that will handle the SQLiteDataAdapter.RowUpdating event of an SQLiteDataAdapter.

Enumerations

 EnumerationDescription
EnumerationAutoVacuumMode Determines the auto-vacuum flag in the database.
EnumerationEncryptionMode Determines whether the database is encrypted and kind of the database encryption.
EnumerationJournalMode Determines the journal mode for database.
EnumerationLockingMode Determines whether the database is locked or not.
EnumerationSQLiteDateFormats Determines the format of datetime fields.
EnumerationSQLiteDumpObjects Determines which database objects will be included in the dump text.
EnumerationSQLiteErrorCode Determines the type of error that occurred in the database.
EnumerationSQLiteForeignKeyConstraints Determines whether to enforce foreign key constraints.
EnumerationSQLiteSecureDelete Determines whether to overwrite the deleted data with zeroes.
EnumerationSQLiteTransactionMode Determines how the database is locked during transactions.
EnumerationSQLiteType Specifies the data type of a field or a parameter.
EnumerationSynchronizationMode Determines how the database is synchronized with writing to hard disk.
EnumerationTempStoreMode Determines where temporary tables and indices are stored.

See Also