Azure SQL and Azure Functions - Integration with SQL Bindings

Overview

Learn Data Science. Courses starting at $12.99.

Explore the integration of Azure Functions and Azure SQL using SQL bindings in this 27-minute conference talk from Microsoft Build 2022. Learn about the public preview of SQL bindings for C#, JavaScript, and Python functions, which simplify development for both new and existing databases. Discover how to use input and output bindings through various examples, including creating APIs on SQL databases. Gain insights into SQL Projects for code deployment and Managed Identity Authentication. Follow along with demonstrations of C# and JavaScript implementations, and understand how these tools can expedite your development process when working with Azure Functions and Azure SQL.

Syllabus

Introduction.
What do developers love about Azure Functions and Azure SQL?.
Scenario: creating an API on a SQL database.
Introducing SQL bindings for Azure Functions.
Input and output SQL bindings.
SQL input binding.
Sample API: product list.
Sample C# Input Binding.
Demonstration.
Sample JavaScript Input Binding.
Demonstration.
SQL output binding.
Sample API: new product.
Sample JavaScript Output Binding.
Sample C# Output Binding.
Demonstration.
SQL Projects for SQL Code Deployment.
Demonstration.
Managed Identity Authentication.
Connecting with Managed Identity.
Closing Notes.