我有两个Docker容器，如下所示。我可以通过net6.0 C#控制台应用程序调用Test.Main()方法连接到docker中的PostgreSQL。但是当我尝试从ASP.NET docker容器调用Test.Main()时，我无法连接到PostgreSQL并获得异常Failed to connect to 127.0.0.1:5432：

{Npgsql.NpgsqlException (0x80004005): Failed to connect to 127.0.0.1:5432
 ---> System.Net.Sockets.SocketException (111): Connection refused
   at Npgsql.Internal.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
   at Npgsql.Internal.NpgsqlConnector.Connect(NpgsqlTimeout timeout)
   at Npgsql.Internal.NpgsqlConnector.RawOpen(SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken, Boolean isFirstAttempt)
   at Npgsql.Internal.NpgsqlConnector.<Open>g__OpenCore|215_1(NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken, Boolean isFirstAttempt)
   at Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.PoolingDataSource.OpenNewConnector(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.PoolingDataSource.<Get>g__RentAsync|28_0(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlConnection.<Open>g__OpenAsync|45_0(Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlConnection.Open()
   at APIDA.DBModels.Test.Main() in Version.cs:line 34}

个字符
ASP.NET DockerFile是

FROM mcr.microsoft.com/dotnet/aspnet:6.0 AS base
WORKDIR /app
EXPOSE 80
EXPOSE 443

FROM mcr.microsoft.com/dotnet/sdk:6.0 AS build
WORKDIR /src
COPY ["GB3API/GB3API.csproj", "GB3API/"]
RUN dotnet restore "GB3API/GB3API.csproj"
COPY . .
WORKDIR "/src/GB3API"
RUN dotnet build "GB3API.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "GB3API.csproj" -c Release -o /app/publish /p:UseAppHost=false

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .
ENTRYPOINT ["dotnet", "GB3API.dll"]

型

测试.主

public class Test
{
    public static void Main()
    {
        string connectionString = "Host=127.0.0.1;Database=postgres;Username=postgres;Password=xxxxx";

        // Create a new PostgreSQL connection
        using (NpgsqlConnection connection = new NpgsqlConnection(connectionString))
        {
            try
            {
                // Open the connection
                connection.Open();

                // Check if the connection is open
                if (connection.State == System.Data.ConnectionState.Open)
                {
                    Console.WriteLine("Connected to PostgreSQL!");

                    // Perform your database operations here

                    // Close the connection when you're done
                    connection.Close();
                    Console.WriteLine("Connection closed.");
                }
                else
                {
                    Console.WriteLine("Failed to open the connection.");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
            }
        }

        Console.ReadLine();
    }
}

型