Upgrading System.Data.Sqlclient from 4.8.5 to 4.8.6 and including Microsoft.Data.SqlClient 5.1.5 in the same project

Anonymous
2024-02-06T12:54:11.61+00:00

Does Upgrading System.Data.Sqlclient from 4.8.5 to 4.8.6 and including Microsoft.Data.SqlClient 5.1.5 in the dependencies of one of the project in my application has any impact?

Does Upgrading System.Data.Sqlclient from 4.8.5 to 4.8.6 and including Microsoft.Data.SqlClient 5.1.5 in the dependencies of one of the project in my application has any impact?

Because we were not getting this error before(pasted below) I checked in code , there is only string , no int. After deploying this to prod, error log is coming like this. But the surprise is in stage also I deployed the same, but no error.

Error:Person--4, 0, 4---Conversion failed when converting the nvarchar value 'Resignation' to data type int.
--Stack:   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task`1 result)    
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()    
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location ---    
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location ---    
at Datadog.Trace.ClrProfiler.CallTarget.Handlers.Continuations.TaskContinuationGenerator`4.SyncCallbackHandler.ContinuationAction(Task`1 previousTask, TTarget target, CallTargetState state) in /project/tracer/src/Datadog.Trace/ClrProfiler/CallTarget/Handlers/Continuations/TaskContinuationGenerator`1.cs:line 136    
at Dapper.SqlMapper.QueryAsync[T] in /_/Dapper/SqlMapper.Async.cs:line 418    
at Accenture.HRSS.JPAS.Web.Controllers.ReportController.GenerateReport(ReportParameter cmd) in /app/Accenture.HRSS.JPAS.Web/Controllers/ReportController.cs:line 211
SQL Server | Other
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.