C# – 如何在控制台和WEB应用程序中读取 appsetting.json 文件中的数据库连接字符串

appsettings.json

{
  "ConnectionStrings": {
    "DefaultConnection": "server=localhost;user=root;database=wminms;port=3306;password=root;sslmode=none"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"
}

控制台应用程序

using System;
using System.Management;
using MySql.Data.MySqlClient;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Configuration.Json;
using System.IO;
public class Poller
{

    public static void Main()
    {

        var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json");
        var config = builder.Build();
        string connectionstring = config.GetConnectionString("DefaultConnection");
        MySqlConnection con = new MySqlConnection(connectionstring);
        con.Open();

WEB应用程序

using System;
using System.Collections.Generic;
using Microsoft.AspNetCore.Http;
using MySql.Data.MySqlClient;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Configuration.Json;
using System.IO;

namespace wminmsweb.Models
{
    public class UserRepository
    {


        private string connectionstring;
        public UserRepository()
        {
            var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json");
            var config = builder.Build();
            this.connectionstring = config.GetConnectionString("DefaultConnection");
        }


        public void Insert(User user)
        {

            MySqlConnection connection = new MySqlConnection(connectionstring);

            connection.Open();