MSSQL 접속 Template 코드

using System.Data.SqlClient;
using System;
 
namespace JGTestLibs
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = getConnectionString("192.168.0.10","dbname","sa","password");
 
            try
            {
                conn.Open();
                Console.WriteLine("데이터베이스 연결성공..");
                
            }
            catch(Exception e)
            {
                Console.WriteLine("데이터베이스 연결 실패..");
                Console.WriteLine("LOG >>> "+e.ToString());
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
                Console.WriteLine("데이터베이스 연결해제");
            }
        }
        
        static private string getConnectionString(string ipaddr, string dbname, string id, string password)
        {
            return "Server=" + ipaddr + ";database=" + dbname + ";uid="+id+";pwd="+password+";";
        }
    }
}