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); }