StrataFrame Forum

Can a BO have more than one parent?

http://forum.strataframe.net/Topic1263.aspx

By JKelly - 5/23/2006

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

 

 

 

 
By StrataFrame Team - 5/23/2006

JKelly,

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.