Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 914
Stephen Cox Avatar asked Aug 06 '08 16:08

Stephen Cox


3 Answers

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.

like image 196
Curt Hagenlocher Avatar answered Oct 13 '22 00:10

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.

like image 28
Rene Schulte Avatar answered Oct 12 '22 22:10

Rene Schulte


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/

like image 30
Dillie-O Avatar answered Oct 12 '22 22:10

Dillie-O