How to create a password protected database?

by

According to this article and this issue, there is no way (yet?) to encrypt the database using the Microsoft.Data.Sqlite assembly (used by EF Core).

Based on this, here is what I’ve done to get it working with EF Core:

  • add the System.Data.SQLite.Core package to the project

  • while configuring your dbContext, give the optionsBuilder your own DbConnection:

    var conn = new SQLiteConnection(@"Data Source=yourSQLite.db;");
conn.Open();

var command = conn.CreateCommand();
command.CommandText = "PRAGMA key = password;";
command.ExecuteNonQuery();

optionsBuilder.UseSqlite(conn);

It is very important to use the SQLiteConnection (which can manage encrypted database) from the System.Data.SQLite.Core assembly and not the SqliteConnection from Microsoft.Data.Sqlite.

According to the article, you could probably used the built in SqliteConnection by replacing the sqlite3.dll shipped within the Microsoft.Data.Sqlite assembly by another one that handle encrypted database (you can find a free one on this repo). But I did not tested it.

Here is how to do this !

More Related Contents:

  1. auto create database in Entity Framework Core
  2. How to auto create database on first run?
  3. Unable to load DLL ‘SQLite.Interop.dll’
  4. Get SQL code from an Entity Framework Core IQueryable
  5. SQLite Database Locked exception
  6. Adding parameters in SQLite with C#
  7. SQLite Insert very slow?
  8. Cannot access a disposed object in ASP.NET Core when injecting DbContext
  9. How to instantiate a DbContext in EF Core
  10. Filter all queries (trying to achieve soft delete)
  11. The entity type ‘Microsoft.AspNet.Identity.EntityFramework.IdentityUserLogin’ requires a key to be defined
  12. Cascade deleting with EF Core
  13. EF CORE 2.1 HasConversion on all properties of type datetime
  14. Include with FromSqlRaw and stored procedure in EF Core 3.1
  15. How to make EF-Core use a Guid instead of String for its ID/Primary key
  16. Getting the Last Insert ID with SQLite.NET in C#
  17. Create/Use User-defined functions in System.Data.SQLite?
  18. SQLite keeps the database locked even after the connection is closed
  19. The LINQ expression could not be translated and will be evaluated locally
  20. Entity Framework Core: Guid Greater Than for Paging
  21. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  22. Add migration with different assembly
  23. ASP – Core Migrate EF Core SQL DB on Startup
  24. Unable to find the requested .Net Framework Data Provider – SQLite
  25. EF models. Navigation properties can only participate in a single relationship
  26. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  27. How to load navigation properties on an IdentityUser with UserManager
  28. Implementing recursive property loading in EF Core
  29. How to set Identity Seed value in code-first?
  30. How to resolve .net core build error NETDSDK1061 and warning MSB3277

Leave a Comment