Hi everybody,

When I use some templates for my mapping and persistent files.
In my mapping file display

<property name="StaffID" column="StaffID" type="int" not-null="true" />
<property name="StaffName" column="StaffName" type="string" not-null="true" />

<many-to-one name="Department" column="DepartmentID " />

Here is persistent class :

protected int _StaffID;
protected string_StaffName;
protected Department _Department;

In my code how I can update or insert 1 staff because I can not to access directly to DepartmentID for setting or getting its value.

Staffs st=new Staffs();

st.StaffID = 1;
st.StaffName = "Test";
st.Department.DepartmentID = 1; //Here is problem

It will update DepartmentID on Department Table not on table Staffs.

Pls help me solve this problem.

Thanks in advance.

You should set the entire department.
Load the Department with id 1 into a object ("department") and assign it to the variable (st.department = department).

That should be the way to go, the way your doing it, your altering the id of the department of that staff, not assigning department with id 1.

You may use a workaround, use
<many-to-one name="Department" column="DepartmentID " update="false" insert="false"/>
only as the reference of the object and a
<property name="DepartmentID" column="DepartmentID" type="int" not-null="true" />
to access directly the column of staff (and altering the getters/setters to keep them pointing to the same department), but you should use the first option.

;)

Thanks for your response.

I use :

st.StaffID = 1;
st.StaffName = "Test";
st.Department = (Department)LoadObjectByID(typeof(Department), Depement_ID);

and it's OK.