Use Azure AD Integrated Authentication to connect Azure SQL database

Question

I can use the Azure AD Integrated Authentication to connect a Azure SQL Database by using the following connection string:

<add name="MyConn" connectionString="Data Source=xxxx.database.windows.net;Initial Catalog=xxxx;Persist Security Info=false;MultipleActiveResultSets=True;TrustServerCertificate=False;Authentication="Active Directory Integrated"" providerName="System.Data.SqlClient" />

My question:

When doing this, is the Azure Active Directory Authentication Library (ADAL) being used behind the scene?

I need to get a definite answer because ADAL is going to be deprecated soon.

https://learn.microsoft.com/en-us/azure/active-directory/develop/msal-migration

Answer 1

System.Data.SqlClient uses the Azure Active Directory Authentication Library (ADAL), which will be deprecated. If you're using the System.Data.SqlClient namespace for Azure Active Directory authentication, migrate applications to Microsoft.Data.SqlClient and the Microsoft Authentication Library (MSAL). For more information about using Azure AD authentication with SqlClient, see Using Azure Active Directory authentication with SqlClient.

SSMS and SSDT still uses the Azure Active Directory Authentication Library (ADAL).