Using SQLite with Visual Studio 2008 and Silverlight

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

From stackoverflow Stephen Cox

• 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

  From Dillie-O

• 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.

  From Stephen Cox

• 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

  From Dillie-O

• You should really check out the ADO.Net provider at http://sqlite.phxsoftware.com/ Top notch stuff.

  From Joel Lucsy

• 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.

  From Jonas Follesø

• Something else I didn't know.

  From Stephen Cox

• Dillie-O: The link was originally posted by Sven, and this is the other Thread you were searching ;-)

  From Michael Stum

• 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.

  jcollum : yeah, i had the same issue
  From Curt Hagenlocher

• 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.

  From Rene Schulte