通过GitHub Actions部署ASP.NET Core MVC到Azure出现500错误求助

我尝试通过GitHub Actions将ASP.NET Core MVC Web应用部署到Azure，本地运行完全正常，但部署流程完成后访问应用出现500错误。已配置连接字符串，怀疑问题出在GitHub Actions工作流中；通过Kudu运行本地所用的文件可正常工作，但查看错误日志未获取有效排查信息。

以下是我的工作流配置：

# Docs for the Azure Web Apps Deploy action: https://github.com/Azure/webapps-deploy
# More GitHub Actions for Azure: https://github.com/Azure/actions

name: Build and deploy ASP.Net Core app to Azure Web App - instbyden

on:
  push:
    branches:
      - master
  workflow_dispatch:

jobs:
  build:
    runs-on: windows-latest
    
    steps:
      - uses: actions/checkout@v4

      - name: Set up .NET Core
        uses: actions/setup-dotnet@v1
        with:
          dotnet-version: '7.x'
          include-prerelease: true

      - name: Build with dotnet
        run: dotnet build --configuration Release

      - name: dotnet publish
        run: dotnet publish -c Release -o ${{env.DOTNET_ROOT}}/myapp

      - name: Upload artifact for deployment job
        uses: actions/upload-artifact@v3
        with:
          name: .net-app
          path: ${{env.DOTNET_ROOT}}/myapp

  deploy:
    runs-on: windows-latest
    needs: build
    environment:
      name: 'Production'
      url: ${{ steps.deploy-to-webapp.outputs.webapp-url }}
    permissions:
      id-token: write #This is required for requesting the JWT

    steps:
      - name: Download artifact from build job
        uses: actions/download-artifact@v3
        with:
          name: .net-app
      
      - name: Login to Azure
        uses: azure/login@v1
        with:
          client-id: ${{ secrets.AZUREAPPSERVICE_CLIENTID_6E7DB23ABB7C46C581EBCFE4FB00E6F3 }}
          tenant-id: ${{ secrets.AZUREAPPSERVICE_TENANTID_D582151191524D76A669EB69D9D63985 }}
          subscription-id: ${{ secrets.AZUREAPPSERVICE_SUBSCRIPTIONID_F9EFD9D768594B54B60D373563613D0F }}

      - name: Deploy to Azure Web App
        id: deploy-to-webapp
        uses: azure/webapps-deploy@v2
        with:
          app-name: 'instbyden'
          slot-name: 'Production'
          package: .

GitHub项目地址：https://github.com/gr1gor1ychuk/Hryhoriichuk.University.Instagram

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