DapperLib / DapperLib/Dapper

Error parsing column

Open
#910 5 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

db:oracle
Dominant language
C#
Stars
18.4k
Forks
3.7k
Avg merge
5h 8m
Merged PRs (30d)
1

Description

Error parsing column 35 (DELETIONSTATECODE=2017-10-27 03:27:40 - DateTime) 在 Dapper.SqlMapper.ThrowDataException(Exception ex, Int32 index, IDataReader reader, Object value)
在 Deserializeaa7492ef-563f-4451-8cd2-a5d5f61a9f48(IDataReader )
在 Dapper.SqlMapper.d__1251.MoveNext() 在 System.Collections.Generic.List1..ctor(IEnumerable1 collection) 在 System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
在 Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable1 commandTimeout, Nullable1 commandType)

in my Database table :
image
"DELETIONSTATECODE" => " NUMBER(1) " not " DateTime "

my code:
var conn= new System.Data.OracleClient.OracleConnection(connString);
conn.Open();
var result = conn.Query<T>(sql, param)

Why does this happen? There are often similar cases。Expected reply!thankyou very much!

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the reported Dapper.SqlMapper.ThrowDataException stack trace and inspect column 35, DELETIONSTATECODE, alongside the mapped type T and the Oracle table definition shown in the issue. A useful follow-up should explain the type-mapping behavior or provide a minimal reproducible case that confirms the cause.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
backend, database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.