private async Task <string> GetAzureSqlAccessToken(CancellationToken cancellationToken)
{
var tokenRequestContext = new TokenRequestContext(new[] { "https://database.windows.net//.default" });
var tokenRequestResult = await _azureAuthenticationCredentialProvider.GetMsalRestApiToken(tokenRequestContext, cancellationToken);
return(tokenRequestResult);
}
public async Task <SqlConnection> GetConnection()
{
SqlConnection _con = new SqlConnection(_connectionstring);
string _token = await _authProvider.GetMsalRestApiToken(new Azure.Core.TokenRequestContext(new string[] { "https://database.windows.net//.default" }), new System.Threading.CancellationToken());
_con.AccessToken = _token;
return(_con);
}
