Why is SQLite provider missing from the Connect Explorer to Server dialog box?

Question

I follow the article Using SQLite Embedded Database with Entity Framework and Linq-to-SQL and tried to install the SQLite provider, first using the System.Data.SQLite NuGet package, and then installing the provider through Settings for 32-bit Windows (.NET / Framework 4.0 ) installation package (for version 1.0.79). After installing and rebooting the system, I still do not see the SQLite Database File provider in the Add Connection dialog box from the Server Browser.

I can continue manually by creating a connection string and using external tools to create my SQLite database file, but I still would like to know what is wrong, because I do not have advertised support for SQLite development time, despite the provider. What could be wrong here?

Answer 1

Verify that the data tools for visual studio are installed correctly:

http://www.basarat.com/2010/05/sqlite-for-visual-studio-2010.html

There are various fixes to ensure that old tools have not been installed before, etc. I will try to try, but the article may help you.