Hello,

I have the following database schema:
Document <-- DocumentImage

Document table has PK (identity) DocumentId and also has unique column DocumentNumber;
DocumentImage has PK (identity) DocumentImageId and a FK column DocumentNumber which refers to Document.DocumentNumber (note: not to PK, but to unique column).

Document (as .NET class) has a list of DocumentImage classes. How to write a correct mapping file so that DocumentImages are loaded along with Document?

At this momemt if one Document is selected from database, e.g. with DocumentId = 5 and DocumentNumber = 123, then there goes another select for DocumentImages with "<..> WHERE IMAGE.DocumentNumber = 5" <-- it should have the following WHERE clause: "WHERE IMAGE.DocumentNumber = 123".

Regards,
Mindaugas

This is not currently possible. The images can reference the document using <many-to-one ... property-ref="DocumentNumber" />, but a similar facility for collections will only be available with the 2.0 release of NH.

See http://jira.nhibernate.org/browse/NH-1134 and http://jira.nhibernate.org/browse/NH-1162

Maybe you could suggest how to load childs along with parent in this situation?