Hi All,

Can a foreign key act as a discriminator? I have got two entity families A & B. Both A & B follow 'table per class hierarchy'. I need to associate A1 (subclass of A) with B1(subclass of B) & A2 (another persistent subclass of A) with B2(another persistent subclass of B.

Is it possible or I am just thinking too aloud here?

Regards,
Nitin

---

If you follow the "table per class" as you said, it should be as below:

1. There are two tables, A and B. A and B should have their discriminator columns, so that class A1 and A2 can extend class A; class B1 and B2 can extend class B

2. To associate A1 with B1; A2 with B2, you can just add a property as the code below:

3.

I don't know why you thought a foreign key act as a discriminator?

Hi,

I am following "Table per class hierarchy" i.e. a single table for a class and its subclasses. In my design, there is such a requirement that entities of one family are to be associated with the entities of another family. These families are represented by 2 db tables.

regards,
Nitin