Hello!
I have a field named PRD_STATUS of type VARCHAR2 on a table on one database. I cannot change this database but I must use it. This field only takes two different values: 'A' and 'B'.
On my system, the class that represents this table has a property named Status but it is of type Boolean, so I should map A to true and B to false. Is there any way I can do this?

My actual mapping looks like the following, although it obviously doesn't work:

<property name="Status" column="PRD_STATUS" type="Boolean" not-null="false" />

Note: I cannot change the class definition neither. Thanks!

There is a type in NHibernate that does something similar to this called NHibernate.Type.YesNoType that maps a boolean value to a Y/N in the database. You could use this class (from the source) as a template to build your own. It looks like you just have to override a few properties on the CharBooleanType to accomplish what you need. This code might even work (I just modified YesNoType).



Once you have your class built, just reference it from the mapping file.


Good luck,
-jason