DP-3020 - Lab 2 - Configure and Deploy CI/CD Pipelines - Issue

Start with LAB02 Step 3 and its main.yml workflow, comparing the instructed deployment with the edited workflow shown in the issue. Run the workflow against an Azure SQL Database project and confirm the DotNet failure is gone and the build produces and deploys the DACPAC.

LAB02 (CSS): Configure and deploy CI/CD pipelines for Azure SQL Database projects
Task: Create a GitHub Actions workflow
Step. 3: Copy the code below on your main.yml file. The code includes the steps for building and deploying your database project.

User have reported running the deployment with the Main.yml file as instructed fails with a DotNet failure [P1]. I have confirmed this behavior and have been able to bypass the issue using the following edited code in the Main.yml file [P2]:

name: Build and Deploy SQL Database Project

on:
  push:
    branches:
      - main

jobs:
  build:
    permissions:
      contents: read
      id-token: write

    runs-on: windows-latest

    steps:
      - name: Checkout repository
        uses: actions/checkout@v3

      # Install MSBuild (required for .sqlproj)
      - name: Setup MSBuild
        uses: microsoft/setup-msbuild@v2

      # Install sqlpackage (Windows version)
      - name: Install sqlpackage
        run: |
          dotnet tool install -g microsoft.sqlpackage

      - name: Login to Azure
        uses: azure/login@v1
        with:
          creds: ${{ secrets.AZURE_CREDENTIALS }}

      # Build SQL Project using MSBuild
      - name: Build SQL Project
        run: |
          msbuild .\MyDBProj\MyDBProj.sqlproj /p:Configuration=Release

      # Publish DACPAC to Azure SQL
      - name: Deploy DACPAC
        run: |
          sqlpackage /Action:Publish `
            /SourceFile:".\MyDBProj\bin\Release\MyDBProj.dacpac" `
            /TargetConnectionString:"${{ secrets.AZURE_CONN_STRING }}" `
            /p:DropObjectsNotInSource=true

[P1] - Deployment with the code as instructed

[P2] - Deployment with edited code above