I had a request from a student to show how to connect to a SQLLite db from C#. It turns out it is pretty straight forward. You just need a few tools. I will list what I find here:

.NET ADO SQLLite components: http://sourceforge.net/projects/sqlite-dotnet2/
Great tutorial: http://adodotnetsqlite.sourceforge.net/
SQLLite Browser: http://sourceforge.net/projects/sqlitebrowser/