Hello, everybody!
I have got the following problem.
I have Parent and Child classes.

// Parent class

namespace ParentChild
{
public class Parent
{
public int Id
{ get{ return _id;}
set{ _id = value;}
}
private int _id = -1;

public IList Children
{
get{ return _children;}
set{ _children = value;}
}
private IList _children = new ArrayList();

public Parent(){}
}
}

// Child class

// Parent class

namespace ParentChild
{
public class Child
{
public int Id
{ get{ return _id;}
set{ _id = value;}
}
private int _id = -1;

public Parent ParentInstance
{
get{ return _parentInstance;}
set{ _parentInstance = value;}
}
private Parent _parentInstance;
public Child(){}
}
}

and here is the mapping file:

<class name="ParentChild.Parent, ParentChild" table="Parents">
<id name="Id" column="Id" type="Int32" length="4" unsaved-value="-1">
<generator class="identity" />
</id>
<bag name="Children" lazy="true" inverse="true" cascade="all">
<key column="Id" />
<one-to-many class="ParentChild.Child, ParentChild"/>
</bag>
</class>

<class name="ParentChild.Child, ParentChild" table="Children">
<id name="Id" column="Id" type="Int32" length="4" unsaved-value="-1">
<generator class="identity" />
</id>
<many-to-one class="ParentChild.Parent, ParentChild" column="ParentId"/>
</class>


I want to delete parent object and all its children.But I have the following exception message: "DELETE statement conflicted with COLUMN REFERENCE". I know it's not a hard problem, but I haven't solved it yet :(.

Your mapping:


I think the "key" element of the bag should be mapped as

I found the solution of the problem.It was in database structure.There were old relations between my tables.The problem was solved after deleting those relations