NUMBER(1) converted to boolean

[edstaffin]

Is this expected behaviour. I was expecting it to convert to an int32.
Am I missing something? I have to go into the lqml and manually change it.
Thanks ... Ed

[MariiaI]

Yes, mapping NUMBER(1) to boolean is the expected behaviour.
However, you can edit a set of predefined type mapping rules since 3.1.19 build of LinqConnect.

Please perform the following steps:
1) Open the 'Options' dialog box in Visual Studio (menu Tools|Entity Developer|Options)
2) Select the Oracle page in the Entity Developer -> Server Options
3) In the 'Type Mapping Rules' grid select the rule you want to edit and сlick 'Edit'
4) In the 'Type Mapping Rule Editor' change the required data in the available boxes and click OK to save your changes.

For more information please refer to http://www.devart.com/dotconnect/oracle ... pping.html and pay attention to corresponding article in the Entity Developer documentation (Common Concepts->Servers' Options->Type Mapping)

Please notify us about the results.

[edstaffin]

That explains a lot! Thanks for the pointer.
Ed

[MariiaI]

If you have any further questions, feel free to contact us.