Map Oracle Number to CLR double

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
DavidBrower
Posts: 4
Joined: Tue 10 May 2016 14:20

Map Oracle Number to CLR double

Post by DavidBrower » Tue 17 May 2016 09:31

We have been using Entity Developer to generate POCOs from an Oracle database and then using these POCOs to create tables in SQL Server. However, I notice that we are losing some precision with some of the numbers that have an unqualified NUMBER type.

Looking at https://msdn.microsoft.com/en-GB/library/ms151817.aspx I can see that NUMBER maps to float and not decimal and that, therefore, the POCO property should be a double and not a decimal.

Is there some to specify that an unqualified NUMBER should map to a CLR double?

DavidBrower
Posts: 4
Joined: Tue 10 May 2016 14:20

Re: Map Oracle Number to CLR double

Post by DavidBrower » Wed 18 May 2016 09:50

Is there any way to do this?

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Map Oracle Number to CLR double

Post by Shalex » Wed 18 May 2016 13:54

Please change a predefined mapping for the Database First approach via the Tools > Entity Developer > Options menu of Visual Studio. After the change, the new mapping will be applied for the newly created models. Does this help?

Post Reply