Hi all,
I have a parent/child relationship and find that, when I update child
records, NHibernate is updating the ID for the previous child records
in the DB to NULL and inserting new records for all of the children
(even ones that did not change), but not deleting the now-orphaned
child records. Thoughts on how to get the orphans to be deleted?
<class name="InvoiceLibrary">
...
<bag name="LineItemList" table="lineitems" cascade="all-delete-
orphan">
<key column="InvoiceLibraryId"/>
<one-to-many
class="LineItem"/>
</bag>
</class>
<class name="LineItem" table="LineItems" lazy="false">
...
<many-to-one lazy="false" name="Parent" column="InvoiceLibraryID"
not-null="true"
class="InvoiceLibrary"
/>
</class>
The save method looks like this (InvoiceLibrary object is passed in)
public void Save<T>(T item)
{
using (ISession session = m_SessionFactory.OpenSession())
{
using (session.BeginTransaction())
{
session.SaveOrUpdate(item);
session.Transaction.Commit();
}
}
}
After my initial save, and then an update of two line items and
another save, I end up with one line in the InvoiceLibrary table, two
lines in the LineItems table with the original line item data and an
InvoiceLibraryId of null, and two lines in the LineItems table with
the updated line item data and an InvoiceLibraryId pointing to the
correct InvoiceLibrary.
Thanks!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
