Mapping a boolean field to char in nhibernate

When you work with legacy database is not infrequent that boolean value are mapped to char(1) field in databse, with Y/N or 0/1 or some other chars. In the literature there are a lot of solution, you can find for example a discussion here. When you use a user type to handle this kind of situation when you build HQL query you cannot use true or false in condition, for example

Select o from Orders where o.IsProcessed = false

This usually lead to a SQL error because you are trying to compare a char(1) column with the value false. The solution is to use this setting in the setting file.

<add key="hibernate.query.substitutions" value="true 1, false 0" />

This permits to substitue the value true with the literal 1 and false with the literal 0,  but you can use whatever constant you want.

Alk.

Tags: NHibernate Boolean To Char Mapping