Hi guys,

I have a table in SQL Server 2000 that, besides the PK identity column, has another column that must be a unique bigint. This new column must behave similar to PK identity column.

SQL Server does not allow multiple identity columns so for this column I will use a separate table that will store the next available value (similar to hilo)

My question is:

Can NHibernate automatically manage the value from the sequence table, i.e. read it and increment it in the same transaction that inserts my business object?

I know NHibernate can do this for id columns (<generator class="hilo"...) but a <generator> tag cannot be specified inside a <property> tag.

Thanks!