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 -~----------~----~----~----~------~----~------~--~---
