Devart.Data.SQLite 6.4.190

Prefix Reserved
.NET Standard 1.3 This package targets .NET Standard 1.3. The package is compatible with this framework or higher. 
dotnet add package Devart.Data.SQLite --version 6.4.190                

                    
                

            
NuGet\Install-Package Devart.Data.SQLite -Version 6.4.190
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Devart.Data.SQLite" Version="6.4.190" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Devart.Data.SQLite --version 6.4.190                

                    
                

            
#r "nuget: Devart.Data.SQLite, 6.4.190"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install Devart.Data.SQLite as a Cake Addin
#addin nuget:?package=Devart.Data.SQLite&version=6.4.190

// Install Devart.Data.SQLite as a Cake Tool
#tool nuget:?package=Devart.Data.SQLite&version=6.4.190

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 1.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 9, 8, 7, 6, 5
.NET Core 3, 2, 1
.NET Framework 4.8, 4.7, 4.6

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 1, 3, 5, 6, 7, 8, 9 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.

To activate your license, please download dotConnect for SQLite from our website. This installer generates the trial key files required for using this package on a trial basis.

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.

Support Area

More Resources

Product 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. 
.NET Core netcoreapp1.0 was computed.  netcoreapp1.1 was computed.  netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard1.3 is compatible.  netstandard1.4 was computed.  netstandard1.5 was computed.  netstandard1.6 was computed.  netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net46 was computed.  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 tizen30 was computed.  tizen40 was computed.  tizen60 was computed. 
Universal Windows Platform uap was computed.  uap10.0 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (4)

Showing the top 4 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 1.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 To activate your license, please download dotConnect for SQLite from our website https://www.devart.com/dotconnect/sqlite/download.html This installer generates the trial key files required for using this package on a trial basis. 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. Besides, this installer generates the trial key files required for using this package on a trial basis. You can download it at www.devart.com.
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 1.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 To activate your license, please download dotConnect for SQLite from our website https://www.devart.com/dotconnect/sqlite/download.html This installer generates the trial key files required for using this package on a trial basis. 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. Besides, this installer generates the trial key files required for using this package on a trial basis. You can download it at www.devart.com.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
6.4.190 301 12/27/2024
6.3.104 704 11/8/2024
6.3.21 1,062 6/6/2024
6.3.20 2,216 5/30/2024
6.3.10 52,024 1/18/2024
6.2.0 2,650 11/17/2023
6.1.151 5,855 6/7/2023
6.1.134 2,223 3/4/2023
6.0.0 5,622 7/1/2022
5.19.2066 9,014 1/26/2022
5.19.2042 1,567 12/21/2021
5.18.2014 2,113 11/9/2021
5.18.2001 1,747 10/21/2021
5.18.1985 1,778 9/28/2021
5.17.1944 2,207 7/30/2021
5.17.1930 2,013 7/8/2021
5.17.1905 1,921 6/3/2021
5.17.1866 3,096 4/9/2021
5.17.1860 1,779 4/1/2021
5.17.1836 2,780 2/18/2021
5.17.1812 1,992 1/14/2021
5.17.1792 2,121 12/17/2020
5.17.1782 1,907 12/3/2020
5.16.1759 2,229 10/29/2020
5.16.1739 2,032 10/1/2020
5.16.1730 2,033 9/17/2020
5.15.1696 2,122 7/30/2020
5.15.1686 1,853 7/16/2020
5.15.1666 2,092 6/17/2020
5.15.1612 4,301 4/2/2020
5.15.1583 4,673 2/20/2020
5.15.1541 5,492 12/23/2019
5.14.1519 5,171 11/21/2019
5.14.1504 3,429 10/31/2019
5.14.1499 2,553 10/24/2019
5.13.1470 4,433 9/13/2019
5.12.1437 3,672 7/25/2019
5.12.1422 2,565 7/4/2019
5.12.1402 2,676 6/6/2019
5.12.1366 2,142 4/12/2019
5.11.1357 2,756 3/28/2019
5.11.1328 2,191 2/14/2019
5.11.1307 2,162 1/10/2019
5.11.1278 2,247 11/29/2018
5.11.1253 2,161 10/25/2018
5.11.1229 4,433 9/20/2018
5.11.1216 2,172 8/31/2018
5.11.1202 2,223 8/10/2018
5.11.1190 2,186 7/19/2018
5.11.1172 2,359 6/22/2018
5.10.1152 2,204 5/25/2018
5.10.1134 2,512 4/27/2018
5.10.1115 2,641 3/30/2018
5.10.1086 2,737 2/15/2018
5.10.1061 2,293 1/11/2018
5.10.1031 2,187 11/23/2017
5.10.1013 2,206 10/30/2017
5.9.980 2,772 9/7/2017
5.9.958 2,685 8/4/2017
5.9.946 2,322 7/14/2017
5.9.931 2,317 6/23/2017
5.9.912 2,615 5/25/2017

https://www.devart.com/dotconnect/sqlite/revision_history.html