Connect to Azure SQL Database using access token in .NET Core without Entity Framework

Question

I am working on a .NET Core application. Can I connect to an Azure SQL database using an access token without adding Entity Framework to my application?

There are a lot of articles online which show the connection using Entity Framework (example : https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-connect-msi)

Answer 1

Yes, you can the use System.Data.SqlClient NuGet package, specifically SqlConnection.AccessToken.