Model.edmx[Diagram] not showing tables in diagram

Question

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

Suraj Kumar · 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.

Zubair Munir · Answer

i try many times still not working

Zubair Munir · Answer

not working anything

Suraj Kumar · Answer

You can also check with expanding edmx file as shown in image.

Suraj Kumar · Answer

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.

Zubair Munir · Answer

i have attached all procedure pics...i have try everytime new connection and i also test connection .the connection is succesed is show...

Suraj Kumar · Answer

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.

Zubair Munir · Answer

The both radio button are disabled

Suraj Kumar · Answer

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