Docker中运行.NET应用时EF Core无法连接本地SQL Server求助

我在本地机器部署了SQL Server实例，用EF Core开发的应用直接以控制台运行时一切正常，但放到Docker中运行后，无法连接该数据库，获取数据时抛出异常（见配图）。

连接字符串配置： #

builder.Services.AddDbContext<AppDbContext>(options => options.UseSqlServer(
"Server=.\SQLEXPRESS;Database=Cars;Trusted_Connection=True;TrustServerCertificate=True;"));

Dockerfile内容： #

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

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

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

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

如需补充更多信息，请告知，恳请帮忙解决。

内容的提问来源于stack exchange，提问作者georgink