Error 3027: mapping is not defined for the following EntitySet / AssociationSet systems - sysdiagrams (mistakenly deleted the sysdiagram table)

Question

So my problem is that I added an extra column in my one of the tables in the database in SQL, and I wanted to reflect this change in my MVC project. So what I usually do is update the model from the database, and it works all the time. But this time it did not work, so I decided to let me remove the table from Project1Model.Store> Tables / Views from the EDMX model browser, and then update the model from the database (which worked in the past for me). But by mistake, deleting the SessionDetail table, I deleted the sysdiagram table from the tables / views.

Now I do not have the sysdiagram table in the "Tables / Views" section, but I see this table in the chart and in EntityTypes. I tried to create a model from the database, but did not work. I don’t want to create a database from the model because I know that I deleted something from my model and don’t want to use my database, which is fine (let me know if I am wrong, this is the right way).

I still get this error after creating solutions. Let me know how I can recreate the sysdiagram table in the "Table / Views" section.

Thanks at Advance. -Arpan

Answer 1

, .edmx sysdiagram, .

, , , , , .

, , db, db, sysdiagrm .