jstuardo jstuardo - 2 months ago 25
C# Question

Cannot drag tables from model browser into edmx design surface

I am using ODP.NET. I have added an ADO.NET model to the project. That way, an edmx file was created. I chose "create from database" and after I selected the tables and click finish, edmx design surface appeared empty, however, the model browser window showed my added tables.

The problem now is that I cannot drag & drop the tables from model browser to the design surface. Please see this screenshot:

enter image description here


Might be because of the below reasons:

  1. I believe you have to choose the "Update Model from Database..." context menu option and pick the tables from the list
  2. Ensure the table you are trying to drag and drop has primary key defined