Templates 9.0 follow up work

[radical]

Once #6058 is merged:

• unsupported hosts - vs version Does this need to be bumped higher? Are we doing any testing of Aspire 9 with VS 17.10 or 17.11? Add templates for 9.0 #6058 (comment) UPDATE We're happy to leave docs saying 17.12 is required but keep the template constraint set to 17.9
• Update Microsoft.Extensions.HttpResilience version in the net9 template to net9 nuget (PR Bump Microsoft.Extensions.Http.Resilience to 9.x #6419)
• Check if the Web template needs any updates (PR Update starter template from .NET 9 app template updates #6124)
• Make sure https://aka.ms/dotnet/aspire/third-party-notices is valid, used in the templates
• Update app host templates to use WaitFor where applicable
• Update Service Defaults template to configure tracing for an activity source with the application name
• Add option to Starter template to include a database with EF Core and migrations #4206 (moved to 9.1)
• [tests] Add new-and-build tests for servicedefaults, and apphost templates
• [tests] Add test coverage for new --aspire-version template option

cc @DamianEdwards @joperezr

[DamianEdwards]

I ensured https://aka.ms/dotnet/aspire/third-party-notices works

[joperezr]

Marking as High. @DamianEdwards is going to do item 2 which is the only one required for 9

[DamianEdwards]

Moving to Backlog now that the 9.0 tasks are done.