The OraDirect EDM Wizard automatically maps all of the columns (of supported types) to Entity properties. This is great. The issue is when you want to add Assocations between two entities.
After you create the association and set the mapping (in the Mapping Details) everything seems fine. Not until runtime do you discover something is wrong:
The meaning behind this error is that an Entity property cannot be mapped to both an association and a column in a table. If you want the association, you need to remove the scalar property that references the same column.error 3007: Problem in Mapping Fragment(s) starting at line(s) (12, 32): Non-primary-key column(s) [FK_ISO_ID] being mapped in both fragments to different C-side properties - data inconsistency is possible since the corresponding C-side properties can be independently modified
Hope this helps someone.
Cheers,
Will