Just to insert "null records" in foreign tables. With "null records" I mean records with id= 0 and column values with null semantic (like really null values o descriptors like "N/A" or "Nothing")
Oscar 2009/1/11 Marco <[email protected]> > > Do you have sample how this could work? > > Thanks > Marco > > On 11 jan, 18:33, "Oscar Orduz Acosta" <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
