Devart Forums

Hi there,

I'd like to save my boolean fields as CHAR(1) datatype using following idea:
'Y' is for true, 'N' for false or as NUMBER(1) datatype with 1 or 0.

However LINQ to Oracle SQL is always trying to insert full-text sting 'False' and 'True'.

How to achieve my mapping logic?

Thank you in advance,
Lex

I recommend you to create a wrapper boolean property for this column, like I advised in this post:
http://www.devart.com/forums/viewtopic.php?p=54625

Wrapping is not good, because you'll not be able to use this property in selects...

I have replied to you here:
http://www.devart.com/forums/viewtopic.php?p=55470
NUMBER(1) mapping to bool should do the trick.