Devart.Data.SQLite
7.1.100
Prefix Reserved
dotnet add package Devart.Data.SQLite --version 7.1.100
NuGet\Install-Package Devart.Data.SQLite -Version 7.1.100
<PackageReference Include="Devart.Data.SQLite" Version="7.1.100" />
<PackageVersion Include="Devart.Data.SQLite" Version="7.1.100" />
<PackageReference Include="Devart.Data.SQLite" />
paket add Devart.Data.SQLite --version 7.1.100
#r "nuget: Devart.Data.SQLite, 7.1.100"
#:package Devart.Data.SQLite@7.1.100
#addin nuget:?package=Devart.Data.SQLite&version=7.1.100
#tool nuget:?package=Devart.Data.SQLite&version=7.1.100
Advanced C# Connection Provider 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, .NET Core, .NET.
It supports a wide range of SQLite-specific features, such as built-in database encryption including TripleDES, Blowfish, AES128, AES192, AES256, Cast128, and RC4, integration with SQLiteCrypt and SQLCipher, user-defined functions, CEROD support, and others. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking.
More information at dotConnect for SQLite.
Installation
- Install the NuGet Package
Install-Package Devart.Data.SQLite
- Activate license
- Free Trial License: Evaluate the full capabilities of dotConnect for SQLite in a non-commercial environment—ideal for development and testing. Start your free trial
- Commercial License: Deploy dotConnect for SQLite in commercial applications and access full technical support with a valid license. Purchase a license
Work with EF Core and Entity Framework
For projects, using Entity Framework Core 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.
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.1, 3.0, 2.2, 2.1, 2.0 |
| .NET Framework | 4.8, 4.7, 4.6.2, 4.6.1 |
More information here
Key Features
- Built-in SQLite Encryption: Protect your SQLite databases with robust built-in encryption methods including TripleDES, Blowfish, AES128, AES192, AES256, Cast128, and RC4. Integration with SQLiteCrypt and SQLCipher is included at no extra cost.
- Easy Connection — No Server Required: Connect directly to SQLite database files without any additional client software or server infrastructure, enabling simple deployment in any environment.
- Full ADO.NET Compatibility: 100% compliant with ADO.NET standards, supporting key interfaces such as DbConnection, DbCommand, DataSet, and DataTable for seamless integration into .NET applications.
- Extensibility: Supports user-defined functions, CEROD, SEE extensions, and SQLite extensions configurable via connection string parameters for advanced customization.
- High Performance Data Access: Built-in SQLite-specific optimizations, efficient connection pooling, batch update processing, and asynchronous command execution ensure high throughput for demanding applications.
- Broad Platform Compatibility: Fully compatible with .NET Framework, .NET Core, and .NET, supporting everything from legacy enterprise systems to modern cloud-native and mobile applications.
- Disconnected Data Management: Manage relational data offline using SQLiteDataSet and SQLiteDataTable, with support for batch updates, UI data binding, and local data manipulation.
- Real-Time Monitoring: Track database operations using the dbMonitor utility for per-component tracing of SQLite database events.
- Visual Studio Integration: Accelerate development with wizards for connection setup, typed DataSet generation, and schema management—all embedded in Visual Studio.
- Priority Support and Continuous Improvement: Backed by dedicated technical support and regular updates that deliver security enhancements, feature improvements, and long-term stability.
Usage
To help you get started quickly, here's a simple code example demonstrating how to connect to a SQLite database.
using Devart.Data.SQLite;
namespace SQLiteConsoleApp
{
class Program
{
static void Main(string[] args)
{
string databasePath = @"path\to\your\sakila.db;";
string connectionString = $"Data Source={databasePath};License Key=**********";
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
try
{
connection.Open();
Console.WriteLine("Connection successful!");
}
catch (Exception ex)
{
Console.WriteLine($"Connection failed: {ex.Message}");
}
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
}
Basic Connection Strings
| Property | Meaning |
|---|---|
| Data Source | Specifies the path and name of the SQLite database file. |
| FailIfMissing | If True, throws an exception when the database file is not found; if False, creates a new empty database. |
| Password | Specifies the password for accessing an encrypted database. |
| Encryption | Specifies the encryption method (e.g., AES256, SQLiteCrypt, SQLCipher). |
| License Key | Specify your license key in this parameter. |
For more detailed tutorials, API reference, and advanced examples, visit our Getting Started guide.
Related Packages
Support Area
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- Devart.Data (>= 7.0.100)
- System.Diagnostics.PerformanceCounter (>= 10.0.5)
NuGet packages (5)
Showing the top 5 NuGet packages that depend on Devart.Data.SQLite:
| Package | Downloads |
|---|---|
|
Devart.Data.SQLite.EFCore
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. |
|
|
Devart.Data.SQLite.Linq
dotConnect for SQLite is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with advanced support for ORMs, such as Entity Framework and LinqConnect and offers a complete solution for developing database-related applications and web sites. It introduces new approaches for designing a data access layer and boosts the productivity of database application development. This package contains the .NET Standard/.NET Core compatible assemblies with LinqConnect-related functionality of dotConnect for SQLite. LinqConnect (LINQ to SQLite) is a fast OR/M solution, having a LINQ to SQL-compatible interface, but also providing its own advanced features. This package contains only runtime features of dotConnect for SQLite. dotConnect for SQLite is also provided as an installation package (exe), which installs runtime assemblies for Full .NET Framework and a set of design-time tools, integrated into Visual Studio - Server Explorer integration, DataSet tools, Windows Forms components with powerful design-time, etc. It also includes visual ORM designer for Entity Framework, Entity Framework Core, and LinqConnect ORM models. You can download it at www.devart.com. 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. |
|
|
Devart.Data.SQLite.EF6
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. |
|
|
Devart.Data.Universal.SQLite
dotConnect Universal is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies. It introduces new approaches for designing a data access layer and boosts the productivity of DB application development. dotConnect offers a complete solution for developing DB-related applications and web sites. This package contains the .NET Standard/.NET Core compatible assemblies with general ADO.NET functionality of dotConnect Universal - main ADO.NET classes, Universal data types support, etc. This package contains only runtime features of dotConnect Universal. dotConnect Universal is also provided as an installation package (exe), which installs runtime assemblies for Full .NET Framework and a set of design-time tools, integrated into Visual Studio - Server Explorer integration, DataSet tools, Windows Forms components with powerful design-time, etc. https://www.devart.com/dotconnect/universal/ License See pricing options for ordering https://www.devart.com/dotconnect/universal/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. |
|
|
NetEvolve.HealthChecks.SQLite.Devart
Contains HealthChecks for SQLite, based on the nuget package `Devart.Data.SQLite`. |
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 7.1.100 | 197 | 5/25/2026 |
| 7.1.72 | 5,039 | 4/23/2026 |
| 7.1.35 | 5,157 | 3/6/2026 |
| 7.1.33 | 454 | 2/24/2026 |
| 7.0.0 | 14,333 | 12/19/2025 |
| 6.4.290 | 12,016 | 7/30/2025 |
| 6.4.235 | 2,137 | 4/25/2025 |
| 6.4.193 | 1,343 | 2/11/2025 |
| 6.4.191 | 897 | 1/15/2025 |
| 6.4.190 | 728 | 12/27/2024 |
| 6.3.104 | 1,253 | 11/8/2024 |
| 6.3.21 | 1,738 | 6/6/2024 |
| 6.3.20 | 6,624 | 5/30/2024 |
| 6.3.10 | 83,374 | 1/18/2024 |
| 6.2.0 | 3,064 | 11/17/2023 |
| 6.1.151 | 6,180 | 6/7/2023 |
| 6.1.134 | 2,607 | 3/4/2023 |
| 6.0.0 | 6,018 | 7/1/2022 |
| 5.19.2066 | 9,907 | 1/26/2022 |
| 5.19.2042 | 1,824 | 12/21/2021 |