MVC Entity Model not showing my table

Posted by Jessica on Stack Overflow See other posts from Stack Overflow or by Jessica
Published on 2009-11-12T23:52:17Z Indexed on 2010/04/19 13:03 UTC
Read the original article Hit count: 282

I have a database with multiple tables, and some basic relationships. Here is an example of the problem I am having:

My Database:

**Org**
ID
Name
etc

**Detail1**
ID
D1name

**Org_Detail1**
Org_ID
Detail1_ID

**Detail2**
ID
D2Name

**Org_Detail2**
Org_ID
Detial1_ID
BooleanField

My problem is, the Org_detail1 table is not showing up in the entity model, but the Org_Details2 table does.

I thought it may have been because the Org_Detail1 table only contains two ID fields that are both primary keys, while the Org_Details2 table contains 2 primary key ID fields as well as a boolean field.

If I add a dummy field to Org_detail1 and update it, it still won't show up and wont allow me to add a new entity relating to the Org_Detail1 table. The table won't even show up in the list, but it is listed under the tables.

Is there any solution to get this table to appear in my model?

© Stack Overflow or respective owner

Related posts about ado.net-entity-data-model

Related posts about multiple-tables