DapperLib / DapperLib/Dapper

C# Guid to Oracle blob throw the System.ArgumentException:value does not fall within the expected range

Open
#633 13 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

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

Description

   在 Oracle.ManagedDataAccess.Client.OracleParameter.set_DbType(DbType value)
   在 ParamInfo4292f180-6c8f-40d8-9d00-382a91f8abc2(IDbCommand , Object )
   在 Dapper.CommandDefinition.SetupCommand(IDbConnection cnn, Action`2 paramReader) 位置 D:\Dev\dapper-dot-net\Dapper NET40\SqlMapper.cs:行号 191
   在 Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) 位置 D:\Dev\dapper-dot-net\Dapper NET40\SqlMapper.cs:行号 3395
   在 Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) 位置 D:\Dev\dapper-dot-net\Dapper NET40\SqlMapper.cs:行号 1346
   在 Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) 位置 D:\Dev\dapper-dot-net\Dapper NET40\SqlMapper.cs:行号 1221
   在 AiDiEr.ServicesTest.UnitServiceTest.TestGuid2Blob() 位置 F:\Git\IdealAPP\idr_shoppers_app\idr_shoppers_app\IdealShopApp\AiDiEr.ServicesTest\UnitServiceTest.cs:行号 149

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 parameter setup in Dapper NET40/SqlMapper.cs at line 191 and reproduce the failure from AiDiEr.ServicesTest/UnitServiceTest.cs at line 149 using Oracle.ManagedDataAccess.Client. Trace how the Guid-to-Blob parameter is assigned and determine the supported behavior; done when the issue has a documented resolution or a verified fix with a regression test.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 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.