Functions.Templates/Templates/SqlTrigger-CSharp/SqlTriggerBindingCSharp.cs (27 lines of code) (raw):
using System;
using System.Collections.Generic;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Extensions.Sql;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
namespace Company.Function
{
public static class SqlTriggerBinding
{
// Visit https://aka.ms/sqltrigger to learn how to use this trigger binding
[FunctionName("SqlTriggerBindingCSharp")]
public static void Run(
[SqlTrigger("table", "SqlConnectionString")] IReadOnlyList<SqlChange<ToDoItem>> changes,
ILogger log)
{
log.LogInformation("SQL Changes: " + JsonConvert.SerializeObject(changes));
}
}
public class ToDoItem
{
public string Id { get; set; }
public int Priority { get; set; }
public string Description { get; set; }
}
}