Float value retrieved wrong from database

Asked Feb 17 '15 at 12:37

Active Feb 17 '15 at 17:09

Viewed 348 times

I have a sql table. There is a float field in it. I made a model using entity framework wizard and it is represented as Double? in that model. Everything is fine to this point.

However when i retrieve value of that float field using linq to sql it gives me wrong value.

I write 0,06 to value of that float field using SQL Management Studio. But i get 0.059999999999999998 not 0,06

What is the reason. How can i correct it?

asked Feb 17 '15 at 12:37

MOD

1,070
3
19
41

3

http://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html – Paddy Feb 17 '15 at 12:39
2

If you need exact representation go for `decimal` – juergen d Feb 17 '15 at 12:40
you can have the same with decimal, you'll just have more decimal digits. It might be useful to use money data type – Dmitrij Kultasev Feb 17 '15 at 13:02

Float value retrieved wrong from database

0 Answers0