dotConnect for SQLite Components

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

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.

Class

Description

Core ADO.NET Classes
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
SQLiteCommandBuilder*

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
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
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.