yes. that is a guid in Oracle. Here's a bunch of info about Guid formatting between Oracle and .net
http://stackoverflow.com/questions/7289734/convert-from-oracles-raw16-to-nets-guid I guess my bigger question is why does it matter. if this is a PK and FK in the database, why does the formatting matter? are you showing this to users? I'm using mapping by code. this code is equivalent to yours Id(x => x.Id, map => { map.Column("Id"); map.Generator(Generators.GuidComb); }); On Fri, Dec 23, 2016 at 11:27 AM, Felipe Oriani <[email protected]> wrote: > Fran, how have you mapped it? > > We are using fluent nhibernate and we try this: > > Id(x => x.Id).Column("ID").GeneratedBy.GuidComb(); > > it is not working. In the Oracle it is generating a key like this: " > D3CCAC3449579D4EB7FAA6E500ECC5A0" > > > > On Fri, Dec 23, 2016 at 2:20 PM, Fran Knebels <[email protected]> wrote: > >> 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. >> > > > > -- > ______________________________________ > 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.
