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.
