Sqlite Database File Type Missing From Visual Studio 2010 Data Source Options

I installed a x86/x64 official SQLite NuGet package on Visual Studio 2010 by following these instructions: http://www.tsjensen.com/blog/post/2012/11/10/SQLite-on-Visual-Studio-with

Solution 1:

I add the answer here myself since I just found it out:

After installing the NuGet package, I downloaded the setup package "Setups for 32-bit Windows (.NET Framework 4.0)" from here: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki. It was saying that "This is the only setup package that is capable of installing the design-time components for Visual Studio 2010."

Then in the installer it was important to put a check on "Install the designer components for Visual Studio 2010"

After that opening Visual Studio again and I got SQLite Database File under the data source options.