Manually set primary key

hansenm · **Joined:** Mon Oct 31, 2005 10:04 pm **Posts:** 5

For a part of my project, I need to load model data from XML files and save them out to the database (much like the test fixtures in Ruby on Rails). To properly create the object graphs, I have to manually specify the primary keys like this:

<Parent Id="1" ... />
<Child ParentId = "1" ... />

My models use sequences for the primary keys normally, so manually setting the primary key has no effect. Any ideas how I could bypass the key generation in this one instance?

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

hansenm,

Set the "generator" element of the "id" entry to "assigned"
(Reference documentation, 5.1.4.1. Generator).

mkb137 · **Joined:** Fri May 18, 2007 1:41 pm **Posts:** 8

use

Code:

session.Save( obj, id )

To save it with an assigned ID when the ID is normally auto generated.

hansenm · **Joined:** Mon Oct 31, 2005 10:04 pm **Posts:** 5

@gonzao_diaz: My goal was to do this without having to have separate hbm files for each situation. Everywhere else, my program uses the "native" generator.

@mkb137: Excellent! This worked great perfectly. I had tried the SaveOrUpdateCopy method without success, but I didn't see the overload of Save. Thanks a lot.