Visual Studio C# – SQLite.Interop.dll not found

by

I also encountered the similar issue in my environment of Visual Studio 2017 and NET Framework 4.5, the circumstance is:

I am developing an Outlook Add Ins using ClickOnce to publish it and SQLite as the database. After having installed the SQLite library into the project from NuGet, it works perfectly in the local environment but pops up the exception error message “Unable to load DLL ‘SQLite.Interop.dll'” on the client machine.

I compared the two environments and found the DLL file ‘SQLite.Interop.dll’ had not been published to the client machine that we can see in the following graphic.
enter image description here

I searched ‘SQLite.Interop.dll’ in local environment and found it is saved in the following folder “{project}\packages\System.Data.SQLite.Core.1.0.105.2\build\” for the specific .Net FrameWork
enter image description here

So, my solution is adding these two DLL libraries into the project, then they can be published to the client machine using the ClickOnce.
enter image description here

(Notice: The selected DLL version should be as same as the NET Framework version in your environment.)

More Related Contents:

  1. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  2. How to use C# 7 with Visual Studio 2015?
  3. System.MissingMethodException: Method not found?
  4. How can I specify a [DllImport] path at runtime?
  5. Loading DLLs at runtime in C#
  6. Unable to load DLL (Module could not be found HRESULT: 0x8007007E)
  7. Password Protect a SQLite DB. Is it possible?
  8. Equivalent to ‘app.config’ for a library (DLL)
  9. Embedding assemblies inside another assembly
  10. A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?
  11. Create SQLite Database and table
  12. How do I use the C#6 “Using static” feature?
  13. How do I get around the “‘” problem in sqlite and c#?
  14. How to call C++ DLL in C#
  15. How to load Assembly at runtime and create class instance?
  16. How to unapply a migration in ASP.NET Core with EF Core
  17. Creating simple c++.net wrapper. Step-by-step
  18. SQLite .NET performance, how to speed up things?
  19. What is the best way to connect and use a sqlite database from C#
  20. ASP.NET 5 add WCF service reference
  21. Load a .DLL file and access methods from class within?
  22. How to auto create database on first run?
  23. Visual Studio 2010 Compiling with the Debug or Release version of third party library depending on if my project is being compiled Build or Release?
  24. Compile C#.net dll for VB6
  25. Using DLLs in VBScript
  26. How to check if a file is signed in C#? [closed]
  27. Encrypt SQLite database in C#
  28. How to create a password protected database?
  29. Combine 32- and 64bit DLLs in one program
  30. Visual Studio 2015 break on unhandled exceptions not working

Leave a Comment