SqlConnectionStringBuilder.TransparentNetworkIPResolution Property

  • Reference

Definition

Namespace:
Microsoft.Data.SqlClient
Assembly:
Microsoft.Data.SqlClient.dll
Package:
Microsoft.Data.SqlClient v1.0.19269.1
Package:
Microsoft.Data.SqlClient v1.1.4
Package:
Microsoft.Data.SqlClient v2.0.1
Package:
Microsoft.Data.SqlClient v2.1.4
Package:
Microsoft.Data.SqlClient v3.0.1
Package:
Microsoft.Data.SqlClient v3.1.0
Package:
Microsoft.Data.SqlClient v4.0.1
Package:
Microsoft.Data.SqlClient v4.1.0
Package:
Microsoft.Data.SqlClient v5.1.0
Package:
Microsoft.Data.SqlClient v5.2.0

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

Boolean

A boolean value.

Remarks

If the Multi Subnet Failover key is set to true, Transparent Network IP Resolution is ignored.

If the Failover Partner key is set, Transparent Network IP Resolution 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.

Applies to