dotConnect for SQLite is a high-performance ORM enabled data provider for SQLite that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 2.0+, .NET 5+. It supports a wide range of SQLite-specific features, such as a variety of built-in encryption methods, including TripleDES, Blowfish, AES128, AES192, AES256, Cast128, and RC4. We provide integration with advanced encryption solutions such as SQLiteCrypt and SQLCipher, which typically require separate licenses but are included in our product at no extra cost. Additionally, it supports user-defined functions, CEROD, support for enabling SQLite extensions with connection string parameters, and others. More information at https://www.devart.com/dotconnect/sqlite/ License dotConnect for SQLite is available in several editions https://www.devart.com/dotconnect/sqlite/ordering.html The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. Key Features * Built-in SQLite Encryption: Supports robust encryption for your SQLite databases such as TripleDES, Blowfish, AES128, AES192, AES256, Cast128, RC4. * Easy Connection: Allows your application to work with SQLite. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many SQLite-specific performance features and optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.
Get Started
$ dotnet add package Devart.Data.SQLiteReadme
dotConnect for SQLite
dotConnect for SQLite is a high-performance ORM enabled data provider for SQLite that builds on ADO.NET technology.
The provider works with .NET Frameworks 2.0+, .NET Core 2.0+, .NET 5+.
It supports a wide range of SQLite-specific features, such as a variety of built-in encryption methods, including TripleDES, Blowfish, AES128, AES192, AES256, Cast128, and RC4. We provide integration with advanced encryption solutions such as SQLiteCrypt and SQLCipher, which typically require separate licenses but are included in our product at no extra cost. Additionally, it supports user-defined functions, CEROD, support for enabling SQLite extensions with connection string parameters, and others.
More information at dotConnect for SQLite.
Compatibility
The following table show which version of this package to use with which version of frameworks.
| Frameworks | Version support |
|---|---|
| .NET | 10, 9, 8, 7, 6, 5 |
| .NET Core | 3, 2 |
| .NET Framework | 4.8, 4.7, 4.6.2, 4.6.1 |
More information here
Installation
For projects, using general ADO.NET functionality of dotConnect for SQLite, you need to install the Devart.Data.SQLite package. Execute the following command in the Package Manager Console:
Install-Package Devart.Data.SQLite
For projects, using Entity Framework Core 3, 5, 6, 7, 8, 9, 10 with SQLite, install the Devart.Data.SQLite.EFCore package.
For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.SQLite.EF6 package.
License
dotConnect for SQLite is available in several editions. See pricing options for ordering.
The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial.
Usage
In this example, a new instance of the SQLiteConnection class (part of the Devart.Data.SQLite namespace) is created. This snippet simplifies the SQLite connection setup by directly assigning a connection string to the ConnectionString property of the SQLiteConnection object:
using Devart.Data.SQLite;
...
SQLiteConnection connection = new SQLiteConnection();
connection.ConnectionString = @"DataSource=database.db;FailIfMissing=False;";
ASP.NET Core and Blazor
Configuration File Snippet (appsettings.json):
{
"ConnectionStrings": {
"DefaultConnection": "DataSource=database.db;FailIfMissing=False;"
}
}
Dependency Injection of IConfiguration:
private readonly IConfiguration configuration;
public YourController(IConfiguration config)
{
configuration = config;
}
Retrieving a Connection String:
var connectionString = configuration.GetConnectionString("DefaultConnection");
var connection = new SQLiteConnection(connectionString);
For more information about SQLite connection read at our documentation.
Key Features
- Built-in SQLite Encryption: Supports robust encryption for your SQLite databases such as TripleDES, Blowfish, AES128, AES192, AES256, Cast128, RC4.
- Easy Connection: Allows your application to work with SQLite.
- ASP.NET Core: Supports ASP.NET Core Identity.
- 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.
- Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.