System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 526eeb9df3663d9e95da06ca4b0bfed428971156
Title: .netcore and password protected database
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Legacy_CryptoAPI Resolution: Works_As_Designed
Last Modified: 2018-10-22 12:10:15
Version Found In: 1.0.109.2
User Comments:
anonymous added on 2018-10-15 05:51:42:
Hi
I use some databases that I encrypted with the facilities given with System.Data.SQLite.

There is no problem if I use them in a project created with .NetFramework as a target.
If I use the same code with .net core as target I get a runtime error when creating a command.
The following code 

SQLiteConnection sqlite_conn = new SQLiteConnection("Data Source=" + path+ ";Password=" + sqlitepwd + ";");
sqlite_conn.Open();
SQLiteCommand sqlite_cmd = sqlite_conn.CreateCommand();

triggers the following exception:
System.Data.SQLite.SQLiteException: "SQL logic error
Cannot use "Password" connection string property: library was not built with encryption support, please see "https://www.sqlite.org/see" for more information"

I do not use the SSE Version of SQLite at any point.
As exactly the same code works with the same version of System.Data.SQLite with a .NetFramework Project but not when targeting .net core there seems to be a problem with System.Data.SQLite.

Regards
Bernd

mistachkin added on 2018-10-22 12:10:15:
The legacy CryptoAPI support is not available on .NET Core.