NHibernate-One 2 one association with different field names

[acheven]

Hi,

Until "property-ref="PropertyNameFromAssociatedClass"" is implemented in the entity developer for NHibernate, (http://ayende.com/blog/3960/nhibernate- ... one-to-one), how would I map an optional association in the following scenario:

Customer.BillingAddress

[customer].[billing_address_id] [addresses].[address_id]



Cheers,
Andrei

[Shalex]

Please open Association editor, select the Constrained checkbox on any end of your one-to-one association, select Separate Foreign Key, and set column mapping for the foreign key. As a result, Entity Developer will add the property-ref attribute to your association in *.hbml.

[acheven]

Yes, I saw this, but this creates a non-nullable association, I was asking how to model an optional relationship. I.e. if customer does not always have a billing address ([customer].[billing_address_id] is nullable in DB)?

[Shalex]

Please open Association editor, select the Constrained checkbox on any end of your one-to-one association, select Separate Foreign Key, and set column mapping for the foreign key. As a result, Entity Developer will add the property-ref attribute to your association in *.hbml.

leads to

Code: Select all

You can control the not-null setting via Association editor.

[acheven]

same as in my other post - there are extra properties window in column mapping. All good now, thank you.