Is it possible to create an association between two entities where no foreighn keys exists in the database. If ca foreign key is needed, can this be restricted to the model only, so as not to modify the database?
Thanks
Associations without keys
Re: Associations without keys
Yes, you can create an association in the model without foreign keys in the database in the following alternative ways:
1) turn off the "Model Settings > Synchronization > Mapping > Enable automatic synchronization of storage part and mapping of the model with its conceptual part" option and create an association in CSDL
2) create an association in CSDL (and corresponding constraints in SSDL will be created if the synchronization option is enabled) but do not apply the foreign key changes in the Update Database From Model wizard when using it
1) turn off the "Model Settings > Synchronization > Mapping > Enable automatic synchronization of storage part and mapping of the model with its conceptual part" option and create an association in CSDL
2) create an association in CSDL (and corresponding constraints in SSDL will be created if the synchronization option is enabled) but do not apply the foreign key changes in the Update Database From Model wizard when using it