Hello,
Can a BO have more than one parent? For instance, I have the following (simplified) schema (see attachment)
Parent1[PK][DomainValues]
/
Main[PK][FK1][FK2][Detail]
\
Parent2[PK][DomainValues]
Namely, a member of main must have the two FK ranges that fall within both of the Parent domains (A car has both an owner and a model).
I can (almost) get it to work if I switch the logic and misuse the keys (child is parent, parent is child and PK as FK and FK as PK) but I get an excepion when navigating - this approach is wrong so the attempt is null and void anyway).
If a BO can not have more than one parent then how does one enforce a relational schema with constraint values?
Abstracting it all via views or stored procedures?
Thanks - J
The BusinessLayerLinkManager was introduced to allow for the automatic maintenance of LinkTables, which have more than one relationship. However, the BusinessLayerLinkManager is designed for only 2 relationships (as in the use of a link table for a many-to-many relationship). Beyond 2 relationships, the relationship management is usually handled manually.