Conversion between SQL Real and .NET double

Question

I have a column in a T-SQL database that consists of real values, but when I convert it to double I get something different than what was stored.

For example, I pick one row which has 1.15 stored. When I convert it with:

Convert.ToDouble(reader["VAT"]);

I get:

1,14999997615814

Why? And how do I convert a real to double and recieve the same value?

http://stackoverflow.com/questions/618535/what-is-the-difference-between-decimal-float-and-double-in-net — gsharp, Jul 17 '14 at 09:10

score 2 · Accepted Answer · answered Jul 17 '14 at 10:08

Try to change the data type of your column from real to float. If you visit this link, you will notice that float SQL Server data type maps to Double, Nullable<Double> CLR types. On the other hand, real SQL Server data type maps to Single, Nullable<Single> CLR types. I suspect that's your problem.

Conversion between SQL Real and .NET double

1 Answers1