System.Data.SQLite

Login
Ticket Hash: 9c330a3e036d0760c1a437d5b7c318a0df9beab7
Title: Password-protected databases no longer work with 1.113, no rollback possible
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Native_Assembly Resolution: Works_As_Designed
Last Modified: 2020-06-03 15:34:42
Version Found In: 1.0.113.1
User Comments:
anonymous added on 2020-06-02 19:18:38:

Did a Nuget update of my project to 1.0.0113.1, not realizing that encryption support has apparently been dropped (making calls to connectionstring.changepassword fail, as do all calls involving a password-protected database). Bad as this is, there is also no roll-back to prior versions available on Nuget.org. I'll have to revert my project under source control. Is support for ChangePassword coming back?


mistachkin added on 2020-06-03 15:34:42:
Since your application uses the legacy CryptoAPI codec, it should continue
to use the 1.0.112.2 NuGet packages.

These packages can be obtained using the "NuGet Package Restore" feature.
The exact steps needed to do this using the command line NuGet client are:

1. Manually edit your C# project file(s), e.g. "YourApp.csproj",
   replacing all instances of System.Data.SQLite "1.0.113.*" version
   numbers with "1.0.112.2". 

2. Manually edit your NuGet "packages.config" file(s), replacing all
   instances of System.Data.SQLite "1.0.113.*" version numbers with
   "1.0.112.2". 

3. From a Command Prompt Window, execute the following NuGet client
   command:

   NuGet.exe restore "YourApp.sln"