SqlConnectionStringBuilder::TransparentNetworkIPResolution Property
When the value of this key is set to true, the application is required to retrieve all IP addresses for a particular DNS entry and attempt to connect with the first one in the list. If the connection is not established within 0.5 seconds, the application will try to connect to all others in parallel. When the first answers, the application will establish the connection with the respondent IP address.
Assembly: System.Data (in System.Data.dll)
public: property bool TransparentNetworkIPResolution { bool get(); void set(bool value); }
If the MultiSubnetFailover key is set to true, TransparentNetworkIPResolution is ignored.
If the Failover Partner key is set, TransparentNetworkIPResolution is ignored.
The value of this key must be true, false, yes, or no.
A value of yes is treated the same as a value of true.
A value of no is treated the same as a value of false.
This key defaults to false when:
Connecting to Azure SQL Database where the data source ends with:
.database.chinacloudapi.cn
.database.usgovcloudapi.net
.database.cloudapi.de
.database.windows.net
Authentication is 'Active Directory Password' or 'Active Directory Integrated'
Otherwise it defaults to true.
Available since 4.6.1