vs2012,vs2013 Enable SQLite's data Provider interface display

VS 2012 Defaults to SQLite's data Provider, so it is not possible to manage SQLite's database directly in VS 2012, and it is not natural to generate the model class of the Entity Framework directly in VS like SQL Server. In order to solve this problem, the SQLite team packaged the data provider for VS2012 in SQLite's installation package. But the Lord has failed countless times to find the correct way to integrate SQLite into VS, recorded as follows, to share to the needs of children's shoes.

1, first download the SQLite installation package from Http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki. This page installs the package very much, all of a sudden will see dazzling. It is important to note that only 32-bit packages will be able to add SQLite data provider to the VS designer. If you have seen the dazzling, a simple way is to search the right side of the description has the following bold statement is shown in the "the" is the "the only" the "capable of installing" the Design-time Compone NTS for Visual Studio 2012 installation package, download the installation directly on the line. The name of this download is sqlite-netfx45-setup-bundle-x86-2012-1.0.93.0.exe.

2, the installation must not use full installation, to choose Custom Installation, and then select only the core Component (including 2 of it) and visual Studio Designer Component.

3, click Next to Hook in front of the install Designer for Visual Studio 2012

4, after the installation, restart vs 2012 should be able to see the SQLite Data provider options.

2014.8.10 Update, the steps to enable SQLite Data provider in Visual Studio 2013 are the same as when you download the installation package to select the This is the only setup packages that is capable O F Installing the Design-time components for Visual Studio 2013 on the left side of the installation package.

Reprint http://www.cnblogs.com/ggbbeyou/p/4319756.html

vs2012,vs2013 Enable SQLite's data Provider interface display