In our Oracle (cough.. gag..) database, we are using a CHAR(1) to store boolean values (1 = true, 0 = false).I would like to have my business object take the CHAR(1) and convert it to a .NET bool, and then when I am saving back to the database, convert the .NET bool to a CHAR(1).
Is there a way to do that?
Cheers!