Adding "System.Data.SQLite" as a reference

Question

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?

Answer 1

I found that the best way to do this is to enter the following into the Package Manager Console:

Install-Package System.Data.SqLite

Answer 2

You get it (as a dll), then add a reference to it.

download here

for example install to C:\Program Files\SQLite.NET and browse to:

C:\Program Files\SQLite.NET\bin

Answer 3

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.

Answer 4

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.