Hi I am developing an application with NH and Sql Server. I have decided to go with the method of creating the database structure myself then map with NH afterwards. I am a relative newbie to NH and I have a question please.
Traditionally when creating a database structure I use foreign keys to maintain referential integrity. In the cases where there is a one to one table mapping which is nullable, I have in the past created a dummy zero ID row on the lookup table. The reason that I have done this is because I have seen that left join queries were not as performant as full joins. i am keen to improve and interested to get some advice for whether i should pursue this again with my new database structure which would mean getting NH to ignore zero ID's globally upon selects somehow. i suspect this could be fraught with danger when using NH and perhaps i am better taking an alternative route with the database. any advice very appreciated thanks. -- 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.
