Azure Function v2 和连接字符串

我有以下内容local.settings.json file:

{
  "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "UseDevelopmentStorage=true",
    "AzureWebJobsDashboard": "UseDevelopmentStorage=true",
    "FUNCTIONS_WORKER_RUNTIME": "dotnet",

    "SureMdmApiKey": "xxx",
    "SureMdmApiUrl": "xxx",
    "SureMdmUsername": "xxx",
    "SureMdmPassword": "xxx"
  },
  "ConnectionStrings": {
    "StorageConnectionString": "aaaa",
    "DataContext": "aaaa"
  }
}

然后我在 Startup.cs 文件中有以下代码：

[assembly: FunctionsStartup(typeof(FunctionAppSureMdmSync.Startup))]
namespace FunctionAppSureMdmSync
{
    public class Startup : FunctionsStartup
    {
        public override void Configure(IFunctionsHostBuilder builder)
        {
            var services = builder.Services;

            services.AddTransient<ISureMdmService>(s => new SureMdmService(
                url: System.Environment.GetEnvironmentVariable("SureMdmApiUrl"),
                username: System.Environment.GetEnvironmentVariable("SureMdmUserName"),
                password: System.Environment.GetEnvironmentVariable("SureMdmPassword"),
                apiKey: System.Environment.GetEnvironmentVariable("SureMdmApiKey")
                ));

            var connString = System.Environment.GetEnvironmentVariable("ConnectionStrings:DataContext");
            services.AddDbContext<DataContext>(options => options
                .UseSqlServer(connString, x => x.UseNetTopologySuite()));


            services.AddTransient<ITabletGroupService, TabletGroupService>();
            services.AddTransient<ITabletService, TabletService>();
        }

    }
}

并且在本地运行良好

但是当我将此函数发布到 Azure 门户并转到“配置”并将“DataContext”添加到“连接字符串”时：

我的代码不起作用：

            var connString = System.Environment.GetEnvironmentVariable("ConnectionStrings:DataContext");

如何获取连接字符串？我希望它可以在本地和 Portal Azure 上运行吗？

我发现可以访问IConfiguration in Startup，你需要建立一个临时的服务提供者，然后你就把它扔掉。最近可能有更好的方法，但它仍然工作正常：

var configuration = builder.Services.BuildServiceProvider().GetService<IConfiguration>(); 

那么，不要使用System.Environment.GetEnvironmentVariable(), but IConfiguration相反（这同样适用于您的所有配置）：

var connString = configuration.GetConnectionString("DataContext");