SQL insert with hilo + inheritance

Question

I would like to insert some data using plain sql into some tables that use hilo id generation in conjunction with nhibernate. Is this possible? I have found some similar questions but no definite answer yet. Thanks!

Chris

Answer 1

Sure you can do it. Just update the hi value in appropriate table and generate Id for inserts. Nhibernate won't validate ID's in DB.

unique key table is used only for inserts, and once object is in DB it doesn't matter anymore where its id came from