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"];