Cannot drag tables from model browser into edmx design surface
ado.net-entity-data-model c# entity-framework-6 odp.net
Question
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:
Accepted Answer
Might be because of the below reasons:
- I believe you have to choose the "Update Model from Database..." context menu option and pick the tables from the list
- Ensure the table you are trying to drag and drop has primary key defined
Popular Answer
I guess it is Linq to SQL file, Linq to SQL file experience is bad in my case.
Instead of drag drop you need to do following
Right click on the EDMX designer surface. You have lot of options and among them choose the option 'Update Model from Database'.
Now, you will see the usual screen which has all the database objects in new window which you have seen while creating EDMX file.
From this windows chose the new table and generate EDMX model from it.
After that this model will appear in EDMX designer window.
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
