An hourly recurring job runs in my MVC 5 internet application that I'm currently developing. This task uses the DbContext class to update various model objects. The program is made available as an Azure website.
I encounter the next error every few hours:
System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) ---> System.ComponentModel.Win32Exception (0x80004005): The semaphore timeout period has expired
Why is that so? How can I stop this from happening, too?
I appreciate it.
Essentially, SQL server is just reporting an error that the network layer is throwing.