CODEWITHSUNDEEP
.netsqlite
AJ.
AJ.

Reputation: 13761

What is the best / easiest way to talk to SQLite from .NET?

Question says it all, really. My application is a time tracker. It's currently written as a spreadsheet, but there's just too much data and I would like to impose a bit more structure on it.

SQLite seems like a neat way to go.
I would be open to other suggestions, too.

Upvotes: 3

Views: 518

Answers (3)

bernd_k
bernd_k

Reputation: 11966

The current (april 2011) links seem to be here System.Data.SQLite 1.0.70.0 (3.7.6)

But there seems to be some problem with the installer. The doen't install SQLite.Interop.dll properly to GAC.

I did not install it in GAC and load it with absolut path and that works fine for me.

Just noted, that the ticket is open again. Check there for new work arounds and solutions.

Upvotes: 1

Kev
Kev

Reputation: 119806

There are some providers available:

http://sqlite.phxsoftware.com/

http://sourceforge.net/projects/sqlite-dotnet2

And you can get up and running in just three minutes according to this chap:

http://www.mikeduncan.com/sqlite-on-dotnet-in-3-mins/

Updated Jan 5 2009: We actually have this rolled out to our shared (partial trust) hosting environment and it works really well according to early customer feedback.

Upvotes: 7

Oliver Hallam
Oliver Hallam

Reputation: 4262

If you are working on an open source application and want a lightweight interop layer to SQLite, then the SQLite code in Media Portal may be of interest (see SQLiteClient.cs)

Upvotes: 0

Related Questions