Devart.Data.SQLite.EF6 6.4.235

Prefix Reserved
dotnet add package Devart.Data.SQLite.EF6 --version 6.4.235
                    
NuGet\Install-Package Devart.Data.SQLite.EF6 -Version 6.4.235
                    
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.EF6" Version="6.4.235" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Devart.Data.SQLite.EF6" Version="6.4.235" />
                    
Directory.Packages.props
<PackageReference Include="Devart.Data.SQLite.EF6" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Devart.Data.SQLite.EF6 --version 6.4.235
                    
#r "nuget: Devart.Data.SQLite.EF6, 6.4.235"
                    
#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.
#addin nuget:?package=Devart.Data.SQLite.EF6&version=6.4.235
                    
Install as a Cake Addin
#tool nuget:?package=Devart.Data.SQLite.EF6&version=6.4.235
                    
Install as a Cake Tool

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+. The product is compatible with ADO.NET Entity Framework (EF) Core.

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.

It also includes visual ORM designer for Entity Framework, Entity Framework Core, and LinqConnect ORM models.

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
Entity Framework Core 8
.NET 9, 8

More information here

Installation


For projects, using Entity Framework Core 8 with SQLite, install this package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.SQLite.EFCore

For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.SQLite.EF6 package.

There also are Visual Studio extensions for earlier Visual Studio versions. If you use some other tool than Visual Studio, you can get NuGet packages with the nuget.exe console tool.

License

dotConnect for SQLite is available in several editions. See pricing options for ordering.

The NuGet package initiates a 30-day free trial automatically, so no additional action is required.

Usage


This snippet directly configures a SQLite database connection for an Entity Framework Core DbContext using a connection string.

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     optionsBuilder.UseSQLite(@"DataSource=database.db;FailIfMissing=False;");
  } 
}

Configuration Using SQLiteConnection Instance

using Devart.Data.SQLite;
...

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     var connection = new SQLiteConnection();
     connection.DataSource = @"database.db";
     connection.FailIfMissing = false;
     connection.Locking = LockingMode.Exclusive;
     connection.AutoVacuum = AutoVacuumMode.Full;
     connection.ConnectionTimeout = 20;
     optionsBuilder.UseSQLite(connection);
  } 
}
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.  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 netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.1 is compatible. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen60 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

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
6.4.235 159 4/25/2025
6.4.193 145 2/11/2025
6.4.191 110 1/15/2025
6.4.190 124 12/27/2024
6.3.104 155 11/8/2024
6.3.21 230 6/6/2024
6.3.20 120 5/30/2024
6.3.10 23,846 1/18/2024
6.2.0 1,516 11/17/2023
6.1.151 4,086 6/7/2023
6.1.134 340 3/4/2023
6.0.0 671 7/1/2022
5.19.2066 3,724 1/26/2022
5.19.2042 357 12/21/2021
5.18.2014 382 11/9/2021
5.18.2001 451 10/21/2021
5.18.1985 401 9/28/2021
5.17.1944 476 7/30/2021
5.17.1930 444 7/8/2021
5.17.1905 441 6/3/2021
5.17.1866 448 4/9/2021
5.17.1860 416 4/1/2021
5.17.1836 472 2/18/2021
5.17.1812 453 1/14/2021
5.17.1792 498 12/17/2020
5.17.1782 525 12/3/2020
5.16.1759 483 10/29/2020
5.16.1739 518 10/1/2020
5.16.1730 495 9/17/2020
5.15.1696 576 7/30/2020
5.15.1686 573 7/16/2020
5.15.1666 551 6/17/2020
5.15.1612 612 4/2/2020
5.15.1583 601 2/20/2020
5.15.1541 649 12/23/2019
5.14.1519 1,046 11/21/2019
5.14.1504 650 10/31/2019
5.14.1499 676 10/24/2019
5.13.1470-preview 511 9/13/2019