DDEX provider manual registration through privateregistry.bin is not showing up in Server Explorer Connections node windows 6.1 Visual Studio 2017 version 15.1 Office Developer Tools Hosathota S Vishwanatha reported May 09, 2017 at 02:45 PM.
May 10, 2017 - DDEX provider manual registration through privateregistry.bin is not. The privateregistry.bin file when Visual Studio is first installed or if for any. The System.Data.SQLite DDEX provider does not support Visual Studio 2017. This post describes how to work with SQLite and Entity Framework 6 in Visual Studio 2017, using the 'SQLite Toolbox' DDEX provider for EF6.
The System.Data.SQLite DDEX provider does not support Visual Studio 2017. This post describes how to work with SQLite and Entity Framework 6 in Visual Studio 2017, using the 'SQLite Toolbox' DDEX provider for EF6. Notice that this provider only supports the EF 6 Tools, and not other Data Source scenarios, for example Typed DataSets. This requires Visual Studio 2017 15.8 (or 15.6 and earlier)
Once per Visual Studio edition (daily build at https://github.com/ErikEJ/SqlCeToolbox/wiki/Release-notes )
Once per machine. Download sqlite-netFx46-setup-bundle-x86-2015-1.0.108.0.exe (from https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki)
Select 'Full Installation'
Select: Install the assemblies into the global assembly cache - Install VS designer components
Restart Visual Studio
Verify that the EF6 provider is installed in GAC from the Toolbox 'About' dialog:
If the EF6 provider is not in GAC, this may be due to an invalid entry in machine.config, located in the C:WINDOWSMicrosoft.NETFrameworkv4.0.30319Config folder. The only SQLite related entry should look like this, with this exact version number:
If you are using Visual Studio 15.7, that includes the updated EF 6.2 Tools, generating an EDMX is broken. You can add the following entry (as the last netry in the list) to the DbProviderfactories section in your machine.config as a workaround until this issue has been fixed (remember to restart Visual Studio after making the change):
Some users report that adding this to app.config solves some runtime issues (related the the VS 15.7 issues mentioned above)
Install using Package Manager Console or NuGet Manager in each project.
Make sure to install the same version as the tools package above.
Build project!
Packages.config should look like this after install:
App.config should look like this:
Add, New Item, Data, ADO.NET Entity Data Model. Choose 'EF Designer from Database' or 'Code First from Database'
Use 'SQLite Provider (Simple for EF6 by ErikEJ)' when creating a connection to your SQLite database file. Enter the full path to your database file in Data Source.
A reader of this wiki post has provided some additional tips here