Aspire 9 and .NET 9 updates

[christiannagel]

• Use Azure CDK for deployment configuration
• BotQ service - use an Azure function
• Cosmos query with partition key updates https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-9.0/whatsnew#improvements-querying-with-partition-keys-and-document-ids
• Ranking service: time-triggered Azure Functions to create weekly and monthly rankings
• Update libraries to .NET 9 (support .NET 8 and 9) #276
• Update services to .NET 9 and Aspire 9