.netCore读取配置文件里的sqlserver连接字符串

连接字符串：

"ConnectionString": {
    "LMSDB": "Server=.;Database=Logistics;Trusted_Connection=True;"
  },

读取字符串内容：

通过依赖注入，构造函数注入的方式定义一个configuration接口,注意连接字符串的名字要匹配

private Microsoft.Extensions.Configuration.IConfiguration _configuration;
        public ConfigService(Microsoft.Extensions.Configuration.IConfiguration configuration)
        {
            _configuration = configuration;    
        }
        public string GetConnectionString() 
        {
            return _configuration["ConnectionString:LMSDB"];
        }

读取配置文件的内容用UseSqlServer生成数据库

public partial class LMSDbContext{

         public LMSDbContext(ConfigService configService) 
        {
                    m_connectionString = configService.GetConnectionString();
        }
         protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
                    optionsBuilder.UseSqlServer(m_connectionString);
                    base.OnConfiguring(optionsBuilder);
        }

}