Number Mapping for Oracle NUMBER type

melyurt · Post by **melyurt** » Thu 29 Dec 2011 09:31

Hi,
How can I map oracle NUMBER column to Int32 for Entity Framework Data Model Wizard.

I tried that ones,
Integer(29) to Int32
Number(38) to Int32

StanislavK · Post by **StanislavK** » Wed 04 Jan 2012 15:54

Thank you for your report, this appears to be a problem of dotConnect for Oracle. The proper rule for the NUMBER data type with no precision and scale should be Number(38,38). We will inform you when this issue is fixed.

StanislavK · Post by **StanislavK** » Mon 16 Jan 2012 08:23

We have fixed the issue. Now it should be possible to change the default mapping for NUMBER with no precision and scale. To do so, you can set a number mapping rule for NUMBER(38).

The fix is available in the latest 6.60.283 build of dotConnect for Oracle. The new build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (for users with active subscription only).

For the detailed information about the fixes and improvements available in dotConnect for Oracle 6.60.283, please refer to
http://www.devart.com/forums/viewtopic.php?t=23129

melyurt · Post by **melyurt** » Thu 26 Jan 2012 12:53

Thanks for fix.

But I have exception when defining number mapping
in Turkish regional settings.

There is an exception like:

String '(NUMBER,38,38,System.Int32)' was not recognized as a valid OracleNumberMapping.

[/url]

Shalex · Post by **Shalex** » Mon 30 Jan 2012 12:08

We have reproduced the following error using "Number Mappings=(NUMBER,38,38,System.Int32);" connection string parameter (it persists only with Turkish regional settings):
"String '(NUMBER, 38, 38, System.Int32)' was not recognized as a valid OracleNumberMapping. There is an unknown value type 'System.Int32'. Value type can be only 'System.SByte', 'System.Byte', 'System.Int16', 'System.Int32', 'System.Int64', 'System.UInt16', 'System.UInt32', 'System.UInt64', 'System.Single', 'System.Double', 'System.Decimal', or 'System.Boolean'."

We will notify you when the issue is fixed.

Shalex · Post by **Shalex** » Mon 06 Feb 2012 14:59

The bug with parsing value of the OracleNumberMappings connection string parameter for some languages of system locale is fixed. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Shalex · Post by **Shalex** » Fri 10 Feb 2012 12:34

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