Managing ADX Data with .NET Core and Azure B2C

Bryan Soltis demonstrates how to create a custom .NET Core web app to access and manage ADX data.

Azure Data Explorer (or ADX to those in the fan club), is a very powerful and scalable data solution for analytics and timeseries data. Capable of handling more records than you can fit on a Zip drive, it’s a great option for retaining and working with analytics from IoT and other devices. Often, developers need to work with this data outside of the Azure portal. In this article, I’ll show you how you can build a .NET Core Web App to manage ADX data — integrate it with Azure B2C, a custom API, and some other .NET Core stuff, because why not?

I recently had a client that was looking to build a custom web application to work with Azure Data Explorer (ADX) data. While managing this data is very easy from within the Azure portal, this solution called for a self-contained application to manage within the user’s environment. I searched for how to do this in a web application but didn’t find many resources. So, to help you on your development journey (and me remember the stuff I do), I decided to create a POC for the project.

Just to make it more fun, I added a bunch of other components to the solution (Azure B2C integration, Dependency Injection, Caching, and more!) so I’d have a complete solution blending all the concepts. For the process, I borrowed a bit from other repos and documentation along the way. Let me show you how I did it…