views:

28

answers:

0

Hi,

I have a table A containing items with : - an identity key - a non-nullable custom hash (generated on my own)

I have a table B containing documents with : - an identity key.

I have a table C containing documents slots with : - an identity key - a foreign key to table B (document) - a nullable custom hash (so table A is implicitly linked to table C)

The goal is to implicitly link some tables to table C... so I want a many-to-many relationship between entity A and entity B through entity C with non ID fields : - Entity A.CustomHash => Entity C.CustomHash => Entity B

The generated SQL query is just fine but NHibernate complains about assigning a String (the custom key) to an Int32 (the entity C identity field I guess)

Any idea about solving this ?

Best regards,