获取数据访问层中的连接字符串

Question

我有一个分层的项目架构，如下所示。

MyProject.Web           <-- ASP.NET Core app
MyProject.BusinessLogic <-- Class Library
MyProject.DataAccess    <-- Class Library

Web项目引用了BusinessLogic，而后者又引用了DataAccess。

连接字符串存储在Web工程的appsettings.json中，如下所示。

{
  "ConnectionStrings": {
    "LocalDatabase": "Server=..."
  },
  // ...

  }
}

如何在DataAccess项目中获取连接字符串？

Answer 1

试试这个：

public static IConfiguration Configuration { get; set; }

private string GetConnectionString()
{
    var builder = new ConfigurationBuilder()
    .SetBasePath(Directory.GetCurrentDirectory())
    .AddJsonFile("appsettings.json");

    Configuration = builder.Build();

    return Configuration.GetConnectionString("DefaultConnection");

}

记住appsetting.json

{
  "Logging": {
    "IncludeScopes": false,
    "Debug": {
      "LogLevel": {
        "Default": "Warning"
      }
    },
    "Console": {
      "LogLevel": {
        "Default": "Warning"
      }
    }
  },
  "ConnectionStrings": {
    "DefaultConnection": "Server=((local));Database=database;Trusted_Connection=True;user id=xx;password=xxxx;"
  }
}