I have a VS2015 (class library) project into which I have added an Entity Framework Data Model (EDMX) using the menu option on your "SQL Server Compact/SQLite Toolbox" (22.214.171.124) window against a SQL Compact 3.5 database I have connected. The
model generated fine and compiles without problem.
When I try to update the model from within the diagram, I get an error...
An exception of type 'System.ArgumentException' occurred while attempting to update from the database. The exception message is: 'Unable to convert runtime connection string to its design time equivalent. The libraries required to enable Visual
Studio to communicate with the database for design purposes (DDEX provider) are not installed for provider 'System.Data.SqlServerCe.3.5'. Connection string: Data Source=D:\folder\folder\folder\database.sdf'.
I have tried installing the DDEX providers using the button you provide at the bottom of the "About" box ("Register DDEX Providers") but when I then restart Visual Studio that same "About" box shows...
- SQL Server Compact 3.5 in GAC - Yes 3.5.8080.0
- SQL Server Compact 3.5 DbProvider - Yes
- SQL Server Compact 3.5 DDEX provider - No
- SQL Server Compact 3.5 Simple DDEX provider - No
- SQL Server Compact 3.5 Engine test - PASS!
It would appear therefore that the providers are no longer being recognised. The only way that I can update diagrams is to delete them and then recreate them from your toolbox which is extremely inconvenient (no more than a week or two ago I was able to edit
diagrams without problem - the only thing that I can think of that could be a problem is that the November Windows 10 update was installed and/or there may have been updates to the .NET Framework via Windows Update).
I am using the 'nuget' packages EntityFramework 6.1.3 and EntityFramework.SqlServerCompact.Legacy 6.1.3, targeting .NET 4.5 and developing on Windows 10 Professional (November 2015 update installed). My Visual Studio (Enterprise) version is 14.0.23107.0 D14REL
(Update 1 RC NOT installed).
Can you help?