Christopher J. Grace Christopher J. Grace - 1 month ago 13
C# Question

Unable to Update Model from Database using EF 6 and Visual Studio 2015 Update 3

Right click on the EF Model Designer surface and choose Update Model from Database.
Update Model from Database

In the dialog box that pops up, you should be able to browse the database, and select objects to add. But in this case, nothing can be selected:
Selecting database objects to add

Removing the Connection String from the App.Config and allowing the Designer to re-add it did not resolve the issue.

The credentials used in the Connection String when copied and pasted in SSMS.

The database can be browsed from the VS Server Explorer window.

Creating a new blank EF project and repeating from there works fine.

What could be causing this?

Answer

One of 2 problems exist, the Model already has the Tables/SP/View you are looking for or the Login does not have the Authority the access those Tables/SP/View.

Comments