I too need the trigger-identity functionality but for Firebird in my case.
On Mar 10, 10:58 pm, smith2martin <[email protected]> wrote: > I'm using AR latest and Oracle9Dialect with a trigger on my table for > sequence-generated IDs. > > NH2.1.0 has added a newtrigger-identitygenerator which provides the > ability to return the value of a POID generated by a sequence called > from a trigger fired upon insert. In my case, I can't drop / modify > the existing insert trigger since it's used by others. Also, the > trigger does more than just ID generation. > > Has anyone come up with a nice way to replicate this functionality > with AR latest? Looking for any and all ideas. Otherwise, has anyone > had success using another generation strategy to accomplish the same? > Native and Assigned both work, but I need the generated ID returned > from the INSERT in order to refresh my object. > > Also, any idea if future releases of AR will support this > functionality? > > Quote: > > The “trigger-identity” is a NHibernate specific feature where the POID > is generated by the RDBMS at the INSERT query trough a BEFORE INSERT > trigger. In this case you can use any supported type, including custom > type, with the limitation of “single-column” (so far). > > The query in ORACLE is: > > INSERT INTO my_entity (Name) VALUES (:p0) returning Id > into :nhIdOutParam > > Thanks. > martin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
