使用SqlBulkCopy方式插入数据

最新推荐文章于 2020-12-08 08:35:45 发布

feitiandezhu1399

最新推荐文章于 2020-12-08 08:35:45 发布

阅读量256

点赞数

文章标签： SqlBulkCopy sqlserver c#向数据库批量插入数据使用SqlBulkCopy方式插入数据 c#

本文链接：https://blog.csdn.net/feitiandezhu1399/article/details/85088434

版权

         /// <summary>
        /// 使用SqlBulkCopy方式插入数据
        /// </summary>
        /// <param name="dt">批量插入的数据</param>
        /// <param name="tableName">插入到数据库中的表名称</param>
        /// <returns name="long">返回批量插入用时长</returns>
        public long SqlBulkCopyInsert(DataTable dt, string tableName)
        {
            var setting = ConfigurationManager.ConnectionStrings[APP.DB_DEFAULT_CONN_NAME];
            string connectionString = setting.ConnectionString;
            //测量运行时间
            Stopwatch stopwatch = new Stopwatch();
            stopwatch.Start();
            SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(connectionString);
            sqlBulkCopy.DestinationTableName = tableName;
            sqlBulkCopy.BatchSize = dt.Rows.Count;
            SqlConnection sqlConnection = new SqlConnection(connectionString);
            sqlConnection.Open();
            if (dt != null && dt.Rows.Count != 0)
            {
                sqlBulkCopy.WriteToServer(dt);
            }
            sqlBulkCopy.Close();
            sqlConnection.Close();
            stopwatch.Stop();
            return stopwatch.ElapsedMilliseconds;
        }