SQLite Archiver

View Ticket
Ticket Hash: 033390598360d38b9bdae1e93ea3a975954c76c8
Title: Unable to load SQLite.Interop.dll
Status: Open Type: Incident
Severity: Critical Priority:
Subsystem: Resolution:
Last Modified: 2016-05-02 19:53:46
Version Found In: 1.0.101
User Comments:
anonymous added on 2016-05-02 19:53:46:
I have a small C# WinForms app developed using Visual Studio Community 2015 
on Windows 8.1 on a 64-bit computer. My VS project properties target .Net Framework 4.5.2 and Any CPU | Prefer 32-bit.  
I used NuGet Package Manager to install Entity Framework 6.3.1 and System.Data.SQLite 1.0.101 (which installed System.Data.SQLite, System.Data.SQLite.Core, System.Data.SQLite.EF6, and System.Data.SQLite.Linq), though System.Data.SQLite.Core doesn't show in the project references.

The app runs fine in the VS debugger, but the ClickOnce published version gets the error in the title when installed and run on the same computer.  I have skeptically tried several fixes I found online [(1) installing System.Data.SQLite.Core.MSIL using NuGet; and (2) manually adding some <PropertyGroup> code to the .csproj file, which may have been removed on Build/Publish] to no avail.  

I don't see any references to SQLite.Interop.dll in Solution Explorer, but there are such dlls in both the x86 and x64 Debug folders of the project, though not in the Release folder which is empty.  All 3 of the SQLite dlls that are in references have Copy Local = true.