Are HiLo IDs unique across different tables?

Question

I have two different classes that map to two different database tables. IDs are created by NHibernate using the HiLo generator:

<generator class="hilo">
    <param name="table">uid</param>
    <param name="column">column</param>
</generator>

Are the IDs unique across both tables if I use the same table and column parameters for both mappings? If not, how can I achieve this?

score 1 · Accepted Answer · edited May 23 '17 at 11:59

1

NHibernate will distribute unique ids among all these tables, which use the same setting (table and column)

If we want to have different id rows/sets, we can use another param:

<param name="where">TableName='CmsLogin'</param>

see more here:

edited May 23 '17 at 11:59

Community

answered Dec 12 '15 at 13:58

Radim Köhler

1 Answers1