I would like to make use of the Null Object pattern in my domain, but I don't want to have records in my database that relate to it - I would prefer it if NHibernate were able to map a SQL null value to my Null object, and vice versa.
Is this possible (using Fluent NHibernate for mappings)
P.S. This seems like it is a fairly common issue people are looking to resolve, but I wonder why I have struggled to find an answer.
Edit: Judging by this blog entry it doesn't look like it's going to be directly possible: NHibernate & Null Object Pattern: The Options