I have three objects: Staff, Project, and ProjectTeam. Project team looks like so:



Essentially this table is part of a many-to-many relationship between the project (ptProjKey) and the staff member (ptStKey).

I've created this table a a separate business object so I can get to the ptStRole field. I can add items just fine it is when I delete that things become problematic. Either I get :

Or


I'm trying to remove the reference to the ProjectTeam entry from the Project and Staff objects BEFORE I do the delete, but this doesn't seem to work. It appears that when I try to remove the reference with a call like this:

the database tries to do an UPDATE first, which of course will fail since the foreign keys can't be null.

Solutions? Work-around? Thoughts?

Thanks
Jack

What you infact want to do is remove an member of the staff from the project, correct?

If you skip the databasethinking for a while, this would in an OO-way-of-thinking be done like this:

myProjectInstance.Members.Remove(MyStaffMemberInstance);

And thats also one way to go at it from nHibernate, delete the item from the collection and persist the object again, this could be done something like this:

Project p = sess.Get<Project>(identifier);
StaffMember sm = sess.Get<StaffMember>(identifier);
p.Members.Remove(sm);
sess.SaveOrUpdate(p);

In fact, due to transparent persistence you don't even need the SaveOrUpdate call - the changes will be persisted into the database on the next flush and committed with your transaction.

Cheers,

Symon.