I updated the mapping to reflect your last post. It's still not deleting anything.
parent.Children.Clear(); sess.SaveOrUpdate(parent); sess.Transaction.Commit(); With your updated mapping, would there be some other way to delete all of a parent's children? As opposed to the what I have above? Also, I notice that by referencing parent.Children, I cause that collection to lazy load, when really, I simply want to delete all of those records in the database. It would be nice to find a way to issue a single delete statement to get rid of that data, without having to superfluously load it via NHibernate first. On May 14, 12:56 pm, Fabio Maulo <[email protected]> wrote: > <bag name="Children" cascade="all" inverse="true"> > <key column="parentId" on-delete="cascade"/> > <one-to-many class="Child"/> > </bag> > > 2009/5/14 MAMMON <[email protected]> > > > > > > > So is there a way to clear all of the child elements in one shot, > > without deleting the parent? > > > On May 14, 12:39 pm, Fabio Maulo <[email protected]> wrote: > > > the cascade is wrong.The cascade mean : what should do NH in case you are > > > doing something with the collection owner ? > > > > In your case you are saying to NH that you are interested in cascade only > > > when you are deleting the parent, all other actions (as update in your > > > example) will be ignored. > > > > The cascade="save-update" in the child has no sense. > > > > 2009/5/14 MAMMON <[email protected]> > > > > > 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? > > > > -- > > > Fabio Maulo > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
