Hi everyone,

i'm mapping an existing database with fluent Nhibernate and i've this issue:

Tables envolved:

TableA , PK: A
TableB , PK: B
TableC, PK: C
TableD, PK: AB

ok , till here it's all fine. the table that i have problems mappin is:

TableD, PK: ABC

sure i can definetely map it with a composite key made by 3 (pk of a, pk of b, pk of c), but in order to respect the true database schema i would like
to map it defining a composite-key made by 2 , the PK of TableC and the PK of tableD.

theres any way to do that ?

Hope i was clear explaining the prob.

Thanks in advance,

Regards

Alessandro Di Lello