I don't know if this is relevant but, you use the null-value pattern and insert "null records" in foreign tables with id = 0?, may be it can works ... Oscar
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 > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
