Azure / azure-kusto-dotnet

Azure Data Explorer (Kusto) SDK for .NET
MIT License
8 stars 5 forks source link

DataReader returned by ICslQueryProvider.QueryAsync should indicate the resultset-name #18

Open fgheysels opened 1 year ago

fgheysels commented 1 year ago

I have a set of KQL queries that I execute in one batch.

For instance:

Table | where Timestamp > ago(5h) | project something | as ['t1'];
Table | where Timestamp > ago(5h) | where Tag = 'something' | summarize c = count() | as ['t2'];

I can execute this batch via the ICslQueryProvider.QueryAsync method, and the data-reader that is returned indeed contains 2 resultsets. However, it would be good if there was a way to verify which resultset is currently the active resultset in the datareader.

The DataReader has methods like GetTableName, but that method just returns null. It would be nice if this method could return t1 or t2 from the example above.

When I'm executing the batch right now, and reading out the results, the only thing I can do, is rely or hope that the resultsets in the datareader are in the same order as the queries in the batch.

(I am using Microsoft.Azure.Kusto.Data v11.2.2 which is the latest version at the time of writing).