SqlConnectionStringBuilder.LoadBalanceTimeout Property
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets the minimum time, in seconds, for the connection to live in the connection pool before being destroyed.
public:
property int LoadBalanceTimeout { int get(); void set(int value); };public int LoadBalanceTimeout { get; set; }member this.LoadBalanceTimeout : int with get, setPublic Property LoadBalanceTimeout As IntegerThe value of the LoadBalanceTimeout property, or 0 if none has been supplied.
This property corresponds to the "Load Balance Timeout" and "connection lifetime" keys within the connection string.
When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. This is useful in clustered configurations to force load balancing between a running server and a server just brought online.
A value of zero (0) causes pooled connections to have the maximum connection timeout.
| Produk | Versi |
|---|---|
| SqlClient .NET Core | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
| SqlClient .NET Framework | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
| SqlClient .NET Standard | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |