Hi,

i have a stupid problem but i dont know how solve it , im sure nhibernate can do it but i dont why not do :)

I have a parent-child form, i read a parent from the db add a new child and then saveorupdate. I define the parent´s bag with cascade="all-delete-orphan" but when save this new child nhibernate try to save a null value in the parent´s reference in the child table and i have an error.

the code:

Dim alb As Albaran = albaranDao.GetById(1, False)
Dim albd As New Albaran_Detalle
albd.Id_Articulo.Id = 1
.....
Albaran_DetalleList.Add(albd);
albaranDao.SaveOrUpdate(alb)
albaranDao.CommitChanges()

error: No se puede insertar el valor NULL en la columna 'Id_Albaran', tabla 'ATENOR.dbo.Albaran_Detalle'. La columna no admite valores NULL. INSERT falla.Se terminó la instrucción.

cant insert null value in the column "Id_Albaran".... The column not admit null values. Insert fail....

Any know what is wrong??.

thanks for all.


<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Core" namespace="Core.Domain">
<class name="Albaran" table="Albaran">

<id name="Id" column="Id" type="Int32" unsaved-value="null">
<generator class="native"/>
</id>
<bag name="Albaran_DetalleList" inverse="true" lazy="true" cascade="all-delete-orphan" >
<key column="Id_Albaran" />
<one-to-many class="Albaran_Detalle" />
</bag>
<property column="Cod" type="String" name="Cod" length="50" />
<property column="Fecha" type="DateTime" name="Fecha" not-null="true" />
<many-to-one name="Id_Cliente" column="Id_Cliente" class="Cliente" />
<property column="Observaciones" type="String" name="Observaciones" length="50" />

</class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Core" namespace="Core.Domain">
<class name="Albaran_Detalle" table="Albaran_Detalle">

<id name="Id" column="Id" type="Int32" unsaved-value="null">
<generator class="native"/>
</id>
<many-to-one name="Id_Albaran" column="Id_Albaran" class="Albaran" />
<many-to-one name="Id_Articulo" column="Id_Articulo" class="Articulo" />
<property column="Cantidad" type="Int32" name="Cantidad" />
<property column="Precio" type="Decimal" name="Precio" />
<property column="Descuento" type="Decimal" name="Descuento" />
<property column="Id_Factura" type="Int32" name="Id_Factura" />

</class>
</hibernate-mapping>

maybe not is nhibernate works do it, im not sure.

I found this post:
http://forum.hibernate.org/viewtopic.ph ... 0d70fd7f45

But im not sure yet, if i create a new parent with childs nhibernate saves all well(save the parent and then save the childs with the new parent´s id the only problem is when i add a new child to a existing parent.

any explanation about why it not save it?

thanks a lot.

Like the post that you found said, you need to handle the bidirectional relationship in your code.
So in addition to adding the child object to your parent's collection, you'll also need to assign the parent object to your child object's property (Id_Albaran in class Albaran_Detalle).
NHibernate doessn't handle the bidirectional relationship automatically, so I typically add methods on the parent (aggregate) objects that manage all this for me. Best practice.

Good luck!
MIKE

thanks to confirm Mike.