using System;
using System.Collections.Generic;
using System.Text;

namespace Db_Core
{
    public enum SqlConnString
    {
        GAMEPORTAL
    };


    public enum ConnectionType
    {
        ORACLE = 1,
        POSTGRE = 2,
        MYSQL = 3
    }

    public abstract class SqlCommon
    {
        public static string[] ConnectionStrings = new string[]
        {
            @"Data Source=(DESCRIPTION =
              (LOAD_BALANCE=YES)
                (ADDRESS = (PROTOCOL = TCP)(HOST = 171.244.50.177)(PORT = 1530))
                (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = orcl)
                )
              ); User ID=myt_luckycall;Password=myt_luckycall;Max Pool Size=3;persist security info=false;Connection Timeout=120;Validate connection=true;",
             //@"Data Source=(DESCRIPTION =
             // (LOAD_BALANCE=YES)
             //   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.78.3.95)(PORT = 1521))
             //   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.78.3.96)(PORT = 1521))
             //   (CONNECT_DATA =
             //     (SERVER = SHARED)
             //     (SERVICE_NAME = stl_vasext)
             //   )
             // );  User ID=LUCKY_CARD;Password=LCkYCd#20$21;Max Pool Size=3;persist security info=false;Connection Timeout=120;Validate connection=true;"

        };

        public static string GetConnectionString(SqlConnString str)
        {
            return ConnectionStrings[(int)str];
        }
    }
}