I'm attempting to use an existing database to develop an entity data model.
This is what I do in Visual Studio 2010:
I have tables in my database, and the login and password I'm using to connect has rights to view these tables without issue. However, after completing these steps, the Entity Data Model visual tool (i.e., double clicking on the.edmx file) does not display any tables.
Use a text editor to see your edmx file. Attempt deleting all the EntitySet nodes and EntityType nodes, saving the file, then returning to Visual Studio to try the Model Update from Database again if you can see the tables in the file but not in the designer.
<edmx:StorageModels> <Schema Namespace="myModel.Store"> <EntityContainer Name="MyModelStoreContainer"> delete-> <EntitySet Name="Table1" ... /> delete-> <EntitySet Name="Table2" ... /> </EntityContainer> delete-> <EntityType Name="Table1">...</EntityType> delete-> <EntityType Name="Table2">...</EntityType> </Schema></edmx:StorageModels>
I had a same issue. However, in my situation, it was because the chosen table's Primary Key was missing. So I changed the model from the database and added a primary key. I then had a clear view of the table and its columns.