Get data from Sqlserver(Type float) to double C#

Question

When I get data from SQL server to EntityFramework C#. My SQL server has column:

Mycolumn(float, not null)(8 byte);

C# model mapping:

public double MyColumn {get; set;}.

The SQL server saves data: 1.8(float, not null), and when I get it with dapper or EntityFramework, the column C# return 1.79999995231628. I don't understand.

Can who help me get that = 1.8 in C#. Thank you very much and have a nice day.

lovenco

This is what happens when you use floating point values. Why not use a precise data type instead? Or do you actually need floating point values? — Thom A
– Thom A ♦, Commented Jul 23, 2021 at 12:45
Does this answer your question? Is floating point math broken? — Charlieface
– Charlieface, Commented Jul 23, 2021 at 13:52

Misha Zaslavsky · Accepted Answer · 2021-07-23 12:49:13Z

2

You need to use Decimal data type in SQL Server which is precise.

2 Comments

Nguyen Lam Over a year ago

has the decimal data type in SQL Server resource consuming with float ? Thank for your confirm.

Misha Zaslavsky Over a year ago

@NguyenLam Read the answer of Iman and you will find the answer to this question + more. stackoverflow.com/questions/1056323/…

Collectives™ on Stack Overflow

Get data from Sqlserver(Type float) to double C#

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related