SQLite 1.0.82.0 (the latter) in Visual Studio 2012 does not appear in constructor data source

Question

I am using the latest version 1.0.82.0 (sqlite-netFx40-setup-bundle-x86-2010-1.0.82.0.exe), and I am using the released version of Visual Studio 2012 with all the latest.

I do not see SQLite in the constructor data source in the source code explorer (new connections).

The SQLite download states: "This installation package is capable of installing development-time components for Visual Studio 2010." I assume that part of "Visual Studio 2010" is why I do not see the constructor in VS2012, which I have.

How can I get the designer to work with VS2012?

When will the System.Data.SQLite.org team come out with a version that works with VS 2012?

(I saw a couple of posts back in July that talked about 1.0.66 and 1.0.73, but that was then, and 1.0.82 includes designers for VS 2010 only. Apparently, other file names have "- 2008", presumably for Visual Studio 2008. This means that Visual Studio 2012 is likely to come, but also, I'm curious how to manually hack the registry or something.)

Answer 1

To get SQLite Designer support in Visual Studio, you need to download a very specific version of System.Data.SQLite. The download page has amazing 56 different features, so it’s easy to get the wrong one.

Look for a large bold text that says the following:

This installation package is capable of installing development-time components for Visual Studio 2012.

But it's still easy to miss among tyrant downloads. If you need to, use Control-F to find the text "Visual Studio 2012".

Do not download the 64-bit version, even if you are on a 64-bit machine . For designer support, you will need a 32-bit version with the text above.

Answer 2

NEW EDIT NOW I PROVIDED WORK!

Goto Visual Studio, Managing Nuget, searching for online packages, searching for "SQLite", installing System.Data.SQLite and boom, you can use the constructor, and evrything works again.

Answer 3

After some searching, I found my answer 1.0.83, which will be released in November XX, 2012.

Visual Studio 2012, in addition to the difference in the registry bus v10-v11, also has what the team calls "redesigned designer support."

Here is a link to the information.

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

1.0.83.0 - November XX, 2012 (scheduled release) • Updated to SQLite 3.7.15. • Add Visual Studio 2012 support for all applicable solution / project files, their associated supporting files, and test suite. • Add Visual Studio 2012 support to the updated constructor support constructor.

and other changes.

I could not find a workaround on the Internet, unfortunately. The lack of a fix affects report-based projects with DevExpress and projects using Explorer.