Map Oracle Number to CLR double

[DavidBrower]

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]

Is there any way to do this?

[Shalex]

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?