dotConnect for SQLite Documentation
In This Topic
    Components
    In This Topic

    This topic presents a brief description of the classes and components included in dotConnect for SQLite. Click on the name of each component for more information.

    Core ADO.NET Classes

    Class Description
    SQLiteConnection Establishes a connection to SQLite database and manages transactions.
    SQLiteCommand Executes SQL statements at SQLite database.
    SQLiteDataReader Exposes and reads a forward-only stream of data from SQLite database.
    SQLiteDataAdapter* Populates a DataSet and resolves updates with SQLite database.
    SQLiteTransaction Starts, commits, or rolls back server transactions.
    SQLiteParameter Represents input parameters for commands.
    SQLiteException Represents an error encountered at SQLite database. For an error encountered at the client, dotConnect for SQLite throws a .NET Framework exception.

    Complementary ADO.NET Classes

    Class Description
    SQLiteCommandBuilder* A helper object that automatically generates command properties of SQLiteDataAdapter* and populates the SQLiteParameter collection of SQLiteCommand object.
    SQLiteConnectionStringBuilder Constructs a connection string by assigning values to appropriate properties.
    SQLiteDataSource** Enables flexible data binding for ASP.NET applications.

    dotConnect for SQLite Advanced Classes

    Class Description
    SQLiteDataTable* Provides all of the functionality needed to retrieve and manipulate data from a SQLite database data source. Combines connected and disconnected data access models.
    SQLiteDataSet* Represents typed and untyped SQLite-specific datasets. Bases on SQLiteDataTable objects to build the schema.
    DataLink** Serves to establish flexible cross-form data binding.

    dotConnect for SQLite Auxiliary Classes

    Class Description
    SQLiteScript Serves to execute series of SQL statements.
    SQLiteDump* Serves to store a database or its parts as a script and also to restore database from the received script.
    SQLiteMonitor Serves to monitor dynamic SQL execution in applications that use dotConnect for SQLite.

    * This class is not available in the dotConnect for SQLite .NET Standard 1.3 compatible assemblies. It is supported only for full .NET Framework and .NET Standard 2.0.

    ** This class is supported only for full .NET Framework. It is not available in the dotConnect for SQLite .NET Standard compatible assemblies.