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.