I just wonder after what duration .Net Sql Provider will close connection which is in pool?
开发者_JAVA百科Thanks, Pawel
The documentation does not specify how long connections in the connection pool stay open. The optimizer decides, and its algorithm might change between versions of ADO.NET (or maybe even Windows Update patches.)
You can control the maximum lifetime through a connection string setting:
Connection Lifetime=0
By default, it's 0, which means a connection can live as long as the optimizer thinks it's useful.
精彩评论