Mapping a property of a class to another Table's column in nHibernate?

Question

For some reason in a legacy database I am working with does not have any relationship defined. I have TableA mapped to ClassA. Now in ClassA I need to add PropertyB which has a corresponding column in TableB. How can we add this without adding a Relation?

I am using Castle Active Record over nHibernate.

Answer 1

You may be able to use the join element in your mapping to accomplish this.