BaseRepo

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

namespace Data.Dapper.Class
{
    public abstract class BaseRepository
    {
        public string connstringSQL = ConfigurationManager.ConnectionStrings["SqlServerConnString"].ConnectionString;

        public MySqlConnection GetMySqlConnection(bool open = true,
            bool convertZeroDatetime = false, bool allowZeroDatetime = false)
        {
            string cs = "Server=xxx;Port=41890;Database=yyy;Uid=zzz;Pwd=db;";
            var csb = new MySqlConnectionStringBuilder(cs)
            {
                AllowZeroDateTime = allowZeroDatetime,
                ConvertZeroDateTime = convertZeroDatetime
            };
            var conn = new MySqlConnection(csb.ConnectionString);
            if (open) conn.Open();
            return conn;
        }
    }
}