If I have the following mapping files...

<class name="Address">
<id name="Id" column="addressId">
<generator class="assigned" />
</id>
</class>

<class name="Company">
<id name="Id" column="companyId">
<generator class="assigned" />
</id>

<property name="Name" column="[name]" type="String" />

<many-to-one name="Address" class="Address" column="addressId" not-null="true" cascade="all" />
</class>


And I try the following...

Address address = new Address();

Company company = new Company();
company.Name = "Some Company";

company.Address = address;

company.Save();


When I call company.Save() it gives me back a foreign key constraint error because the address hasn't been saved to the database yet. How do I get it to cascade the saving of the address first and then the company?


Any help would be greatly appreciated!

Thanks,
Stephen

I've found the solution, not sure it's the best choice, but it seems to be working pretty well. I was called .Save( obj ). When I changed it to SaveOrUpdate( obj ) it started producing the correct order of sql inserts/updates.