SQLHelper.cs

SQLHelper.cs

public static class TokenHelper
{
    public static Task<String> GetTokenAsync()
    {
        var provider = new AzureServiceTokenProvider();
        return provider.GetAccessTokenAsync("https://database.windows.net/");
    }
}

public static class SqlConnectionExtensions
{
    public async static Task<TPayload> ExecuteScalar<TPayload>(string commandText)
        where TPayload: class
    {
        var connectionString = "connection string without credentails";
        var token = await ADAuthentication.GetSqlTokenAsync();
        using (var conn = new SqlConnection(connectionString))
        {
            conn.AccessToken = token;
            await conn.OpenAsync();
            
            using (var cmd = new SqlCommand(commandText, conn))
            {
                var result = await cmd.ExecuteScalarAsync();
                return result as TPayload;
            }
        }
    }
}