dotConnect for SQLite

.NET Connector for SQLite with ORM Support

dotConnect for SQLite is a high-performance ORM enabled ADO.NET provider for SQLite. It builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.

dotConnect for SQLite is the best solution to use SQLite in .NET Framework and develop SQLite .NET applications. It allows integrating SQLite with .NET data-related technologies, like ADO.NET, Entity Framework, Entity Framework Core and build all kinds of SQLite .NET applications - ASP.NET applications and websites, Console, WinForms, .NET MAUI apps, etc.

Our .NET Framework data provider for SQLite supports a wide range of SQLite-specific features, such as user-defined functions, CEROD, SQLiteCrypt, and SEE encryption extensions, support for enabling SQLite extensions with connection string parameters, etc.

Features

ASP.NET

Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.

Performance

Uses many SQLite-specific performance features & optimizations to ensure the highest performance.

Monitoring

Allows per-component tracing of database events with a free dbMonitor application.

Security

Supports various encryption ciphers, SSL and SSH connections, etc.

Full list of features

Compatibility

The following table show which version of this package to use with which version of frameworks.

Frameworks	Version support
Entity Framework Core	8, 7, 6, 5, 3, 2, 1
.NET	8, 7, 6, 5
.NET Core	3, 2, 1
.NET Framework	4.8, 4.7, 4.6, 4.5

More information here

Usage

SQLite is an embedded relational database management system. SQLite engine and its interface are implemented in the one library (sqlite3.dll) that increases the speed of the query execution. dotConnect for SQLite places this library to the system directory during installation. So you can either specify the existing database file you want to work with to the SQLiteConnection object or let dotConnect for SQLite to create the necessary file if it does not exist yet.

This snippet directly configures a SQLite connection using a connection string.

using Devart.Data.SQLite;
...
SQLiteConnection sqLiteConnection = new SQLiteConnection();
sqLiteConnection.ConnectionString = @"Data Source=D:\TestApplication\database.db;FailIfMissing=False;";

Read the full documentation for connection here.

Enhanced ORM Support

dotConnect for SQLite offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our SQLite ADO.NET Provider supports the following ORMs:

Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, 3.x, 5.0, 6.0, 7.0, and 8.0
NHibernate
Dapper

Advanced Visual Studio Integration with SQLite

dotConnect for SQLite provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.

SQLite ADO.NET Provider supports advanced Visual Studio integration (DDEX) and provides convenient visual component editors to simplify component tweaking.

License

See pricing options for ordering.

Trial Limitations

The dotConnect for SQLite Evaluation License lets you try dotConnect for SQLite Trial Edition for a period of 30 days. You may not use applications developed using Trial versions of the Software for any commercial purposes.

Devart Software