dotnetcore / dotnetcore/FreeSql

ACCESS数据库 BUG

Open
#2,276 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
4.4k
Forks
910
PR merge metrics
No merged PRs in 30d

Description

测试环境: c#, .net 4.0 framework, ACCESS数据库, FreeSql每个版本
var dict = new Dictionary
{
{ "id", 627 },
{ "yp_kc", 200 },
};

第1步测试正常:
runSql._iFreeSql.Ado.ExecuteNonQuery($"update yp_kcxxb set yp_kc={dict["yp_kc"]} where id=@id", dict);
第2步测试不正常, 更新不了yp_kc字段:
runSql._iFreeSql.Ado.ExecuteNonQuery($"update yp_kcxxb set yp_kc=@yp_kc where id=@id", dict);

感觉: @id有效, @yp_kc无效

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with Ado.ExecuteNonQuery and reproduce both update statements in the reported C#/.NET 4.0 and Access environment using the provided dictionary. Compare the handling of @id and @yp_kc in the parameterized statement; done means the parameterized update changes yp_kc as the interpolated version does.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
58/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.