Mapping Oracle bool fields with nHibernate

Question

I have an Oracle database and the boolean fields are CHAR(1) with Y/N stored. How can I map this to a bool type using nHibernate?

Answer 1

Set type="YesNo" in the nhibernate property definition for the field.

For more info, see table 5.3 in this doc which maps .NET types, to DB types.