1 回答

TA貢獻1828條經驗 獲得超4個贊
因此,您可以從 appsettings.json 文件中訪問連接字符串值以獲取GetConnection()這樣的方法 -
應用配置.cs
public OracleConnection GetConnection(string conn)
{
try
{
string connectionString = _configuration["ConnectionStrings:" + conn];
OracleConnection dbConn = new OracleConnection(connectionString);
return dbConn;
}
catch(Exception ex)
{
throw ex;
}
}
在AccountController.cs控制器中,您需要IConfiguration在該控制器的構造函數中注入對象的依賴關系。
public class AccountController
{
public IConfiguration _configuration { get; }
public AccountController(IConfiguration configuration)
{
_configuration = configuration;
}
[HttpPost]
[Route("CreateUser")]
public IActionResult CreateUser(string conn, string username)
{
try
{
AccountDL objAccountDL = new AccountDL(_configuration); //call account data layer
objAccountDL.CreateUser(conn, username); //conn = "CON1"
return Ok();
}
catch(Exception ex)
{
throw ex;
}
}
}
因此您還需要修改AccountDL.cs類。您需要在構造函數或方法參數中傳遞該對象。
public class AccountDL
{
IConfiguration _configuration;
OracleConnection _oracleConnection;
public AccountDL(IConfiguration configuration)
{
_configuration = configuration;
}
public string CreateUser(string conn, string username)
{
AppConfiguration appConfg = new AppConfiguration(_configuration);
_oracleConnection = appConfg.GetConnection(conn);
}
}
- 1 回答
- 0 關注
- 147 瀏覽
添加回答
舉報