Pass-Through Authentication with Azure Active Directory, Azure SQL, Azure API and a Console Application

In situations you need to login to an application and use that identity to access an API (pass-through identity) and also get data from Azure SQL Server. With the new feature to use Azure Active Directory users within Azure SQL Server this is know is possible.

In this series of blog post I will cover the following topics:

• Part 1 – Azure SQL Database with Azure Active Directory Authentication
• Part 2 – Azure API Application to query the Azure SQL Database
• Part 3 – Console application to call the API

The blog post will appear online in the upcoming weeks.

Prerequisites

During the series of blog post we will use Visual Studio 2017 and other applications.

• Cloud Tools
• Azure Subscription

Complete source code can be found on GitHub at the end of Part 3.