lazy="extra" or executable-HQLbtw if you have a test proving that Clear is
not working create a JIRA with the test case attached.

2009/5/14 MAMMON <[email protected]>

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


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

Reply via email to