Why Is The Sqlite Provider Missing From The Server Explorer Add Connection Dialogue?

I am following the article Using SQLite Embedded Database with Entity Framework and Linq-to-SQL, and have tried installing the SQLite provider, first using the System.Data.SQLite

Solution 1:

Ensure the data tools for visual studio were installed correctly as per:

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

There are various fixes listed, making sure there weren't older tools installed first, etc. I'm going to give it a try, but the article may help you out.