Error: System.Data.DataException: Error parsing column 15 (QUANTITY=<null>)
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 18.4k
- Forks
- 3.7k
- Avg merge
- 5h 8m
- Merged PRs (30d)
- 1
Description
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 ?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No repository file or test is named. Start by reproducing the Oracle view result with the listed QUANTITY values and the C# decimal? property, then inspect the value returned for column 15 and Dapper’s mapping path; done means the parsing cause is established with a minimal reproduction or validated test.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 28/100