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

逃离我推掉我的手 2023-10-01 20:51 10阅读 0赞

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();