Unable to load DLL 'SQLite.Interop.dll' on Visual Studio 2017 for UWP project

2
votes

I get this error when using SQLite.

DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

I tried several solution without success.

Tried using x86/x64

Tried this: Visual Studio 2017 Xamarin UWP break, unable to load "sqlite3"

Added 2015 Visual C++ runtime dependency for UWP.

Tried manually adding the .dll and set it to "copy always".

Tried installing locally depedencies from here

I'm really out of ideas.

1
sqliteuwpvisual-studio-2017xaf
Could you share detail about the nuget package you have used? - Nico Zhu - MSFT
Ended up using this docs.microsoft.com/en-us/windows/uwp/data-access/… guide (and came up with other issues but finally worked). I was trying to use System.Data.SQLite without success. - Vallo
Yep, System.Data.SQLitedoes not support for uwp. - Nico Zhu - MSFT

1 Answers

0
votes

I had this problem running in release but not in debug. I am using VS2017 15.9.5 Using Release manager I changed all the projects to use Release x64 Strangely the Platform tab asked me to make a new Platform and I had to do this in order to be able to pick an x64 platform change platform

I wound up installing the SQLite modules in all the projects, not just the data tier. it would not work with just the data tier, even though I had Copy local true.

Here are the nuget packages I used

nuget packages