Richardo is correct. I've used RAW(16) before for Guid's in Oracle. Easy way to verify is to generate the schema from your mappings.
On Fri, Dec 23, 2016 at 11:19 AM, Felipe Oriani <[email protected]> wrote: > Ricardo, > > We have success implementing an IUserType but we are not sure what is the > best appoach. We will try using RAW(16). the problem is that Oracle > generates an GUID without "-", which is not the default for .Net. > > > > On Fri, Dec 23, 2016 at 12:33 PM, Ricardo Peres <[email protected]> wrote: > >> In Oracle, a GUID is defined as RAW(16). >> >> RP >> >> On Friday, December 23, 2016 at 12:22:24 PM UTC, Felipe Oriani wrote: >>> >>> Hi guys, >>> >>> We have a table on the database where we want to map the ID as Guid. Our >>> project should run over two databases, Sql Server and Oracle. For Sql >>> Server, we define the column type as *uniqueidentifier* and it works >>> fine. For Oracle, we try to define it as char(36), raw(36), varchar2(36) >>> but it does not work properly. >>> >>> After the commit of the transaction, NHibernate generate an ID different >>> what we have on the ID property of the model mapped. >>> >>> We are mapping it using Fluent NHibernate: >>> >>> Id(x => x.Id).Column("ID").GeneratedBy.GuidComb(); >>> >>> The question is, how can we map it on Oracle? What is the best column >>> dataType to define? Should we create an IUserType to map it? >>> >>> Thank you. >>> >>> >>> >>> >>> >>> -- >>> ______________________________________ >>> Felipe B Oriani >>> [email protected] >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > ______________________________________ > Felipe B Oriani > [email protected] > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/nhusers. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
