本地从appsettings.json、生产从Azure Key Vault取数据库连接串及错误排查

本地环境从appsettings.json读取数据库连接串，开发、预发布、生产环境从Azure Key Vault获取。已在launchsettings.json中设置环境为Local，但本地运行项目时，Program.cs报错：The ConfigureServices method must either be parameterless or take only one parameter of type IServiceCollection.

相关配置及代码：

appsettings.json #

{
  "KeyVault": {
    "Vault": "Bookskv"
  },
  "MongoConnection": {
    "ConnectionString": "<set by keyvault>",
    "Database": "Books"
  },
  "MongoLocal": {
    "ConnectionString": "mongodb:localhost:1230",
    "Database": "Books"
  }
}

原Program.cs #

public static IWebHost CreateWebHostBuilder(string[] args)
{
    return WebHost.CreateDefaultBuilder(args)
       .ConfigureAppConfiguration((ctx, builder) =>
         {
             var keyName = string.Empty;
             if (ctx.HostingEnvironment.EnvironmentName!="Local")
             {
                 var keyVaultEndpoint = GetKeyVaultEndpoint();
                 if (!string.IsNullOrEmpty(keyVaultEndpoint))
                 {
                     var azureServiceTokenProvider = new AzureServiceTokenProvider();
                     var keyVaultClient = new KeyVaultClient(
                         new KeyVaultClient.AuthenticationCallback(
                             azureServiceTokenProvider.KeyVaultTokenCallback));
                     if(ctx.HostingEnvironment.EnvironmentName=="Development")
                     {
                          keyName = "BooksdevDb";
                     }
                     else if(ctx.HostingEnvironment.EnvironmentName == "Production")
                     {
                          keyName = "BooksprodDb";
                     }
                     var secretBundle =  keyVaultClient.GetSecretAsync("https://Bookskv.vault.azure.net/secrets/{keyName}").Result;
                     var secret = secretBundle.Value;                          
                   
                     builder.AddAzureKeyVault(
                         keyVaultEndpoint, keyVaultClient, new DefaultKeyVaultSecretManager());
                 }
           
             }                    
         }
      ).UseUrls("http://localhost:44315")
       .UseKestrel()
       .UseIISIntegration()
       .UseIIS()
       .UseStartup<Startup>()
       .Build();
}
private static string GetKeyVaultEndpoint() => "https://Bookskv.vault.azure.net";

原Startup.cs片段 #

services.Configure<Settings>(options =>
{
    if (env.IsDevelopment() || env.IsStaging() || env.IsProduction()) 
    {
        options.ConnectionString = Configuration.GetSection("MongoConnection:ConnectionString").Value;
        options.Database = Configuration.GetSection("MongoConnection:Database").Value;
    }
    else
    {
        options.ConnectionString = Configuration.GetSection("MongoLocal:ConnectionString").Value;
        options.Database = Configuration.GetSection("MongoLocal:Database").Value;
    }
});

Settings.cs #

public class Settings
{
    public string ConnectionString;
    public string Database;
}

报错不是来自Program.cs，而是Startup.cs。ASP.NET Core对ConfigureServices方法的参数有严格要求：要么无参数，要么只能接收IServiceCollection类型的单个参数。你的Startup.cs里的ConfigureServices方法额外注入了IWebHostEnvironment（即代码里的env变量），但没有按正确的参数顺序声明。

1. 修正Startup.cs的参数与逻辑 #

首先确保Startup类通过构造函数注入所需的配置和环境对象，然后调整ConfigureServices方法的参数和环境判断逻辑：

private readonly IConfiguration _configuration;
private readonly IWebHostEnvironment _env;

// 通过构造函数注入依赖
public Startup(IConfiguration configuration, IWebHostEnvironment env)
{
    _configuration = configuration;
    _env = env;
}

// ConfigureServices方法第一个参数必须是IServiceCollection
public void ConfigureServices(IServiceCollection services)
{
    services.Configure<Settings>(options =>
    {
        // 直接判断是否为Local环境，逻辑更清晰
        if (_env.IsEnvironment("Local"))
        {
            options.ConnectionString = _configuration.GetSection("MongoLocal:ConnectionString").Value;
            options.Database = _configuration.GetSection("MongoLocal:Database").Value;
        }
        else
        {
            // 非Local环境读取从Key Vault加载的MongoConnection配置
            options.ConnectionString = _configuration.GetSection("MongoConnection:ConnectionString").Value;
            options.Database = _configuration.GetSection("MongoConnection:Database").Value;
        }
    });

    // 其他服务注册逻辑...
}

2. 优化Program.cs的Key Vault逻辑 #

原代码里手动调用GetSecretAsync属于冗余操作，AddAzureKeyVault会自动将Key Vault中的密钥同步到配置系统，同时避免同步调用异步方法导致的死锁问题：

public static IWebHost CreateWebHostBuilder(string[] args)
{
    return WebHost.CreateDefaultBuilder(args)
       .ConfigureAppConfiguration((ctx, builder) =>
         {
             var env = ctx.HostingEnvironment;
             // 仅非Local环境加载Key Vault
             if (!env.IsEnvironment("Local"))
             {
                 var keyVaultEndpoint = GetKeyVaultEndpoint();
                 if (!string.IsNullOrEmpty(keyVaultEndpoint))
                 {
                     var azureServiceTokenProvider = new AzureServiceTokenProvider();
                     var keyVaultClient = new KeyVaultClient(
                         new KeyVaultClient.AuthenticationCallback(
                             azureServiceTokenProvider.KeyVaultTokenCallback));
                     
                     // AddAzureKeyVault自动同步密钥到配置系统
                     // 注意Key Vault中密钥名称需用--代替配置中的:，比如MongoConnection--ConnectionString
                     builder.AddAzureKeyVault(
                         keyVaultEndpoint, keyVaultClient, new DefaultKeyVaultSecretManager());
                 }
             }                    
         }
      ).UseUrls("http://localhost:44315")
       .UseKestrel()
       .UseIISIntegration()
       .UseIIS()
       .UseStartup<Startup>()
       .Build();
}

private static string GetKeyVaultEndpoint() => "https://Bookskv.vault.azure.net";

3. 验证launchsettings.json配置 #

确保环境变量设置正确：

"environmentVariables": {
  "ASPNETCORE_ENVIRONMENT": "Local"
}

内容的提问来源于stack exchange，提问作者Anjana Padmesh