Help to Resolve Timeout Issue While Updating 20,000 Records Using SQL Server and Entity Framework
Hi everyone,
I'm working on a project where I need to update around 20,000 records in SQL Server using the ExecuteSqlRawAsync method in Entity Framework. However, I keep encountering a timeout error, even when I increase the command timeout duration.
I've already tried adjusting the timeout value, but it doesn't seem to resolve the issue. Here's what I've done so far:
Increased the command timeout using the CommandTimeout property.
Tried batching the updates, but still facing issues.
Has anyone faced a similar issue with ExecuteSqlRawAsync or with large-scale updates in SQL Server? If so, what solutions or optimizations did you implement to fix the problem?
Any advice or suggestions would be greatly appreciated!
Thanks in advance!
I'm working on a project where I need to update around 20,000 records in SQL Server using the ExecuteSqlRawAsync method in Entity Framework. However, I keep encountering a timeout error, even when I increase the command timeout duration.
I've already tried adjusting the timeout value, but it doesn't seem to resolve the issue. Here's what I've done so far:
Increased the command timeout using the CommandTimeout property.
Tried batching the updates, but still facing issues.
Has anyone faced a similar issue with ExecuteSqlRawAsync or with large-scale updates in SQL Server? If so, what solutions or optimizations did you implement to fix the problem?
Any advice or suggestions would be greatly appreciated!
Thanks in advance!
