Hi Guys,

I am dealing with a simple concept that I am not able to resolve. I have three classes that I persist using Nhibernate.
1) Doctor (ID, Name)
2) Patient (ID, Name)
3) Appointment (ID, DoctorID, PatientID)

In my appointment class I map two properties Doctor and Patient and setup the many to one relation respectively.

Now when I load the list of appointment, it will have multiple instances for the same patient. So for example:

Appointment # 1, Patient #1
Appointment # 2, Patient #1 (Different Instance)

The reason I know Patient #1 has another instance is because if I change the first instance, the second instance does not change.

In terms of ADO DataSet, this scenario would not have accorded since there would only be a single Patient Row and two Appointment Rows.

Thus, what I am trying to get to is this. Is there a way to have a single instance of Patient loaded for different Appointment object.


Thanks.

If both appointmets are retrived from one session, the patient #1 should be one instance. If from different sessions, The I do not know how to force them to be one inctence... Maybe using session.Lock or something would help...

Gert

If from different sessions, in the second session, call session.Lock(patien1) or session.Lock(appointment1) before you load appointment2