1) you don't need a custom user type (a DateTime had a value)2) you don't need a custom user type (assign string.Empty to the property in the Ctor) 3) Alleluia!!! a DBA accepting HighLow 4) here you really need to do something. Zero is a value and even if you can use not-found="ignore" NH will try to get it before ignore (mean an additional SELECT)... in my mind no relation mean no value... but you know I'm not a DBA or, at least, I'm an ORM-oriented guy.
Try to convert it http://www.agiledata.org/essays/dbaSkills.html 2009/5/26 allan.ritc...@gmail.com <allan.ritc...@gmail.com> > > I work with an extremely difficult SQL Server DBA that hates anything/ > everything that is not a stored procedure. However, he's started > coming around and but has still placed the following constraints. > > 1) Dates must be small datetime and NON-nullable. Nullable dates are > equal to 1900/1/1. Easy enough to get around with a nh usertype for > querying and persistence. > 2) Strings/VARCHAR must be non-nullable. Also very solvable via empty > string nh user type. > 3) Idents are evil and will not be used. Easy to get around with > hilo. > 4) Now for the tough part which is where my question is. All > associations that are NULLABLE actually link to a "placeholder" record > with ID 0. What would the community guys recommend? That I override > the ManyToOne and OneToMany types to deal with this or do you have a > better suggestion? > > I have used NHibernate for several years now without ever so much as a > blip of a problem. NHibernate is an ideal tool for the company I'm > with now assuming I can get around these DBA related issues. Has > anyone ever heard of some of these bizarre requirements and how did > you deal with them? > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---