MySql Fatal error encountered during data read.

最新推荐文章于 2023-09-01 16:12:10 发布

weixin_34405354

最新推荐文章于 2023-09-01 16:12:10 发布

阅读量3.5k

点赞数

文章标签：数据库 c# python

原文链接：https://my.oschina.net/lichaoqiang/blog/477310

版权

2019独角兽企业重金招聘Python工程师标准>>>

代码：

/// <summary>
        /// 执行SQL,返回DataReader对象
        /// </summary>
        /// <param name="cmdText"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
        public System.Data.IDataReader ExcuteDataReader(string cmdText, System.Collections.IEnumerable parameters)
        {
            IDataReader dataReader = null;
            IDbConnection connection = CreateDbConnection();
            //Command
            IDbCommand command = new MySqlCommand(cmdText);

            IDbCommand commandTimeout = new MySqlCommand("set net_write_timeout=99999;set net_read_timeout=99999");
            commandTimeout.Connection = connection;
            commandTimeout.ExecuteNonQuery();

            command.Connection = connection;
            PreDbCommand(command, parameters);
            //
            dataReader = command.ExecuteReader(CommandBehavior.CloseConnection);

            //创建Command
            return dataReader;
        }

转载于:https://my.oschina.net/lichaoqiang/blog/477310