Any one know decent way to reference a SQLite database using the above mentioned tools? I tried using ODBC (the SQLite driver) but while the connection is good, I get no data returned. Like I can't see any tables in Data Connection (VS 2008). Is there a better way?
Edit: corrected typos
Have you tried the ADO driver for SQLite?
There is a great quick start guide (thanks to another thread here) that you can get here: http://www.mikeduncan.com/sqlite-on-dotnet-in-3-mins
What other thread? I did a search on "SQLite" and only came up with 3 threads (before posing this question). I ask cause maybe the search was incorrect?
Oh and thanks bunch for the link.
I was sure I got that link from here just yesterday since I e-mailed myself the link right away from work. Maybe I got it from a recent blog entry or something...Either way, the link is great. Glad I could be of help. 8^D
You should really check out the ADO.Net provider at http://sqlite.phxsoftware.com/ Top notch stuff.
Why is Silverlight included in the question title? SQLLite is not yet ported to Silverlight 2, and what you do on the server side doesn't really matter for the Silverlight client application.
Dillie-O: The link was originally posted by Sven, and this is the other Thread you were searching ;-)
Joel Lucsy: That implementation of SQLite is a mixed-mode assembly which is not supported by Silverlight. Only a pure managed implementation would work under the Silverlight CLR.
The MIT licensed C#-SQLite might be the right solution. It's a complete managed port of SQLite, so it can be used with Silverlight.