Situation:
A <-- link table AB --> B
A has IdentityA column as PK;
B has IdentityB column as PK;
AB contains FKs to both tables (IdentityA and IdentityB FKs).

In real case A is linked to B as 1:1, meaning that there is only one B related to A.

Is there a way to write such mapping file, so that A contained not the list of Bs, but just one reference to B (as using <many-to-one> mapping)?

Yes you will need to use a join. It eventually should look something like:




Farzad-

Which version of NHibernate are you using? I can't seem to find the <join> tag..

My bad. I was thinking of hibernate for Java. However, I took a look at NHibernate documents and I couldn't find any one-to-one association with an association table, I took a fast look though. One-to-one associations with an association table are extremely rare anyways. One thing you can do is to define a view in your database so that it looks like a simple many-to-one and map the view instead of table. However, it might not be your choice if you need to update the data in that table too.

Farzad-