Azure SQL and Azure Functions: Integration with SQL bindings | OD131

The integration of Azure Functions and Azure SQL just became easier with SQL bindings, now in public preview for C#, JavaScript, and Python functions. SQL bindings expedite your development experience whether you are working with new or existing databases. In this session we’ll take a look at several examples using both input and output bindings. Additional Resource: Deploy serverless APIs with Azure Functions, Logic Apps, and Azure SQL Database -- https://docs.microsoft.com/learn/modules/deploy-backend-apis/ Chain Azure Functions together using input and output bindings -- https://docs.microsoft.com/learn/modules/chain-azure-functions-data-using-bindings/ Recommended Next Step: Learn at Build -- https://aka.ms/LearnatBuild/?wt.mc_id=build22_ondemand_webpage_esc Jump to: 00:00 Introduction 00:31 What do developers love about Azure Functions and Azure SQL? 02:17 Scenario: creating an API on a SQL database 04:10 Introducing SQL bindings for Azure Functions 04:50 Input and output SQL bindings 05:24 SQL input binding 06:10 Sample API: product list 06:26 Sample C# Input Binding 07:25 Demonstration 10:14 Sample JavaScript Input Binding 11:48 Demonstration 14:53 SQL output binding 15:23 Sample API: new product 15:47 Sample JavaScript Output Binding 16:31 Sample C# Output Binding 16:52 Demonstration 22:06 SQL Projects for SQL Code Deployment 23:18 Demonstration 25:32 Managed Identity Authentication 26:31 Connecting with Managed Identity 26:52 Closing Notes Microsoft Build 2022