AfSqlQuery

using System.IO;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Extensions.Http;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using System.Data.SqlClient;
using System.Collections.Generic;

public static class SqlDataFunction
{
    [FunctionName("GetDataFromSql")]
    public static IActionResult Run(
        [HttpTrigger(AuthorizationLevel.Function, "get", Route = null)] HttpRequest req,
        ILogger log)
    {
        log.LogInformation("C# HTTP trigger function processed a request.");

        string connectionString = "YourOnPremiseConnectionStringHere"; // replace with your on-premise SQL Server connection string
        string query = "SELECT * FROM YourTableName"; // replace with your desired SQL query

        List<object> results = new List<object>();

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            using (SqlCommand cmd = new SqlCommand(query, connection))
            {
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        // For simplicity, just adding the entire row as an object. 
                        // You might want to map this to a specific class or structure.
                        var record = new object[reader.FieldCount];
                        reader.GetValues(record);
                        results.Add(record);
                    }
                }
            }
        }

        return new OkObjectResult(results);
    }
}