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

Question

The question says it all, really. My application is a time tracker. It is currently written as a spreadsheet, but there is too much data, and I would like to put a little more structure on it.

SQLite seems in a neat way.
I would be open to other suggestions.

Answer 1

Some providers are available:

http://sqlite.phxsoftware.com/

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

And you can get up and run in just three minutes in accordance with this section:

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

5 2009 .. , ( ) , .

Answer 2

( 2011) System.Data.SQLite 1.0.70.0 (3.7.6)

. SQLite.Interop.dll GAC.

GAC , .

, . .

Answer 3

If you are working on an open source application and want the lightweight interaction level to be used for SQLite, the SQLite code in the Media Portal might be of interest (see SQLiteClient.cs)