All, I know this isn't the "correct" way to do this but I need to know how to use HiLo and have the hilo table store a row for each entity in my system.
My reason for this is that I am migrating an existing DB that uses 32- bit integers with Identity over to NHibernate (currently 1.2 but we aim to upgrade to 2.1.x as well). Therefore I cannot use 64-bit numbers, I need to pre-seed the HiLo table and (annoyingly) some of the ID's have business meaning (apparently they didn't originally, but over time, now they do). I have ideas to sort that out but I'm stuck with the HiLo on 32-bit keys whch means sooner or later I'm going to hit a maximum value problem. We have a high volume database so I'd rather postpone that issue for as long as I can, so I don't want to use the same HiLo across all my entities unless there is a very good reason why I should.... I've read this thread http://groups.google.com/group/nhusers/browse_thread/thread/7c70df65e24a4034/a7585fd6e55b000f?lnk=gst&q=hilo+where+parameter#a7585fd6e55b000f but nobody actually answered the question the poster asked, i.e. How to you configure the mapping for a HiLo with a WHERE clause? I've tried google etc. and " NHibernate HiLo "Where parameter" " returns 2 pages none of which actually provide a concrete example. Has anyone ever actually done this? Can you provide a mapping please? Thanks
-- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
