Packt+ | Advance your knowledge in tech

You're reading from Azure Serverless Computing Cookbook Build applications hosted on serverless architecture using Azure Functions

Product type Paperback

Published in Aug 2017

Publisher Packt

ISBN-13 9781788390828

Length 332 pages

Edition 1st Edition

Tools

Azure

Concepts

Serverless

Author (1):

Praveen Kumar Sreeram

View More author details

Table of Contents (19) Chapters

Title Page

Credits

Foreword

About the Author

About the Reviewer

Acknowledgments

www.PacktPub.com

Customer Feedback

Preface

1. Accelerate Your Cloud Application Development Using Azure Function Triggers and Bindings

2. Working with Notifications Using SendGrid and Twilio Services FREE CHAPTER

3. Seamless Integration of Azure Functions with Other Azure Services

4. Understanding the Integrated Developer Experience of Visual Studio Tools for Azure Functions

5. Exploring Testing Tools for the Validation of Azure Functions

6. Monitoring and Troubleshooting Azure Serverless Services

7. Code Reusability and Refactoring the Code in Azure Functions

8. Developing Reliable and Durable Serverless Applications Using Durable Functions

9. Implement Best Practices for Azure Functions

10. Implement Continuous Integration and Deployment of Azure Functions Using Visual Studio Team Services

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:

Create a logical SQL Server named AzureCookbook in the same resource group where you have your Azure Functions.
Create an Azure SQL Database named Cookbookdatabase by choosing Blank Database in the Select Source drop-down of the SQL Database blade while creating the database.
Create a firewall rule to your IP address so that you can connect to the Azure SQL Databases using SQL Server Management Studio (SSMS...