Using SQLite with Visual Studio 2008 and Silverlight

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"
Asked by: Guest \| Views: 377

Total answers/comments: 3

Comments display order:

Guest [Entry]

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.

Guest [Entry]

"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://web.archive.org/web/20100208133236/http://www.mikeduncan.com/sqlite-on-dotnet-in-3-mins/"

Guest [Entry]

"You should give Siaqodb a try. I haven't tested it but they mention that is works with Silverlight OOB apps and even give you a tutorial here.
It's commercial software, but a 30 day trial is available."