我在Visual Studio中创建了一个最小的ASP.NET Core Web API项目。然后将其部署到Azure Web App Service，以便能够远程“获取”结果。在本地，/weatherforecast示例数据和Azure SQL数据运行良好，但是，在发布后，只有weatherforecast可以访问，但/Members不可访问。
Program.cs

using Microsoft.Data.SqlClient;
using Microsoft.AspNetCore.OpenApi;
using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

var app = builder.Build();

// Configure the HTTP request pipeline.

app.UseHttpsRedirection();

var summaries = new[]
{
    "Freezing", "Bracing", "Chilly", "Cool", "Mild", "Warm", "Balmy", "Hot", "Sweltering", "Scorching"
};

app.MapGet("/weatherforecast", () =>
{
    var forecast = Enumerable.Range(1, 5).Select(index =>
        new WeatherForecast
        (
            DateOnly.FromDateTime(DateTime.Now.AddDays(index)),
            Random.Shared.Next(-20, 55),
            summaries[Random.Shared.Next(summaries.Length)]
        ))
        .ToArray();
    return forecast;
});
string connectionString = Environment.GetEnvironmentVariable("AZURE_SQL_CONNECTIONSTRING");

app.MapGet("/Members", () => {
        var rows = new List<string>();

        using var conn = new SqlConnection(connectionString);
        conn.Open();

        var command = new SqlCommand("SELECT * FROM WHATEVER", conn);
        using SqlDataReader reader = command.ExecuteReader();

        if (reader.HasRows)
        { 
            while (reader.Read())
            {
                rows.Add($"{reader.GetInt32(0)}, {reader.GetString(1)}, {reader.GetString(2)}, {reader.GetString(3)}, {reader.GetString(4)}, {reader.GetInt32(5)}, {reader.GetInt32(6)}, {reader.GetDecimal(7)}, {reader.GetInt32(8)}, {reader.GetDateTime(9)}");
            }
        }

        return rows;
    })
    .WithName("GetMembers")
    .WithOpenApi();

app.Run();

internal record WeatherForecast(DateOnly Date, int TemperatureC, string? Summary)
{
    public int TemperatureF => 32 + (int)(TemperatureC / 0.5556);
}

一般注解：
1.我在Visual Studio中的帐户凭据与在运行Azure SQL的Azure Portal中的帐户凭据相同。
1.我一直在关注this项目的链接。
1.我的连接字符串是“Server=tcp：xxx;String =xxx;身份验证=Active Directory默认值;“，在launchSettings.json的environmentVariable下声明。在appsettings.json中也有声明。
1.当/Members端点被调用时，我得到一个HTTP ERROR 500。
你的帮助将不胜感激，谢谢。