EF Model update from SQL Server CE database RRS feed

  • Question

  • I've got an app that uses EF for crud and I recently  added three tables to the database.  I wanted to be able to select data in these tables so I went to the existing EDMX screen and rightclicked on white space in the diagram and selected "Update Model from Database"  and got an error dialog saying:

    System.ArgumentException '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.4.0'.  Connection string: Data Source=C:\Database\database\MachineLearning.sdf'.

    I'm using VS2019 since this original edmx created.  Could it be something I need for VS2019 and I had in VS2017??



    • Edited by Mimosa Arts Wednesday, May 29, 2019 12:36 PM
    Wednesday, May 29, 2019 12:36 PM


  • Downloaded SQLite/SQL Server Compact Toolbox via the VS2019 extensions tool (vs. 4.7.634) and tried again and it worked!!  
    • Marked as answer by Mimosa Arts Wednesday, May 29, 2019 1:58 PM
    Wednesday, May 29, 2019 1:57 PM