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.

Reply via email to