Model.edmx[Diagram] not showing tables in diagram

Zubair Munir

I have added new connection and select database and after click next then select tables and procedure and next but the tables is not showing in diagram

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar7y ago
Accepted answer
You need to required add atleast one identity column with integer field then it will reflect as I have checked and facing same problemn. After updating and adding column with identity column you can go to model designer and right click and then select update model from browser in the designer. Select the table and it will reflect. You can check with adding primary key and some records in the table also.

Hope this will help you.
+2
Zubair Munir7y ago
i try many times still not working
+1
Zubair Munir7y ago
not working anything
+1
Suraj Kumar7y ago
You can also check with expanding edmx file as shown in image.
+1
Suraj Kumar7y ago
As you have done all your steps properly and finished button is already showing and you might clicked and finished the steps finally. I request you to check after double clicking on edmx file and go to designer sometime it might not appear due to big size you can resize and check the table whether it is hiding or not as shown in attached image.

The another option to check is call the name of table in any controller and try using with the name of table if it is not giving error then it is present in the edmx file.
+1
Zubair Munir7y ago
i have attached all procedure pics...i have try everytime new connection and i also test connection .the connection is succesed is show...
+1
Suraj Kumar7y ago
Have you selected done all the steps in steps - Choose your database connection here you can choose the option New connection as shown in attached image? I think your connection with database server has not established properly after which it will work as usual.

Hope this will help you.
+1
Zubair Munir7y ago
The both radio button are disabled
+1
Suraj Kumar7y ago
Have you selected either radio button which ask you to save sensitive data in connectionstring after that it will enable next and ok button. Please have a look into that option.

https://www.completecsharptutorial.com/entity-framework-6/install-entity-framework-and-create-entity-data-model.php
+1