Map Oracle Number to CLR double
Posted: 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?
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?