¾È³çÇϼ¼¿ä.
Á¤È®È÷ ¿øÇÏ´Â ´äº¯ÀÌ µÉÁö´Â ¸ð¸£°ÚÁö¸¸,
¾Æ·¡ ³»¿ëÀ» È®ÀÎÇØ º¸½Ã±â ¹Ù¶ø´Ï´Ù.
appsettings.json ÆÄÀÏ¿¡ ¼¹ö, DB, UID, PWD Á¤º¸¸¦ µû·Î º¸°üÇÏ°í ÀÖ´Ù°í,
À̸¦ ÇÊ¿äÇÑ ºÎºÐ¿¡¼ ÀÐÀº ÈÄ
º¯°æÇÒ ³»¿ë(¿¹¸¦ µé¾î, µ¥ÀÌÅͺ£À̽º)ÀÌ ÀÖÀ¸¸é ±×¶§ º¯°æÇÑ ÈÄ ´Ù½Ã ±× Á¤º¸¸¦ Á¶ÇÕÇؼ
»õ·Î¿î µ¥ÀÌÅͺ£À̽º ¿¬°á ¹®ÀÚ¿À» ¸¸µé ¼öµµ ÀÖ½À´Ï´Ù.
¹æ¹ýÀº ¸¹ÀÌ ÀÖ°ÚÁö¸¸,
¾Æ·¡ ¹æ¹ýÀ» Çѹø °ËÅäÇØ º¸¼Åµµ ÁÁÀ» °Í °°³×¿ä.
====================================================
appsettings.json ÆÄÀÏÀÇ ¿©·¯ Á¤º¸¸¦ ±¸ºÐÇؼ Àоî¿À±â
(1) ºÐ¸®µÈ ÇüÅÂÀÇ µ¥ÀÌÅͺ£À̽º ¿¬°á ¹®ÀÚ¿À» appsettings.json ÆÄÀÏ¿¡ ¾Æ·¡¿Í °°ÀÌ ¼³Á¤Çß½À´Ï´Ù.
ÄÚµå: appsettings.json
"Con": {
"Server": "Data Source",
"Database": "Intital Catalog",
"User ID": "UID",
"Password": "PWD"
},
(2) ConfigController ÄÁÆ®·Ñ·¯ Ŭ·¡½º¸¦ ¸¸µé°í ½ÇÇà ÈÄ /Config °æ·Î¸¦ ¿äûÇÕ´Ï´Ù.
ÄÚµå: /Controllers/ConfigController.cs
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
namespace DotNetNoteCom.Controllers
{
public class ConfigController : Controller
{
private IConfiguration _config;
public ConfigController(IConfiguration config)
{
_config = config;
}
public string Index()
{
// 1.X ¹öÀüÀº GetSecion() ¸Þ¼µå »ç¿ë
string srv = _config.GetSection("Con").GetSection("Server").Value;
string rdb = "µ¥ÀÌÅͺ£À̽º"; // µ¿ÀûÀ¸·Î º¯°æ °¡´É
string uid= _config["Con:User ID"]; // 2.X ¹öÀü
string pwd= _config["Con:Password"];
// ¿øÇÏ´Â ¸ð¾çÀ¸·Î °¡°øÇؼ »ç¿ë °¡´É
return $"{srv};{rdb};{uid};{pwd}";
}
}
}
(3) À¥ ºê¶ó¿ìÀú·Î °¡Á¾µÈ ¹®ÀÚ¿ÀÌ Ãâ·ÂµË´Ï´Ù.
½ÇÇà:
Data Source;µ¥ÀÌÅͺ£À̽º;UID;PWD
(4) Configuration °ü·Ã Ãß°¡ÀûÀÎ Á¤º¸´Â ¾Æ·¡ URLÀ» Âü°íÇϼ¼¿ä.
Âü°í URL:
https://docs.microsoft.com/en-us/aspnet/core/fundamentals/configuration?tabs=basicconfiguration
°£¿µ¿ì ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä..
¿À·£¸¸¿¡ Áú¹® ¿Ã¸®³×¿ä..
.net core °ÀÇ º¸¸é¼ ¹é¿£µå ±¸ÃàÇÏ´Ù°¡ Àͼ÷ÇØÁöÁö°¡ ¾Ê¾Æ node.js·Î ¿ì¼± ±¸ÃàÇؼ ±×°£ »ç¿ëÇß¾ú´Âµ¥¿ä. ´Ù½Ã .net core·Î ±¸ÃàÇغ¸·Á´Ï ¸·È÷´Â ºÎºÐÀÌ ¹Ù·Î »ý°Ü¼ ¿©Â庾´Ï´Ù.
.net core ¿¡¼´Â appsettings.json¿¡ Ä¿³ØÆÃÁ¤º¸¸¦ ÀÔ·ÂÇÏ°í ºÒ·¯¿Í¼ »ç¿ëÇÏ´Â °ÍÀ» °Á¿¡¼ ¹è¿ü¾ú´Âµ¥¿ä.. ÀÌ ºÎºÐÀÇ database¸¦ ±×¶§±×¶§ ¸Â°Ô º¯°æÇؼ ¾²·Á°íÇÕ´Ï´Ù.
node¿¡¼´Â
const server_ip = '';
var config = {
user: 'aaa',
password: 'aaal',
server: server_ip ,
database:'aaa',
options: {
tdsVersion : '7_1'
}
}
module.exports = lconfig;
ÀÌ·±½ÄÀÇ jsÆÄÀÏÀ» ¸¸µé°í
config.database = req.params.db;
ÀÌ·±½ÄÀ¸·Î º¯°æÇؼ »ç¿ëÇß¾ú´Âµ¥¿ä .net core¿¡¼µµ ´ç¿¬È÷ µÉ°Í °°Àºµ¥ ¹æ¹ýÀ» ãÁö¸¦ ¸øÇÏ°Ú½À´Ï´Ù.
¾Ë·ÁÁֽøé Àß È°¿äÇØ º¸µµ·ÏÇÏ°Ú½À´Ï´Ù.
³¯¾¾°¡ Ãä³×¿ä °Ç° Á¶½ÉÇϼ¼¿ä~!
|