Is there a sample / documentation / any info on creating a custom type this fieldtype?
Thanks Marco On 12 jan, 15:55, Peter Lin <[email protected]> wrote: > one option is to create a custom type and use that in your mapping for > the specific column. > > not sure if you can assume zero is always null. if you can, have the > custom type convert all zero value to null. since I've always had to > integrate with legacy databases with ugly data, I feel your pain. > > peter > > On Jan 10, 1:54 pm, Marco <[email protected]> wrote: > > > I can't clean the Db, it's a legacy application that used by many > > users all over the world. > > > Can i conclude that's NHibernate doesn't support this (what is very > > logically, i totally agree that storing 0 instead of null is > > completely wrong..) > > > Thanks > > Marco > > > On 10 jan, 17:08, "Fabio Maulo" <[email protected]> wrote: > > > > Ok but write a value (0 zero) in that field was not so smart... for that > > > reason RDBMS have the concept of null and for the same reason we have > > > nullables values in .NET.Don't add FK but clean the DB. > > > > 2009/1/10 Marco <[email protected]> > > > > > I already added not-found="ignore" and that works, but NHiberbate > > > > still tries to fetch the record because CountryID = 0 and not > > > > CountryID = null.. I'm looking for a way to disable the lookup for ID > > > > = 0.. > > > > > ps. adding FK's are no option, because of the legacy application. > > > > > Thanks > > > > Marco > > > > > On 10 jan, 14:08, "Fabio Maulo" <[email protected]> wrote: > > > > > not-found="ignore" > > > > > That is what you are looking for but would be better to remove all > > > > invalid > > > > > values from DB and add a formal FK. > > > > > > 2009/1/10 Marco <[email protected]> > > > > > > > There's no foreign-key in the database, only in the documentation. > > > > > > (the foreign key is handled at application level and there's no > > > > > > external API available.) > > > > > > > Thanks > > > > > > Marco > > > > > > > On 10 jan, 13:21, "Fabio Maulo" <[email protected]> wrote: > > > > > > > 2009/1/10 Marco <[email protected]> > > > > > > > > > How can i instruct nhibernate to handle the number 0 as null > > > > > > > > for > > > > > > > > relations? > > > > > > > > How you can have that situation without a FK violation ?Which > > > > > > > RDBMS > > > > are > > > > > > you > > > > > > > using ? > > > > > > > -- > > > > > > > Fabio Maulo > > > > > > -- > > > > > Fabio Maulo > > > > -- > > > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
