Mysql的.net用法

1.引入Dapper。
2.链接字符（支持中文）
“server=127.0.0.1;uid=root;pwd=;database=test;Charset=utf8”
3.创建链接生成Connect

  public IDbConnection GetConn( )
    {
        IDbConnection conn = null;
        AllInfo  Models = Common.JsonToIni.GetClass<AllInfo>(Common.ConfigFiles.ConfigFile);
        try
        {
            string Constr = $"server ={Models.InterInfo.DBAdd}; uid = {Models.InterInfo.UserName}; pwd ={Models.InterInfo.Pwd}; database = {Models.InterInfo.DBName}; Charset = utf8";
            using (conn = new MySqlConnection(Constr))
            {
                conn.Open(); 
            }
        }
        catch (Exception ex)
        {
            string ErrMsg = string.Format("{1}数据库连接错误，错误原因是:{0}", ex.Message,Models.InterInfo.DBAdd);
            Common.LogWrite.WriteLog(ErrMsg);
            conn = null; 
            //throw new Exception(ErrMsg);
        } 
        return conn;
    }

4. 获取list的方式是使用query

  using (IDbConnection conn = GetConn())
   {
                if (conn != null)
                {
                    string sql = $"SELECT * FROM `heart_beat_info`  where is_open ='1'  and network_id = {network_id}";
                    return conn.Query<heart_beat_info>(sql);
                }
                else
                {
                    return null;
                } 
            }