SQLite with Visual Studio 2012 and .NET 4.5? SQLite with Visual Studio 2012 and .NET 4.5? sqlite sqlite

SQLite with Visual Studio 2012 and .NET 4.5?


There is now an official installer out on this page here:

http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

It will install the design-time components into VS2012, as well as the official System.Data.Sqlite binaries.

There are many downloads on that page, the one you need is about half way down and you can get there by searching for this:

sqlite-netFx45-setup-bundle-x86-2012-1.0.84.0.exe

here is a direct link: http://system.data.sqlite.org/downloads/1.0.84.0/sqlite-netFx45-setup-bundle-x86-2012-1.0.84.0.exe

PS: It is important to note that the design time components are not supported for VS Express due to licensing restrictions. (thanks Konrad)


I found another way to use sqlite with VS 2012, use dotConnect for SQLite, the standard free edition will work. http://www.devart.com/dotconnect/sqlite/download.html


For what it's worth, I have a patched designer installer executable that can install the wizard in VS2012 RC. You can download it here. You need to already have SQLLite installed, it needs to be version 1.0.66 (a slightly older version of the library), and it should go into the same directory that the original designer installer is at.

Assuming you used the default installation path, the executable should go into C:\Program Files\SQLite.NET\bin\Designer (for x86) or C:\Program Files (x86)\SQLite.NET\bin\Designer (for x64).

If the edition is checked in the listbox it has already (automatically) installed it in that version. If I had other visual studio versions on that machine, it would show them as well (2008 and later). The install is just a few registry entries and updating the machine.config file.