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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
