dotnetcore / dotnetcore/FreeSql
ACCESS数据库 BUG
- 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