Geek Answers Handbook

Cannot drag tables from model browser to edmx workspace

I am using ODP.NET. I added the ADO.NET model to the project. Thus, the edmx file was created. I chose “create from database”, and after I selected the tables and finished clicking, the edmx design surface was empty, however the model browser window showed my added tables.

Now the problem is that I cannot drag the tables from the model browser onto the design surface. See this screenshot:

enter image description here

+7
c # entity-framework-6 ado.net-entity-data-model
source share
3 answers

Perhaps due to the following reasons:

  • I believe that you need to select the option "Update model from database ..." and select tables from the list.
  • Make sure the table you are trying to drag has a specific primary key.
+5
source share

A few thoughts here.

1.) Does the user ID in app.config for this database have permissions to make changes?

2.) Do you have ODT (Oracle Developer Tools) installed?

3.) Do you use consistent / compatible versions of ODT, Oracle Client (ODAC) and the database itself?

0
source share

I assume this is a Linq to SQL file, the Linq to SQL experience is bad in my case.

Instead of dragging and dropping you should do the following

  • Right-click on the surface of the EDMX designer. You have many options, and among them the option "Update model from the database" is selected.

  • Now you will see a regular screen in which there are all database objects in a new window that you saw when creating the EDMX file.

  • From this window, select a new table and create an EDMX model from it.

  • After that, this model will appear in the EDMX designer window.

0
source share

More articles:


All Articles