Hi,

We have two classes (Client and ClientAccount) with one-to-many relation:

<bag name="ClientAccounts"
table="ClientAccount"
cascade="all-delete-orphan"
inverse="false"
lazy="true">
<key column="ClientID" />
<one-to-many class="Common.ClientAccount, Common"/>
</bag>

There is in the database a unique index, including several columns of the ClientAccount table.

-----------------------------------------------------------------

There are troubles in a case like this:

From the database is loaded a Client with one ClientAccount. The user removes this ClientAccount and the code for that is:

client.ClientAccounts.Remove(clientAccount1);

Then he adds a new ClientAccount:

client.ClientAccounts.Add(clientAccount2);

We try to save the Client object:

session.SaveOrUpdateCopy(client);

The exception is received: "Cannot insert duplicate key row in object 'dbo.ClientAccount' with unique index 'IX_ClientAccount'.\r\nThe statement has been terminated."

-----------------------------------------------------------------

Obviously NHibernate first tries to add the object clientAccount2 (before removing clientAccount1) and it violates the unique index.

Please, suggest a solution.

You have to delete clientAccount1 itself, in addition to removing it from client.

Thank you for helping. For now I removed the unique index and made only interface verification. Of course, it is not the best solution...

I'll think for using your method...