Could not load file or assembly ‘System.Data.SQLite.dll’ or one of its dependencies.
Posted on: October 31, 2013
- In: Deployment | Technical
- 14 Comments
Last couple of months, I was in rush and could not contribute to the community as much as I have been expected, but regularly I have been answering the questions and giving solutions of different technical problems that I have got through e-mail from different know-how guys. Solving and replying those critical problems engage me 2-3 hours a day and at the same time I have to spend 8-9 hours a day in my office, so it is really tough to allocate time for writing about something new. But, then again, it is all about our part of life; I would come up writing with new and cutting edge technologies very soon again.
Today I would like to give a solution of a weird problem that I had confronted for deploying SQLite.
”Could not load file or assembly ‘System.Data.SQLite.dll’ or one of its dependencies.”
For solving this issue I had tried a whole variety of ways but had not got my problem solved. What I had done to solve this issue was that I installed the version sqlite-netFx40-setup-bundle-x86-2010-1.0.89.0 and then copy the System.Data.SQLite.dll to my project folder and refer this dll to my project. It solved the problem in my development PC but when I had gone for deployment I had got another error which is like that,
“Unable to load DLL ‘SQLite.Interop.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)”
It shows that the native interop assembly is required either for x86 or x64 architecture. As ‘System.Data.SQLite.dll’ is a mixed mode assembly, I suspected it would automatically loads its native code. But I had got no luck really!! The reason behind this is might be that a particular mixed mode assembly is either for x86 or x64 not for both. Anyway I really don’t know what was the exact reason inside for this issue. After trying in many different ways I had come across the solution finally. Here it is.
First we need to install SQLite and in my case I installed it from NuGet gallery.To do that you can follow the steps that have been given below:
Go to the TOOLS->Library Package Manager->Package Manager Console of the Visual studio.
Then run the command Install-Package System.Data.SQLite
Now in your project you have got two folders x86 and x64, underneath this folder you will find those ‘SQLite.Interop.dll’.
Now go to the properties windows of those dlls and set build action is content and Copy to output directory is Copy always.
Like the way you also need to change the property settings for ‘System.Data.SQLite.dll’.
That’s it. Now build your app. You are ready to deploy and see it is working perfectly in your client machine too.
14 Responses to "Could not load file or assembly ‘System.Data.SQLite.dll’ or one of its dependencies."
June 20, 2014 at 10:18 am
thank you, you really a life saver.
I was at the point to remove SQLite from my design.
January 3, 2015 at 7:02 pm
did you try installing Microsoft Visual C++ 20xx Redistributable? That worked for me, see: http://stackoverflow.com/a/17195350/990618
March 28, 2015 at 1:22 pm
hi, I am getting same error for “Unable to load DLL ‘SQLite.Interop.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)” and tried your solution but after installing from nuget i am not getting these two folder as shown in your image(https://rashimuddin.files.wordpress.com/2013/10/projectstruture.png).
April 23, 2015 at 8:38 am
Hi , I followed your instructions and Sqlite has been installed successfully but there are no x64 nor x86 folder appeared in solution explorer. Any help with this? thank you
9 | Private Info
August 27, 2015 at 6:00 pm
In VS 2012 there are no settings for BuildAction of Copy to Output Directory. they do not exist.
October 30, 2015 at 3:08 pm
Like some of the other commenters have said… I too am not getting the x86 and x64 folders to show up after installing the package. Any advice?
November 24, 2015 at 3:57 pm
Hi Rashim,
I get the issue on VS 2010
I cannot install SqlLite package because nuget works on VS 2013 minimum.
Do you guess what can happen ?
Thank you for answer me.
May 15, 2018 at 10:34 am
Following the procedures, again and again same problem coming.
Error #1: Unable to load DLL ‘SQLite.Interop.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Question: What is causing this problem? And how to fix this issue please let me know the details.
We are trying to use SQLite database in C# Application, to develop a C# application I am using Visual Studio 2015, System.Data.SQLite Version 1.0.108.
After building the project I am facing the following issue.
Rashim's Memoir 
November 6, 2013 at 1:23 pm
Windows Store App. – getting an error: ” Could not install package ‘System.Data.SQLite 1.0.89.0’. You are trying to install this package into a project that targets ‘.NETCore,Version=v4.5.1’, but the package does not contain any assembly references or content files that are compatible with that framework. For more information, contact the package author.”
Any idea?