Entity Framework update from database doesn't show at my edmx file

Question

After successful connection with database can't see tables. I try to use "Update from database" button but it doesn't appear at menu. How can fix it? What did i miss?

You missed the part "Right click on the design surface". You should double-click the EDMX in the solution explorer to open the design surface. — Gert Arnold, Jan 02 '19 at 14:57

Dani · Accepted Answer · 2019-01-02T14:57:00.603

1

For view tables you have two options (Maybe more, I don't know):

1 - Double click in "edmx" file, it will show you a database diagram.

2 - Once inside the diagram open View --> Other Windows --> Entity explorer data model.

Inside new panel you can see a lot of information of your database, like tables and Views in "Tables/Views" or functions in "Functions/procedures".

And for add, update database, inside edmx diagram, right click, "Update model from database" and you will be able to add, update or delete tables, views... etc:

edited Jan 02 '19 at 14:57

answered Jan 02 '19 at 14:45

Dani

1,825
2
15
29

I did it, but any model hasn't been added. Didn't receive any error also. – SixtySeven Jan 02 '19 at 15:44
You have to select tables that you want to add to the model by expanding and checking it !!! @SixtySeven Try and tell me please !!! – Dani Jan 02 '19 at 15:47
I select evey time but model still hasn't been created. I try to open toolbox but it's closing immediately. – SixtySeven Jan 02 '19 at 15:53
I have sht like this: errors.EntityModels.edmx – SixtySeven Jan 02 '19 at 15:55
Are you triying to add or to update tables? – Dani Jan 02 '19 at 15:58
Resolved. Primary key was missing. Thanks for your advices. – SixtySeven Jan 02 '19 at 16:06
I'm glad to hear it. Welcome to StackOverflow !!! – Dani Jan 02 '19 at 16:55

Entity Framework update from database doesn't show at my edmx file

1 Answers1