Support named configuration providers for Aspire resources

Aspire resource support Configuration-based models for configuring resources under well-defined keys. For example, Storage Blob resources support configuration under the Aspire:Azure:Storage:Blobs key.

{
  "Aspire": {
    "Azure": {
      "Storage": {
        "Blobs": {
          "DisableHealthChecks": true,
          "DisableTracing": false,
          "ClientOptions": {
            "Diagnostics": {
              "ApplicationId": "myapp"
            }
          }
        }
      }
    }
  }
}

This configuration model doesn't currently support different configurations for different instances of the same resource type in an application. To address this, we'll update the resource configuration strategy to support instances keyed by name as follows:

{
  "Aspire": {
    "Azure": {
      "Storage": {
        "Blobs": {
           "blob1": { .. },
           "blob2": { ..},
        }
      }
    }
  }
}

At the moment, the primary motivation for doing this is to provide a resolution for the "dual config dilemma" documented in https://github.com/dotnet/aspire/issues/5563 since the existing configuration provider key name scheme doesn't conflict with Azure WebJob's lookup semantics.

Tracked Integrations

[x] Aspire.Azure.AI.OpenAI
[x] Aspire.Azure.Data.Tables
[x] Aspire.Azure.Messaging.EventHubs
[x] Aspire.Azure.Messaging.ServiceBus
[x] Aspire.Azure.Message.WebPubSub
[x] Aspire.Azure.Search.Documents
[x] Aspire.Azure.Security.KeyVault
[x] Aspire.Azure.Storage.Blobs
[x] Aspire.Azure.Storage.Queues
[x] Aspire.Confluent.Kafka
[x] Aspire.Elastic.Clients.Elasticsearch
[x] Aspire.Microsoft.Azure.Cosmos
[x] Aspire.Microsoft.Data.SqlClient
[ ] Aspire.Microsoft.EntityFrameworkCore.Cosmos
[ ] Aspire.Microsoft.EntityFrameworkCore.SqlServer
[x] Aspire.Milvus.Client
[x] Aspire.MongoDB.Driver
[x] Aspire.MySqlConnector
[x] Aspire.NATS.Net
[x] Aspire.Npgsql
[ ] Aspire.Npgsql.EntityFrameworkCore.PostgreSQL
[ ] Aspire.OpenAI
[ ] Aspire.Oracle.EntityFrameworkCore
[ ] Aspire.Pomelo.EntityFrameworkCore.MySql
[x] Aspire.Qdrant.Client
[x] Aspire.RabbitMQ.Client
[x] Aspire.Seq
[x] Aspire.StackExchange.Redis
[x] Aspire.StackExchange.Redis.DistributedCaching
[x] Aspire.StackExchange.Redis.OutputCaching

dotnet / aspire

Support named configuration providers for Aspire resources #5826