Thank you Michael for help me. It´s works fine!
Better if exists a automatic way to do that on mapping my property. :) About the index column, is only for sorting asc or dec, but respecting the sequence returned values. Thank you again. Bruno. 2009/7/1 mhanney <[email protected]> > > > You could map it as an int and set the value explicitly using a sql > query. > > property = (int)session.CreateSQLQuery("SELECT YOUR_SEQUENCE.NEXTVAL > FROM DUAL").AddScalar("NEXTVAL", NHibernateUtil.Int32).UniqueResult > ()); > > .. and be sure to use transactions. > > If you don't want Oracle specific SQL in your C#, put the sql in your > mapping > > <sql-query name='SequenceNextValue'> > <return-scalar column='NEXTVAL' type='System.Int32'/> > SELECT YOUR_SEQUENCE.NEXTVAL FROM DUAL > </sql-query> > > Then call it with: > > property = (int)session.GetNamedQuery("SequenceNextValue").UniqueResult > (); > > What is the purpose of your 'index' column? You might want to look the > Version column instead. > > http://nhforge.org/blogs/nhibernate/archive/2009/04/15/nhibernate-mapping-concurrency.aspx > > c > > > On Jul 1, 10:37 am, brulimat <[email protected]> wrote: > > Hi guys! > > > > I have a question. > > > > My IDs are GUID but a specific property is an index column. > > This column uses Oracle´s Sequence. > > My question is: How to use a Oracle`s Sequence into a property? > > > > Sorry, but I´m a newbie. > > > > Thank you. > > > > Bruno. > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
