Cascade delete problem

kilonet · **Joined:** Thu Nov 06, 2008 8:39 am **Posts:** 2

I have domain object "Parent". It has propery - a collection of objects "Child"
here is piece of parent.hbm.xml

Code:

<set name="Children" lazy="true" access="field.camelcase" inverse="true" cascade="delete" batch-size="10" >
  <key column="[parent_id]" foreign-key="[FK_Children]" />
  <one-to-many class="ParentChild" />
</set>

There is also table "ParentChild" which has two columns <parent_id><child_id> where listed children of each parent

Problem is - when i delete parents, their children also deleted, but records from "ParentChild" (acording to deleted parent) remains unmodified

how can solve this problem?

monit · **Posted:** Thu Nov 06, 2008 3:18 pm

cant you just create a database constraint withh cascade delete? What kind'o database are you using?

kilonet · **Joined:** Thu Nov 06, 2008 8:39 am **Posts:** 2

ms sql 2005
is't it possible to solve my problem using only nhibernate mapping files?

monit · **Posted:** Thu Nov 06, 2008 4:17 pm

pretty new in this, but if I was in any lead of a project like nhibernate, I would not care about those only relation tables, I would expect the rdbms to handle this.