Use SQLite.Core to connect to database with Password

Question

I would like to connet to an SQLite database protecte by password into a project in .Net Core 2.1

For that, i import: Microsoft.EntityFrameworkCore.Sqlite.Core(2.2.2) System.Data.Sqlite.Core(1.0.109.2)

And i want to connect to my database:

using (var connexion = new SQLiteConnection($"Data Source={_Path};Password={_Password};"))
{
    connexion.Open();
}

But i have the issue:

'SQL logic error Cannot use "Password" connection string property: library was not built with encryption support.

I don't know how to set password differently?

recnac · Accepted Answer · 2019-05-05 13:28:52Z

2

What I remember from my previous experience, The EFCore didn't support encryption out of box and we need to use external libraries.

To use password with SQLite you can read information from here

recnac

3,7746 gold badges27 silver badges48 bronze badges

answered Mar 1, 2019 at 6:32

mukesh joshi

6046 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Worked for me! Just go to the GitHub repo, scroll down to the instructions and follow those 6 steps. A was pleasantly surprised with how easy it was.