I am a new user to dotConnect for Oracle, so I apologize if there is an obvious solution to this issue. My organization uses VARCHAR2(1) columns to represent boolean values, with the data being either a 'Y' for true or a 'N' for false.
When I use dotConnect with Entity Framework I would like to have these Y/N fields automatically translated to boolean on the model side. I don't want consumers of the entities to deal with this. What is the best way to resolve this? I see that dotConnect automagically converts Number(1) to boolean but it doesn't seem to do the same for VARCHAR booleans.
Thanks.
Booleans mapped to VARCHAR2 Y/N column
Take a look at our answer at StackOverflow:
http://stackoverflow.com/questions/2788 ... 11#2789411
As an example of the boolean wrapper, take a look at this post:
http://www.devart.com/forums/viewtopic.php?p=44654
http://stackoverflow.com/questions/2788 ... 11#2789411
As an example of the boolean wrapper, take a look at this post:
http://www.devart.com/forums/viewtopic.php?p=44654
Agreed. Having to patch every instance of a Y/N column with a wrapper property is not, in my mind, an extensibility point. It is a workaround. An extensibility point is if you allowed for custom converters to be added in to your driver so I could tell it that when it encounters my column, it can use my converter to massage from Y/N to bool and back again.