Use SQLite.Core to connect to database with Password

.net core entity-framework-core sqlite

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?

1
0
3/1/2019 6:33:56 AM

Accepted Answer

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

0
5/5/2019 1:28:52 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow