[PROD-009] Full three-source .NET Docker PostgreSQL E2E validation

[ktalpay]

Task ID: PROD-009
Lane: dotnet
Status: merged
Agent: dotnet-agent
Depends on: PROD-008

Goal:
Extend the .NET Docker PostgreSQL E2E validation from one fixture-backed source family to all three Phase 1 source families: GHG Protocol, DEFRA/DESNZ, and IPCC EFDB.

Scope:

• Use .NET config/redaction boundary.
• Use .NET PostgreSQL schema bootstrap/year-state.
• Use .NET source-cycle orchestration.
• Use .NET source-specific master/detail insert runtime.
• Add opt-in Docker PostgreSQL E2E coverage for all three source families.
• Verify first insert, duplicate rerun skip, and year-state progression for each source family.
• Verify no_available_source_year behavior remains safe.

Non-goals:

• No final project production-ready claim.
• No Python runtime changes.
• No uncontrolled live network calls.
• No production credentials.
• No destructive DB operations.
• No Python/.NET persisted parity verdict yet.

Acceptance:

• Three-source .NET Docker PostgreSQL E2E path exists and is opt-in.
• GHG Protocol, DEFRA/DESNZ, and IPCC EFDB each validate insert/rerun/year-state behavior.
• Default test suite remains safe without PostgreSQL.
• Diagnostics redact secrets.
• No generated artifacts.

Task-ID: PROD-009

[github-actions]

Agent Task Watcher updated task status.

Detected task: PROD-009
Merged PR: #631
Task issue status: status:missing -> status:merged

Downstream task update summary:

No dependent tasks were declared in Unblocks:.