📦 433 net 9 upgrade

[danielmackay]

> 1. What triggered this change? (PBI link, Email Subject, conversation + reason, etc)

433

2. What was changed?

This pull request includes several updates to package versions across multiple project files, transitioning from release candidates and preview versions to stable versions.

Updates to package versions:

• global.json: Updated .NET SDK version to 9.0.100 and set allowPrerelease to false.

• src/Application/Application.csproj: Updated Microsoft.EntityFrameworkCore, Microsoft.Extensions.DependencyInjection.Abstractions, and Microsoft.Extensions.Logging.Abstractions to version 9.0.0.

• src/Infrastructure/Infrastructure.csproj: Updated several packages to version 9.0.0, including Aspire.Microsoft.EntityFrameworkCore.SqlServer, Microsoft.Extensions.Http.Resilience, and Microsoft.Extensions.ServiceDiscovery. Added Microsoft.Extensions.Diagnostics.HealthChecks and updated OpenTelemetry packages to version 1.10.0.

• src/WebApi/WebApi.csproj: Updated Microsoft.AspNetCore.OpenApi, Microsoft.EntityFrameworkCore.Design, and Scalar.AspNetCore to stable versions. Removed explicit reference to Azure.Identity.

• tests/Directory.Packages.props: Updated multiple testing-related packages, including FluentAssertions, coverlet.collector, and NSubstitute, to their latest versions.

• tools/AppHost/AppHost.csproj: Updated Aspire.Hosting.AppHost, Aspire.Hosting.SqlServer, and Microsoft.EntityFrameworkCore.SqlServer to version 9.0.0.

• tools/MigrationService/MigrationService.csproj: Updated Aspire.Microsoft.EntityFrameworkCore.SqlServer and Microsoft.Extensions.Hosting to version 9.0.0.

3. Did you do pair or mob programming?

No