CODEWITHSUNDEEP
c#sqlite
Mathlight
Mathlight

Reputation: 6653

SQLite and an C# program

I like to use an database for my program, and I ran into SQLite.

At my first look, SQLite looks great. But there's only one thing.

I don't want that users must install SQLite in order to run the program.

Now did I see that I can download the source code of it.

So my question to you guys is... Can I compile the SQLite server into my program, and then use the server like normal? And when you stop the program, the server stops also??? Is this possible?

Thanks in advance

Upvotes: 1

Views: 178

Answers (3)

Tigran
Tigran

Reputation: 62265

There is no such concept like SqLite server.

For deploying SqLite, to client machine for you it's enough to deploy C# drivers to be able to connect to that DB (you can download them from here), and DB file itself (in case when you don't create it at runtime).

In other words, there is nothing to install, there is no any service to start.

Upvotes: 2

Jeffrey Kevin Pry
Jeffrey Kevin Pry

Reputation: 3296

SQLite doesn't use a server, it's just a DLL reference and a shared file format. It is the best choice for what you are trying to do.

Check this library out: http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki , http://sqlite.phxsoftware.com/

Upvotes: 2

Raphael Gabbarelli
Raphael Gabbarelli

Reputation: 119

What you are looking for is an "Embedded Database".
SQL Server Express can be embedded, so that your users don't need to install the server. They will just need the data file.

Upvotes: -1

Related Questions