How to map a varchar2 column in Oracle 10g to a boolean field in C# Object.

Need this to work in both the cases - Data Retrieval and Updates.

Scenario:

Fetch all employees from tbl_employees

tbl_employees

Column Name Type
Id - Number
EmpName Varchar2
IsActive Varchar2(1) (Y / N)

Employee Object

public bool IsActive{
get { return isActive; }
set { isActive = value; }
}


Data Retrieval - Expecting true in IsActive if the database column has a value of 'Y' and vice-versa

Update - Expecting database column to be updated with 'Y' when IsActive has a value of true, vice- versa.


Thanks for all the help