CODEWITHSUNDEEP
azure-sql-databaseazure-web-app-serviceentity-framework-coreazure-active-directoryazure-sql-server
Pratik Bhattacharya
Pratik Bhattacharya

Reputation: 3746

Connect to Azure SQL server via AAD Authentication using EF Core

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.

Upvotes: 4

Views: 2975

Answers (1)

Tom Sun
Tom Sun

Reputation: 24529

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

Upvotes: 3

Related Questions