System.Data.SqlClient out of date
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 18.4k
- Forks
- 3.7k
- Avg merge
- 5h 8m
- Merged PRs (30d)
- 1
Description
Using the following code to return a single integer without a class defined - just an int.
using (var conn = new SqlConnection(connStr))
{
ret = await conn.ExecuteScalarAsync<int>(
"App.PointBalanceByID_Get",
param: new { MyID },
commandType: CommandType.StoredProcedure);
}
Returns the following error: System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SqlClient, Version=4.6.1.5, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified.
If I revert System.Data.SqlClient back to4.6.1 it works but the current version 4.8.5.
All other calls on 4.8.5 where I am mapping to a custom class seem to work fine.
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
Start by reproducing the shown ExecuteScalarAsync call with System.Data.SqlClient 4.8.5 and compare it with version 4.6.1. Investigate why this scalar path reports the missing assembly while mapped-class calls work, then verify that the call succeeds without FileNotFoundException on the current package version.
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
- 25/100