Typical parent/child many-to-one relationship. I want to be able to
delete all children of a parent, but not the parent. Also, I'd like
to see a single DELETE statement against the child table, using the FK
(the PK value of the parent table), rather than individual statements
on the child table using the PKs of each child row.
Parent class:
<bag name="Children" inverse="true" lazy="true"
cascade="delete">
<key column="ParentID" />
<one-to-many class="Child" />
</bag>
Child class:
<many-to-one name="Parent" column="ParentID"
cascade="save-update"
not-null="true" />
In the parent class, Children is declared as an IList<Child>. CRUD
operations appear to be working correctly, except in the case of
deleting the entire child collection. Here's what I'm trying.
Parent p = sess.Get<Parent>(1);
p.Children.Clear();
sess.Update(p);
sess.Transaction.Commit();
This doesn't cause anything to be deleted. If I do it this way:
foreach(Child c in p.Children)
sess.Delete(c);
sess.Transaction.Commit();
Then the correct rows are deleted, but 1 at a time. I want to see
this instead:
DELETE from Child WHERE ParentID = (the parent's ID)
I tried to search in past posts here, and it seems that calling
parent.Children.Clear() should work, but I'm not having any luck.
Help?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---