fluent NHibernate one-to-one relationship?

Question

I have a problem with one-to-one relationships in the fluent nHibernate.

I have the following relational table from the AdventureWorks2008 database.

BusinessEntity (Table) BusinessEntityId Int (PK, Identity) Person (Table) BusinessEntityId int (PK, Reference with BusinessEntity table) FullName varchar(255)

The relationship between BusinessEntity table and Person table is one-to-one.

How do I map fluently without any extra field like "Id" in the Person table?

There should be 2 class one for Person and another for BusinessEntity, or an appropriate model to best describe the above relation.

Thanks, Ashraf.

There should be 2 class one for Person and another for BusinessEntity. or an appropriate model. example public class Person { public virtual BusinessEntity BusinessEntity { get; set; } public virtual string Description { get; set; } } — ashraf
– ashraf, Commented Oct 21, 2009 at 0:06

Deeksy · Accepted Answer · 2009-10-21 00:01:53Z

presuming your Person mapping is pretty standard, the way you do this is by saying:

Id(x => x.BusinessEntityId) .GeneratedBy.Foreign("BusinessEntity");

on the Person class.

This presumes that your Person class has a property called BusinessEntity which is of type BusinessEntity.

You'll also need to map BusinessEntity to Person with constrained set to true (to say that they primary key of Person is a foreign key reference to BusinessEntity).

The key thing is the GeneratedBy.Foreign() to say that your identity is generated by a link to another class.

Collectives™ on Stack Overflow

fluent NHibernate one-to-one relationship?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related