Page 1 of 1
Number Mapping for Oracle NUMBER type
Posted: Thu 29 Dec 2011 09:31
by melyurt
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
Posted: Wed 04 Jan 2012 15:54
by StanislavK
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.
Posted: Mon 16 Jan 2012 08:23
by StanislavK
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
Posted: Thu 26 Jan 2012 12:53
by melyurt
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]
Posted: Mon 30 Jan 2012 12:08
by Shalex
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.
Posted: Mon 06 Feb 2012 14:59
by Shalex
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.
Posted: Fri 10 Feb 2012 12:34
by Shalex
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 .