SQLServer float
and C#/VB double
have the same representation. This is the correct mapping. What you don’t want to do is map SQL Server float
to C#/VB float
as that may involve a loss of precision. SQL Server real
maps onto C#/VB float
.
T-SQL float and real type definitions can be found at MSDN. C# double definition can be found at MSDN as well, as can the float definition.