Hello,

I work with NHibernate 1.2 and I'm having problems trying to do the following:
I want to make a many-to-one relation based on a formula instead of a column.

My problem:
I have table A and table B.
They don't have a direct relationship, but for each A I can get the primary key of B using a function. In my mapping file, I want to configure the relation that way.

Is this possible? Is there any other way to achieve this behaviour?

Regards

Addition:

I tried creating a DB View and adding the formula field to it. But now I'm stuck at how to map this to the "default" select of my class (in the mapping file)?