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

.net, sqlite

Solution

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.

Problem

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.

Original source