Database data type float to C # type decimal, float data Type conversion Invalid _ Practical tips

There was a sudden error in running the system today, the data type conversion was invalid, the error was in the System.data.sqlclient.get_decimal () method, and the initial estimate was that the float type of the database was converted to the decimal type of C #. The entity class uses a decimal type, thinking that even if the value in the database is empty, there is no conversion error.

A variety of online search, many people encounter a similar situation, most of the direct go to float type when the error, such as (float) dr[0], then see that there is said should be converted into a double, and then in the conversion to float on it



Try changing the decimal type of the entity class to double? type, OK.