Description
[ Ссылка ]
c # Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Have you set the CommandTimeout ? .
If not set the CommmandTimeout (in seconds) check. Most of the times it should work.
The below URL gives you more information about CommandTimeout.
[ Ссылка ]
This property is the cumulative time-out (for all network packets that are read during the invocation of a method) for all network reads during command execution or processing of the results. A time-out can still occur after the first row is returned, and does not include user processing time, only network read time.
For example, with a 30 second time out, if Read requires two network packets, then it has 30 seconds to read both network packets. If you call Read again, it will have another 30 seconds to read any data that it requires.
#SQL How To #SQL timeout expired
