Number Mapping for Oracle NUMBER type

Number Mapping for Oracle NUMBER type

Postby 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
melyurt
 
Posts: 5
Joined: Sat 26 Mar 2011 23:00

Postby 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
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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]
melyurt
 
Posts: 5
Joined: Sat 26 Mar 2011 23:00

Postby 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
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Postby 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
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Postby 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 .
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle