How can I query data in an Azure Analysis Service from a ASP.NET Core application?

Question

I have an cloud application that dumps all its data into an Azure Data Lake.

Using Azure Data Factory, I have built a pipeline that extracts and transforms the data from the lake and saves it in local .csv files.

These .csv files are accessible in an Azure SQL Data Warehouse as external files that are CTAS as proper SQL tables.

I have created an Azure Analysis Service instance that is hooked up to the warehouse, provides additionnal information out of the existing data and caches it.

Question

I want to make this data available from a Web API. I have created a ASP.NET Core application and I would like this application to connect the service to query the data.

Knowing that the client libraries (ADOMD) are all .NET Framework libraries that can't loaded in a .NET Core app, how should I do this?

Answer 1

There is now an official version of ADOMD.NET for .NET Core available. See another answer here for details.