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:
Might be because of the below reasons:
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.