CODEWITHSUNDEEP
sqlite
yonan2236
yonan2236

Reputation: 13659

How to integrate Sqlite to Visual Studio?

I'm planning to use Sqlite but I don't know how to integrate it to visual studio or use it. Any help please... thanks.

Upvotes: 3

Views: 2634

Answers (3)

luke miller
luke miller

Reputation: 9

use System.Data.Sqlite

System.Data.SQLite is an ADO.NET provider for SQLite.

Upvotes: 0

snemarch
snemarch

Reputation: 5018

Depends on how you want to use it. The easiest is to get the amalgamation version - this version "contains all preprocessed C code combined into a single source file", meaning you have a single .h and .c file to add to your project. This is the officially recommended practice.

If you want to build a "proper" library or link against SQLite dynamically, you have a bit more work ahead, since there's no VS project/solution files included with SQLite. You'll have to set up your own library project, add the correct files from the sqlite-source-x.y.z.zip file, and set this project as a dependency on your main project. Doing this is actually officially discouraged.

EDIT:

Forgot to mention that the above solution is assuming C/C++, as OP didn't specify language.

Upvotes: 2

Oskar Kjellin
Oskar Kjellin

Reputation: 21900

I really recommend using System.Data.Sqlite ( http://sqlite.phxsoftware.com). Have been using it for quite some time and it works great every time! You can create tables using the designer, similar to for MSSQL etc. Recommended++

Upvotes: 2

Related Questions