Our database has a sequence for every table. How do I tell NH to use those sequences?

Regards Morten

<class ...>
<id ...>
<generator class="sequence">
<param name="sequence">name.of.your.sequence</param>
</generator>
</id>
<!-- other properties -->
</class>

It's in the docs.

I'm using similar mapping for oracle sequences, and I'm finding that the primary keys are getting incremented twice. Has anyone else ran into this?

thanks,

s

I ported a ms sql server database over to oracle using the oracle WorkBench tool. It automatically generates triggers, which call your sequence on inserts. So both the trigger and nhibernate were incrementing the sequence value. I removed the triggers and all is well. There is a similar "oracle trigger" post on this forum...but, I missed it earlier.