Hibernate version: 1.2

Name and version of the database you are using: MSSQL 2005

Basically after loading a bag of items, I am calling a IList.Clear() and watching the sql being generated. I see it doing single line deletes for each entry in the bag. I thought when doing a .Clear() that nHibernate was supposed to do a single delete. Does this not work with a Bag item and I have to use some other collection item?

NHibernate will delete all the items from a collection if you set the collection reference to null, not if you use Clear.

Okay thanks, however now if I have my cascade="all" it doesn't seem to flush the deletes when saving the parent, which I kinda understand due to the idea that it is no longer referenced by the parent. However then I would think I should use the cascade="all-delete-orphan" which errors out saying you cannot dereference a collection with it. Do I need to retain some other reference to the child collection and flush that out seperatly?

the documentation states that you should change the reference of the collection, you have to keep the same, delete all its items, and add the new items.

hope this helps

When using "all-delete-orphan" an nhibernate exception will be thrown when dereferencing the collection. If I use "all" instead no deletes will be made, only the dereferencing of the children in one update statement ( Update children set parentid = null where parentid = xx).

If I use cascade="all-delete-orphan" and just clear the list of my children, it will cause one update to dereference all the children from the parent and then single deletes for each child, and this is what I don't want.

If any one can give me an example of code with a simple parent/child relationship that will execute a single delete of all children when cleared from the parent that would be great. Also is there a way to force this delete or dereference with out loading the data for the children. If all I am doing is the delete/remove, I don't believe that it should load there data first. If there is no way of doing this I can write my own HQL/SQL statements to take care of it I was just hoping there is an easier way with nHibernate.

Accoring to this http://www.hibernate.org/hib_docs/nhibe ... shotdelete
piece of the documentation this should all work. I too would be curious to see an example where that is indeed the case.

/Chris