We have the following table structure: tbl_A A_ID INT PK Type_ID INT
tbl_EA EA_ID INT PK A_ID FK to tbl_A C_ID INT (reference to other table based on Type_ID from tbl_A) tbl_C C_ID INT PK So, we're thinking tbl_A is abstract class, and each type is a subclass, discriminator based on Type_ID. But then we run into problems handling tbl_EA. It has a "fake" discriminator, in that you join to tbl_A in order to determine the type. This is b/c having a Type_ID column in tbl_EA is redundant, you have to join on tbl_A anyway to get that data (there are more columns to the tables, but not needed for this). Then, we have to somehow map the relationship b/w tbl_C and tbl_EA. SQL to get all EA items for a C entity: select * from tbl_EA where C_ID = <CID> AND A_ID IN (select A_ID from tbl_A where type_id = <C>). Any ideas on how to set up mapping for these tables, and corresponding relationships? I feel like answer may lie in the formula of a discriminator, but can't figure it out. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
