I have 2 tables : Persons and Emplyees.

Persons:

PersonID PK
Name
DateofBirth

Employees:

EmployeeID PK
PersonID FK
Job


Now, I want to have an object in the code which includes properties like person name, job etc. (this is like a join in SQL)

How should I do the mapping, I don't quite get it.

Thanks!

The more general approach is to model the employment as a qualified association to an Employer class, in this case that one person can be employed by several Employers. This means that Person and Employment will be separate classes.

Implementation: Person -one-to-many- Employment -many-to-one- Employer.


Cheers,
Radu

Actually its not employer, but employee.

What I want, is to have Employer object in the code, so i can get the names and stufff from employer object(names are stored in Persons table in DB not in Employee table.).

if you are sure that between Persons and Employee you have a one-to-one relationship (and this won't change in the future) you can map a Person object on Persons table and have Employee object inherit from Person and map it as a joined-subclass.

radu

[deleted]

Try to take a look at this one

http://nhibernate.sourceforge.net/nh-do ... ation.html

search for one-to-one in the table of contents

Well, actually one person can act in many employee roles.

One employee is a certain person, but one person could have several employee roles.

"Well, actually one person can act in many employee roles.

One employee is a certain person, but one person could have several employee roles."

Oops, my fault. He can instead take a look at the one-to-many, many-to-one, or whatever association that suits his requirements.