.NET Core appsettings.json 获取数据库连接字符串

1、在项目的根目录中创建appsettings.json文件

{
  "MssqlConnectionString": "Server=yourip; Database=yourdbname; User Id=yourusername; Password=yourpassword; Pooling=true;",
  "Db2ConnectionString": "Database=yourdbname;UserID=yourusername;Password=yourpassword;Server=yourip:yourport",
  "SomeOtherKey": "SomeOtherValue"
}

2、安装Microsoft.Extensions.Configuration.Json的Nuget包

Install-Package Microsoft.Extensions.Configuration.Json -Version 2.2.0

3、添加AppSettingsJson类

using Microsoft.Extensions.Configuration;using System.IO;namespace RutarBackgroundServices.AppsettingsJson{    public static class AppSettingsJson    {        public static string ApplicationExeDirectory()        {            var location = System.Reflection.Assembly.GetExecutingAssembly().Location;            var appRoot = Path.GetDirectoryName(location);            return appRoot;        }        public static IConfigurationRoot GetAppSettings()        {            string applicationExeDirectory = ApplicationExeDirectory();            var builder = new ConfigurationBuilder()            .SetBasePath(applicationExeDirectory)            .AddJsonFile("appsettings.json");            return builder.Build();        }    }}

4、使用AppSettingsJson获取连接字符串

var appSettingsJson = AppSettingsJson.GetAppSettings();
var connectionString = appSettingsJson["MssqlConnectionString"];