DapperLib/Dapper

Error: System.Data.DataException: Error parsing column 15 (QUANTITY=<null>)

Opened this issue · 0 comments

We encountered a problem, few place "Error parsing column" exception occurs when executing the function which in turn returns data from view.

This is db schema of view in Oracle DB for QUANTITY is defined as :
Name : QUANTITY , Type:Number, Nullable : Y

QUANTITY field contains values like 2.5, 1, 3.3.33333333333333, 250012.666666667, 1.66666666666667

And in C# model Quantity is defined as :
public decimal? Quantity { get; set; }

It's not throwing error when QUANTITY values are like 2.5, 1 but throws error for 3.3.33333333333333, 250012.666666667, 1.66666666666667 values.

@mgravell : Can you help us understand why the issue is occurring ?