Geek Answers Handbook

Entity Framework: remote SQL table is not deleted from the model

Apparently, a simple thing made me completely freeze, and I can not find anything on the Web about this:

In my db, I had many different relationships:

Table One + TableTwo + LinkingTable with two columns: TableOneID and TableTwoID

I removed LinkingTable and tried to update the model from the database. Now I get the error "Error 11007: Object type" LinkingTable "is not displayed."

Does anyone know what exactly this EF wants? Thanks!

+7
source share
2 answers

Right-click the model in Solution Explorer. Select "Open With ..." Select "XML (Text Editor)" in the dialog box. Remove all LinkingTable nodes and links (or whatever its real name) from the xml model. Close all model files that are currently open (I know, weird). Build a project. Open the model again. Everything should be fine now.

+11
source

Open the model browser. In the Entity types, select the table to be deleted. It will delete all associations with the table.

It worked for me.

+1
source

More articles:


All Articles