Sqlite not in list of Visual Studio data source options
sqlite, visual-studio-2010
Solution
This is an old question but for someone, like me, who finds this before there is a newer answer:
missing SQLite data provider in VS 2013
Basically for the latest versions of SQLite you can download an installer that includes the components
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
Choose the right setup for you, for me was: Setups for 32-bit Windows (.NET Framework 4.5.1) sqlite-netFx451-setup-bundle-x86-2013-1.0.94.0.exe
Problem
Downloaded and ran SQLite setup. Added dll reference to my project In Server Explorer, added new connection, clicked 'Change' for data source and SQLite was one of the options. Connected and used my tables. Then...VS 2010 crashed. When I reloaded my project, my connection wasn't in Server explorer, so tried to add it again. SQLite was not in the list of options. Re-ran SQLite setup, deleted/re-added reference, restarted project...still no SQLite in the list. How can I get SQLite connected in Server Explorer???