ASP.NET的SqlBulkCopy用法

来源：互联网发布：js before 编辑：程序博客网时间：2024/05/21 00:49

微软封装了一个类，号称百万条数据秒插数据库，它就是SqlBulkCopy

现在让我们来看看怎么使用吧

 /// <summary>        /// DataTale整张表数据插入数据        /// </summary>        /// <param name="dt">要插入的table数据</param>        /// <param name="tableName">目标数据表名</param>        /// <param name="fieldName">必须提供所有的字段</param>        /// <returns>返回成功，或者失败 true  or false</returns>        public static bool SqlBulkInsert(DataTable dt, string tableName,string[] fieldName)        {              using (SqlConnection conn = new SqlConnection(Conn.ConnString))            {                conn.Open();                using (SqlBulkCopy bulk = new SqlBulkCopy(Conn.ConnString))                {                    try                    {                        //when the table data handle done                        bulk.DestinationTableName = tableName;                        for (int i = 0; i < fieldName.Length; i++)                        {                            bulk.ColumnMappings.Add(fieldName[i], fieldName[i]);                        }                        bulk.WriteToServer(dt);                        //去重                        using (SqlCommand cmd = conn.CreateCommand())                        {                            StringBuilder temp = new StringBuilder();                            temp.AppendFormat(" delete from {0} where IsDelete=1 and Name in( ", tableName);                            temp.AppendFormat(" select distinct Name from {0} where IsDelete=1 group by Name having COUNT(Name)>1) and ", tableName);                            temp.AppendFormat(" Id not in(select min(Id) from {0} where IsDelete=1  group by Name having COUNT(Name)>1) ", tableName);                            cmd.CommandText = temp.ToString();                            cmd.ExecuteNonQuery();                         }                         return true;                    }                    catch                     {                        return false;                    }                    finally                    {                        conn.Close();                        bulk.Close();                    }                }            }        }

超简单！！！

0 0