I have

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Entity.Alex">
<class name="Entity.Alex.Asset.BookAsset" table="asset_asset_type_book">

<id name="ID">
<column name="asset_id" sql-type="int" not-null="true"/>
<generator class="identity" />
</id>

<property name="Plot" column="plot" type="String" not-null="true" />

...snip...

<set name="Castings" inverse="true" table="asset_asset_people_link" where="asset_person_type_ref=2" cascade="all">
<key column="asset_id"/>
<many-to-many class="Entity.Alex.AssetMeta.Casting" column="people_id" />
</set>


</class>

</hibernate-mapping>

and

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Entity.Alex">

<class name="Entity.Alex.AssetMeta.Casting" table="asset_people">
<id name="ID">
<column name="people_id" sql-type="int" not-null="true"/>
<generator class="identity" />
</id>

<set name="Parents" table="asset_asset_people_link" inverse="false" cascade="all">
<key column="people_id"/>
<many-to-many class="Entity.Alex.Asset.BookAsset" column="asset_id" />
</set>

<property name="Name" column="name"/>



</class>

</hibernate-mapping>

What code would delete just the relationship. I am trying various combinations of:

Entity.Alex.Asset.BookAsset ent = 'the Book Asset Entity';

for (int i = ent.Castings.Count - 1; i >= 0; i--)
{
Entity.Alex.AssetMeta.Casting t = ent.Castings.ElementAt<Entity.Alex.AssetMeta.Casting>(i);
if (t.State == KPU.Application.Contracts.Data.linked_entity_state.delete_link_or_child)
{
ent.Castings.Remove(t);
//t.Parents = null;
//session.Delete(t);
}
}

NOTE: The property t.State is set in the client to signal that the relationship can be deleted.

Thanks.

You are looping through a collection and amending the collection as you go. Surely this will end up in some kind of error (out of bounds or something)

You have said inverse = false to the "Entity.Alex.AssetMeta.Casting" class, but you're removing the items from the other side of the relationship. Remove them from the casting class and NHibernate should then update.

I believe the reason nothing is happening, is because the inverse=true on the BookAsset means "I don't need to update, as i delegate responsibility to the other side"

Hope that helps