Mike
Mike

Reputation: 1170

Entity Framework, update model from database, no 'Table' arrow

I have an edmx that resides in VS2012...when changing the App.config to have the edmx point to a database on my local machine, I cannot access any tables to add using the right-click 'Update Model from Database...' option.

The dialog comes up, and normally there is an expander arrow to the left of Tables, which when clicked expands Tables and shows the schemas, and I can choose tables to add.

But after changing the App.config, the expander arrow to the left of Tables no longer displays, and I cannot add tables to the model.

What would preclude the expander arrow from showing?

Upvotes: 0

Views: 396

Answers (1)

Craig Graham
Craig Graham

Reputation: 1191

Permissions? Try connecting through SSMS to your local DB using all the connection details specified in your app.config file and verify that user has permission to see the tables.

Upvotes: 1

Related Questions