SqlConnectionStringBuilder.TransparentNetworkIPResolution Property
Definition
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.
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.
public:
property bool TransparentNetworkIPResolution { bool get(); void set(bool value); };
public bool TransparentNetworkIPResolution { get; set; }
member this.TransparentNetworkIPResolution : bool with get, set
Public Property TransparentNetworkIPResolution As Boolean
Property Value
A boolean value.
Remarks
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
.