Entity Framework table related to multiple entities



We have a db with an address table that is related to a customer table,
serviceProvider table and a partners table. The relation to each is a 1 to
many as each can have multiple address types (billing, sales, ext). The
relation is from each table to the address table on the table ID to
AddressParentID and then ParentTypeID to identify the table the record is
related to. Does Entity Framework 3.5 or 4.0 support this and if so can I do
it in the gui or do I have to do it in the xml files?

Errors I get are
Foreign Key constraint 'FK_Contacts_ServiceProviders' has been omitted from
the storage model. Column 'ContactForID' of table
'KPNCircuitsModel.Store.Contacts' is a Foreign Key participating in multiple
relationships. A one-to-one Entity Model will not validate since data
inconsistency is possible.

Error 3007: Problem in Mapping Fragments starting at lines 306, 311:
Non-Primary-Key column(s) [ContactForID] are being mapped in both fragments
to different conceptual side properties - data inconsistency is possible
because the corresponding conceptual side properties can be independently

Table design
Address tbl
General address fields......

Customer tbl
General customer info......

serviceProvider tbl
General ServiceProvider Info……

Partner tbl
General Partner Info…..

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question