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
Number Mapping for Oracle NUMBER type
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
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
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
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.
"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.
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 .
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 .