C # After the database is restored, an error occurs: Transport-level error has occurred when sending the request to the server.

When the database is restored and other operations are continued, the system runs an error: Transport-level error has occurred when sending the request to the server.

This is usually because SQL Server encounters some issues and has to refresh all the connections, but ado.net still thinks these connections are valid. In fact, they may be used in the process, some connections have long expired.

It seems that the problem lies in the SQL connection, and the expired connection affects normal refresh. Knowing the root cause of the problem, solving it is no problem.

After the database is restored, call the clearpoool method of the connection object to clear the connection pool that is invalid. You can also call sqlconnection. clearallpools () to clear all connection pools.

The problem is solved in this way.