How to authenticate using Microsoft.Azure.Services.AppAuthentication?

[empz]

I'm using Azure Kusto .NET SDK (Kusto.Data) library and I want to use the library Microsoft.Azure.Services.AppAuthentication so that I can use managed identities on Azure but my own developer account when running locally as shown here: https://docs.microsoft.com/en-us/azure/key-vault/service-to-service-authentication#local-development-authentication

I'm having a hard time trying to put the pieces together. I'm able to get an access token but then I'm not sure how to use it for the request.

var kustoClusterUri = "https://myclustername.westus2.kusto.windows.net";
var dbName = "MyDatabase";
var azureServiceTokenProvider = new AzureServiceTokenProvider();

string accessToken = await azureServiceTokenProvider.GetAccessTokenAsync(kustoClusterUri).ConfigureAwait(false);

KustoConnectionStringBuilder kcsb = new KustoConnectionStringBuilder(kustoClusterUri, dbName)
var queryProvider = KustoClientFactory.CreateCslQueryProvider(kcsb);

var requestProperties = new ClientRequestProperties {
    ClientRequestId = Guid.NewGuid().ToString(),
    SecurityToken = accessToken, // ???
    User = azureServiceTokenProvider.PrincipalUsed.UserPrincipalName // ???
};

var query = ".show tables";
queryProvider.ExecuteQuery(dbName, query, requestProperties);

Getting Unauthorized error.

I couldn't find any documentation on how to do this. Maybe using some of the methods in KustoConnectionStringBuilder? Maybe WithAadTokenProviderAuthentication() ?

[empz]

Found it!

var kustoClusterUri = "https://kusto-cluster-url";
var azureServiceTokenProvider = new AzureServiceTokenProvider();

var kcsb = new KustoConnectionStringBuilder(kustoClusterUri)
    .WithAadTokenProviderAuthentication(
        () => azureServiceTokenProvider.GetAccessTokenAsync(kustoClusterUri).GetAwaiter().GetResult()
    );

[zzgzy]

@eparizzi Hi Emiliano, .Dump() no longer works and I tried .Dispose() but got error saying "Cannot access a disposed object.". Have you seen this error? Thank you in advance!

[empz]

@zzgzy .Dump() is just an extension method provided by LINQPad. No need to use it.

You have the working example on my second comment.

[jykallam]

@empz where do you managed identity to generate the token?