Retrieving decimal value from db causing an issue.

This seems like an edge case. If the decimal value with precision more than 6 digits & the value is zero, it is unable to cast it.

Interestingly If the decimal value in the DB is anything other than zero, then it is working fine.

Note 1: With decimal value precision is <= 6 everything works fine.
Note 2: I had only one row in the table

Table Definition:

CREATE TABLE Table1
(
   Name varchar(20) NOT NULL,
   Rate decimal(7,7)
)

Table Data:

|Name|Rate|
|Mano|0|

When trying to fetch rows is failing.

var sql = "SELECT Name, Rate FROM Table1"
connection.Query<dynamic>(sql);

Exception

Error parsing column 2 (RATE=1 - Int16)
----> System.FormatException : Input string was not in a correct format.

In case of additional information please revert back!

Thanks!

Start by reproducing the failure with the shown Table1 definition, zero decimal(7,7) value, and Query(sql) call. Trace Dapper's result-column conversion from the failing RATE value and add a regression test for zero values with precision above six digits; done means the query returns successfully without the FormatException.