Hi,

I have to map a database I didn't design, so I can't change anything of the following:

[Employee] Table:

Employee_ID (PK)
Employee_Name
Employee_Num

[Employee] Object:

Employee.ID
Employee.Name
Employee.Num
Employee.Department

[Department] Table:

Employee_Num (PK)
Department_Name

[Department] Object:

Department.Employee
Department.Name


I don't know how to define the mapping between the Employee and Department table. I considered component and one-to-one, but couldn't make it work.

Any idea?

Thanks a lot in advance.

Recommendation:

1.) Use a local database to mirror the production environment.
2.) Create the same table with same columns (type/column name)

Once it works, just change the connection string to your production and it should work without any problem!

A component uses columns from the same table, so that's not possible here. You can use a many-to-one association here (at the end of 5.1.11 in the reference doc):

<many-to-one name="Department" class="Department" column="Employee_Num" unique="true"/>