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

Question

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.

Answer 1

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.

Answer 2

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)