Hi

I use NHibernate 1.2.0.2003
SQLite ADO 1.0.39.1
MySQL ADO 1.0.3.31712

I want to copy Users Objects and their related Objects from MySQL to SQLite.

I have a table Users, Users_Has_Credential and Credential.

Users<------>Users_Has_Credential<-------->Credential

If I build 'by hand' a User with one Credential , the User and the Credential records are created in my SQLite database and the Users_Has_Credential is filled with the two IDs.

If I read in MySQL a User with one Credential and write it in SQLite, the User and the Credential records are created in my SQLite database but the Users_Has_Credential is not filled.

No 'INSERT INTO' SQL order is issued for the Users_Has_Credential table.

I use the 'assigned' generator for SQLite coz it does not accept 'native', so the IDs does not change.

How can I oblige NHibernate to fill the join table ?

Thanks!

My problem is solved using Replicate instead of Save.

The tables and also the relationship are created.