Table per subclass mapping strategy when inheritance is more than 1 level deep

[Drakiula]

Hi, I have the following class inheritance hierarchy:

public class A {}

public class B : A {}

public class C : B {}

public class D : B {}

In the database I have tables A, B, C, D where:

- B has a foreign key relationship to A;
- C and D have foreign key relationships to B;

Both foreign key relationships are established using the PK field of
the tables(PK field type is Decimal).

On top of that, both base classes contain a discriminator column that
indicates the inheritor type.

Question: is this mapping scenario possible in NHibernate(table per
subclass, using the mentioned class inheritance hierarchy)?
If the answer is yes, how should the XML mapping file look like? Are
nested <joined-subclass /> elements allowed/supported?

Thanks in advance for your answer,
Dragos

[Fabio Maulo]

You can't mix <subclass> with <joined-subclass>

You should use <subclass> and <join>

About multiple circular reference try to create it by hand in your RDBMS and then insert something with pure SQL (by hand again).

2009/5/25 Drakiula <haiduc...@gmail.com>

--
Fabio Maulo

[Drakiula]

Thanks for the answer.

Can you please provide a sample full mapping for my scenario?

[Fabio Maulo]

2009/5/25 Drakiula <haiduc...@gmail.com>

Thanks for the answer.

Can you please provide a sample full mapping for my scenario?

http://nhforge.org/doc/nh/en/index.html#inheritance-tablepersubclass-discriminator

--
Fabio Maulo