1.Nuget添加Microsoft.Extensions.Configuration.Json

2.appsettings.json中添加"ConnectionStrings"

{
  "Logging": {
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "ConnectionStrings": {
    "SQLConnection": "Data Source=127.0.0.1;Database=xxxx;UID=xx;PWD=xx;",
    "OracleConnection": "",
    "MySqlConnection": "",
    "SqlLiteConnection": ""
  },
  "AllowedHosts": "*"
}

3.新建AppSettingsJson.cs

using Microsoft.Extensions.Configuration;
using System.IO;

namespace WebAPI
{
    public 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.C#调用 

var config = AppSettingsJson.GetAppSettings();

var sqlconnection = config.GetSection("ConnectionStrings:SQLConnection").Value;

var connectionstrings = config.GetSection("ConnectionStrings");
var oracleconnection = connectionstrings["OracleConnection"];

 

posted on 2019-07-29 14:32  Monsoon  阅读(1139)  评论(0编辑  收藏  举报