Devart Forums

Hello guys.. first of all.. my english is not good.. its a ***

Well, im using Devart dotConnect for Oracle + Linq to Entity, .NET 3.5.

I just created my entitys.. from the database already created and populated (the system is from an old client). Everything was goin good until i faced this problem. i have a lot of number(1) in the database schema. Its the mostly of times is a kind of situation from that object.. like Cliente - Situation.

I tried to config manually the edml, csdl, ssdl. but it still throws a problem saying that Devart.Data.Oracle.bool isn't compatible.

ill keep trying here.. and sorry again my english.

help!! PLZ!

is the only way to solve it change those number(1) to varchar2(1) ?
there's no kind of settings that i can config ?!

Are you using ADO.NET Entity Data Model (*.edmx) or Devart Entity Model (*.edml)?

*.edmx -> You can set the "Number Mappings = (Integer, 1, 1, System.Int32)" connection string parameter:
http://www.devart.com/dotconnect/oracle ... tring.html

*.edml -> The Number Mappings support will be implemented starting from the next version (not build) of Entity Developer.

I was trying to manually config it in the .ssdl file.. but failed.

i just changed the bool's propertys to int in my Diagram Layer -> Model Explorer -> Store. And changed on by one..

but.. i still want to know where i can config the Entity Framework to translate number(1) to int, not bool

Jaime Yule wrote:but.. i still want to know where i can config the Entity Framework to translate number(1) to int, not bool

The Number Mappings support will be implemented starting from the next version (not build) of Entity Developer (the *.edml models). We will post here when the corresponding build of dotConnect for Oracle is available for download.

New version of dotConnect for Oracle 6.60 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22836 .

Interesting behavior (NUMBER(1) --> bool). What is the idea behind it? I guess it is necessary because Oracle doesn't support a native BIT type as MS-SQL does?

Yes, this is correct.
Here is a default mapping: http://www.devart.com/dotconnect/oracle ... pping.html
If necessary, you can change default mapping:
1) via the Tools > Options > Servers' Options > Oracle menu (for Entity Developer)
2) using the "Number Mappings = (Integer, 1, 1, System.Int32)" connection string parameter (for EDM Wizard)