Functions.Templates/Templates/SqlInputBinding-CSharp/SqlInputBindingCSharp.cs (24 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.Http;
using Microsoft.Azure.WebJobs.Extensions.Sql;
using Microsoft.Extensions.Logging;
namespace Company.Function
{
public static class SqlInputBindingCSharp
{
// Visit https://aka.ms/sqlbindingsinput to learn how to use this input binding
[FunctionName("SqlInputBindingCSharp")]
public static IActionResult Run(
[HttpTrigger(AuthorizationLevel.Function, "get", Route = null)] HttpRequest req,
[Sql("SELECT * FROM object",
"SqlConnectionString")] IEnumerable<Object> result,
ILogger log)
{
log.LogInformation("C# HTTP trigger with SQL Input Binding function processed a request.");
return new OkObjectResult(result);
}
}
}