A sample web application where users can leave a message and view recent messages. After entry, messages are send to content moderation. Watch a walkthrough of this sample at https://www.youtube.com/watch?v=01nhp4OAk0c.

• Azure SQL Database
• .NET Azure Functions
  • SQL trigger
  • SQL output binding
• JavaScript Azure Functions
  • SQL output binding
  • SQL input binding
• PowerShell Azure Functions
  • SQL input binding
• Azure Static Web App
• Azure Content Moderation

• JavaScript Azure Functions
  • lists some entries from the app.Entry table (SQL input binding)
  • add guestbook entry for to app.Entry table (SQL output binding)
• Azure Static Web App
  • input form for adding guestbook entries
  • list of guestbook entries
  • calls to the JavaScript Azure Functions
• .NET Azure Function
  • SQL trigger on changes in app.Entry table
  • sends newly inserted rows to Azure Content Moderation
  • SQL output binding writes moderation results to app.Moderation table
  • SQL output binding updates to app.Entry table
• PowerShell Azure Function
  • timer trigger runs the PowerShell functoion on a schedule
  • SQL input binding runs a stored procedure checking the health of change tracking

Learn more at https://aka.ms/sqlbindings.

• Azure Functions can authenticate to Azure SQL Database with Azure AD Managed Identity
• Configure SQL bindings with a connection string and T-SQL query, stored procedure name, or table name
• SQL bindings are currently in preview for .NET, JavaScript, Python, PowerShell, and Java Azure Functions
• SQL trigger is currently in preview for .NET Azure Functions

Instructions are available for setup of local development of this sample in GETTING_STARTED.md.