using MySql.Data.MySqlClient;
using System.Configuration;
using System.Data;

namespace GCAS.Code
{
    public class DataBaseConfig
    {
        private static readonly string DefaultSqlConnectionString = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None).ConnectionStrings.ConnectionStrings["myconn"].ToString();
        public static IDbConnection GetSqlConnection(string sqlConnectionString = null)
        {
            if (string.IsNullOrEmpty(sqlConnectionString))
            {
                sqlConnectionString = DefaultSqlConnectionString;
            }
            IDbConnection conn = new MySqlConnection(sqlConnectionString);
            conn.Open();
            return conn;
        }
    }
}