Number(12) mapped to Double?
Number(12) mapped to Double?
Hello!
I wonder why Number(12) is mapped to Double? Shouldn't it be mapped to Int64?
I noticed that this applies for Number(10) and above up to Number(18) or something like that.
I also noticed that Number(1) maps to Int32. Shouldn't it be mapped to Int16?
We are using OraDirect v. 4.75.42 with Schema Modeller 1.0.22.0.
Regards
Anders
I wonder why Number(12) is mapped to Double? Shouldn't it be mapped to Int64?
I noticed that this applies for Number(10) and above up to Number(18) or something like that.
I also noticed that Number(1) maps to Int32. Shouldn't it be mapped to Int16?
We are using OraDirect v. 4.75.42 with Schema Modeller 1.0.22.0.
Regards
Anders
converting of type number
Hello,
We consider using the dotConnect provider, replacing Oracle.DataAccess.Client.
Doing some tests, i came up against the same problem:
NUMBER(10) is converted to double.
When are you doing something about that?
I'm using dotConnect for Oracle 5.20 Beta
We consider using the dotConnect provider, replacing Oracle.DataAccess.Client.
Doing some tests, i came up against the same problem:
NUMBER(10) is converted to double.
When are you doing something about that?
I'm using dotConnect for Oracle 5.20 Beta
The type mappings are defined by non-customizable Provider Manifest.
There are two alternatives at the moment.
The first one is to edit the standard .edmx model manually using XML Editor and set the type of the NUMBER(10) column to the value you like.
Instead of that you can use our Entity Developer visual tool to generate the .edml model and edit the Type property of the column.
There are two alternatives at the moment.
The first one is to edit the standard .edmx model manually using XML Editor and set the type of the NUMBER(10) column to the value you like.
Instead of that you can use our Entity Developer visual tool to generate the .edml model and edit the Type property of the column.
Code: Select all
da.FillSchema(table, SchemaType.Mapped);
table.Columns["Number_10_column"].DataType = System.Type.GetType("System.Int64");
No. Changing the types of each column manually would be painful. In addition i'm generating the DataTable by a RefCursor of a StoredProcedure, so i can't read the db-scheme and do the mapping by myself
Id would be sufficient, if you provide an event (or something) on the OracleDataAdapter class, where the type-mapping can be changed... Could this be a possible solution?
Id would be sufficient, if you provide an event (or something) on the OracleDataAdapter class, where the type-mapping can be changed... Could this be a possible solution?
I am in the process of evaluating dotConnect for Oracle as a possible LINQ provider for the company that I work for. In the process of doing so, I found this same issue.
In my case, I generated the data classes using the Devart Linq2SQL Generator UI tool, and .lqml file.
This seems to do the following conversion:
NUMBER(15,0) -> double
The standard Oracle ODP.NET driver would consider this a long (Int64).
I am using dotConnect v 5.35. Is there a way to change these mappings without manually changing it for every table and column in the mapping? We would be mapping hundreds of tables and procedures, so doing this by hand would basically be out of the question.
Thanks for any information.
In my case, I generated the data classes using the Devart Linq2SQL Generator UI tool, and .lqml file.
This seems to do the following conversion:
NUMBER(15,0) -> double
The standard Oracle ODP.NET driver would consider this a long (Int64).
I am using dotConnect v 5.35. Is there a way to change these mappings without manually changing it for every table and column in the mapping? We would be mapping hundreds of tables and procedures, so doing this by hand would basically be out of the question.
Thanks for any information.