when I was building my project done in ASP.NET and C#, it produced the following error:
The type or namespace name 'SQLite' does not exist in the namespace 'System.Data' (are you missing an assembly reference?"
So, when I tried to add it as a reference, I was not able to find "System.Data.SQLite" in my library.
How do I overcome this problem?
You get it (as a dll), then add a reference to it.
for example install to C:\Program Files\SQLite.NET and browse to:
C:\Program Files\SQLite.NET\bin
I found that the best way to do this is to enter the following into the Package Manager Console:
Install-Package System.Data.SqLite
Try to search for System.Data.SQLite.DLL file (using windows explorer search) or if you have not yet installed it just download it from the net.
For more information try to read this.
For those folks that downloaded SQLite but can't get the DLL to show up in VS2010:
I've downloaded the latest SQLite build for my environment, but I still couldn't get the DLL to show up under References> Add Reference> .Net tab.
To fix this, I went into the Add Reference Window and selected the Browse Tab and just browsed to the DLL file in the install directory\bin folder. Now it shows up fine.
You need to download System.Data.SQLite, then you can add it to your project.
