Update .NET Aspire to GA and update other NuGet packages to latest versions

[tjementum]

Summary & Motivation

Update .NET Aspire to the GA (General Availability) version, replacing the previous preview versions. There are no breaking changes, so this is a straightforward update.

Update other NuGet packages to their latest versions, including updating ASP.NET and EF Core to version 8.0.5.

Update GitHub workflows to trigger build when files in application/* are changed.

Checklist

• [x] I have added a Label to the pull-request
• [x] I have added tests, and done manual regression tests
• [x] I have updated the documentation, if necessary

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
No data about Duplication

See analysis details on SonarCloud