mysql批量上傳資料

標籤：

private object BlubckMysql(List<xiaoyao_blogs_pictureModel> list, string connect)        {            var sqllist = list.Select(item => string.Format(@"insert into xiaoyao_blogs_picture(classifyName,pictureUrl,pictureIntroduce,userName,addtime)values(‘{0}‘,‘{1}‘,‘{2}‘,‘{3}‘,‘{4}‘)", item.classifyName, item.pictureUrl, item.pictureIntroduce, item.userName, item.addtime)).ToList();            using (var  conn = new MySqlConnection(connect))            {                conn.Open();                MySqlCommand cmd = new MySqlCommand();                cmd.Connection = conn;                MySqlTransaction tx = conn.BeginTransaction();                cmd.Transaction = tx;                try                {                    for (int n = 0; n < sqllist.Count; n++)                    {                        string strsql = sqllist[n].ToString();                        if (strsql.Trim().Length > 1)                        {                            cmd.CommandText = strsql;                           var a=cmd.ExecuteNonQuery();                        }                         //每500次開啟一次事物                        if (n > 0 && (n % 500 == 0 || n == sqllist.Count - 1))                        {                            tx.Commit();                            tx = conn.BeginTransaction();                        }                    }                                  }                catch (System.Data.SqlClient.SqlException E)                {                    tx.Rollback(); throw new Exception(E.Message);                }            }            return null;        }

 

mysql批量上傳資料