Devart.Data.SQLite.EFCore 6.4.235.8

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.

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.

Related Packages

• Devart.Data.SQLite
• Devart.Data.SQLite.EF6

Support Area

• Support
• Documentation
• Request form
• Feedback page
• Product history

More Resources

• Blog about dotConnect
• Devart Website