Azure SQL servers support AAD authentication, and I want my applications to connect to SQL server using AAD authentication and not SQL server admin credentials. I am using EF core to connect to SQL, how do I enable EF Core to use AAD authentication.
My application is deployed in Azure App Service and it has MSI extension enabled, so I am looking forward to using Microsoft.Azure.Services.AppAuthentication for getting the token from AAD.
Connect to Azure SQL server via AAD Authentication using EF Core
If your project platform is .netcore, it is not supported currently. I also find the issue on the github.
Or you could refer to this blog or another SO thread.
so I am looking forward to using Microsoft.Azure.Services.AppAuthentication for getting the token from AAD
You could get the demo code from the document You could get the demo code from the document
var azureServiceTokenProvider = new AzureServiceTokenProvider();
string accessToken = await azureServiceTokenProvider.GetAccessTokenAsync("https://management.azure.com/").ConfigureAwait(false);
Update:
Thanks for AlejandroC sharing, it is supported in .NET Core 2.2 Preview 1, for more information please refer .NET Core 2.2 Preview 1 - August 22, 2018
