Unable to load dll sqlite interop dll WPF

advertisements

I am doing one WPF application and trying deploy/publish it. As long as i run the application within Visual Studio, everything is fine. But when i am trying separate the deploy files[From Release folder] to antoher location and trying to run, am getting error.

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

I copied App.exe + App.exe.config + System.Data.SQLite.dll files from Release folder.

Additinal Info:

I have installed SQLite Nuget package.

Tried by unchecking prefer 32-Bit and setting Platform to Any CPU in solution properties.

I am new to the WPF, can anybody please correct me if my deploy process or anything else is wrong?

Update:

I also tried by copying all DLL's realted to SQLite to the new location along with solution exe file, but same error is popping up.

List of file, i put together are:

 App.exe
 App.exe.config
 System.Data.SQLite.dll
 System.Data.SQLite.EF6.dll
 System.Data.SQLite.Linq.dll


In Solution Explorer click with right button on the name project and choose ADD -> Existing Item. Then change your search to All Files (*.*) and open the Sqlite.Interop.dll. You can find it in bin\debug\x86 (or x64) Now you have the dll in you project (if you right click on it, you can see "Build action = content"). Change it in "Build Action = Embedded Resource".

Re-publish and that's all.