What is alternative of "TransparentNetworkIPResolution" in ASP.NET CORE

Viewed 1742

I have used "TransparentNetworkIPResolution" this keyword in ASP.NET MVC in SQL Connection string. My code as below

<add name="LocalString" connectionString="Data Source=Server;Initial Catalog=LocalDBName;User ID=User;Password=****;TransparentNetworkIPResolution=false" providerName="System.Data.SqlClient" />

This is giving me an error ASP.NET CORE error message "Keyword doesn't support".

So can anyone help me to resolve this?

1 Answers

Focus on new SqlClient features an improvements is moving to the new Microsoft.Data.SqlClient package

Please see https://github.com/dotnet/SqlClient/issues/99

Github repo for SqlClient package is: https://github.com/dotnet/SqlClient

To reflect the current state of the API, here is a list of classes, enums and members that exists in .NET Framework on System.Data.SqlClient and that are missing in .NET Core's version of Microsoft.Data.SqlClient:

Class SqlDataSourceEnumerator       
Class SqlAuthenticationInitializer      
Class SqlAuthenticationParameters       
Class SqlAuthenticationProvider     
Class SqlAuthenticationToken        
Class SqlClientLogger       
Class SQLDebugging       
Enum    SqlAuthenticationMethod 

Property    SqlBulkCopyOptions  AllowEncryptedValueModifications    
Property    SqlCommand  NotificationAutoEnlist  
Property    SqlConnectionStringBuilder  AsynchronousProcessing  
Property    SqlConnectionStringBuilder  Authentication  
Property    SqlConnectionStringBuilder  NetworkLibrary  
Property    SqlConnectionStringBuilder  TransparentNetworkIPResolution  
Property    SqlParameterCollection  IsSynchonized
Related