Azure SQL Database interactions using Azure Functions

So far, you have learned how to store data in Azure Storage services such as Blobs, Queues, and Tables. All these storage services are great for storing non-structured or semi-structured data. However, we might have requirements for storing data in relational database management systems such as Azure SQL Database.

In this recipe, you will learn how to utilize ADO.NET API to connect to the Azure SQL Database and insert JSON data into a table named EmployeeInfo.

Getting ready

Navigate to the Azure Management portal and create the following:

1. Create a logical SQL Server named AzureCookbook in the same resource group where you have your Azure Functions.
2. Create an Azure SQL...