mysql的sqlbulkcopy_SqlBulkCopy(批量复制)使用方法

最新推荐文章于 2024-06-06 13:53:12 发布

郭八怪

最新推荐文章于 2024-06-06 13:53:12 发布

阅读量828

点赞数

文章标签：笔记

本文链接：https://blog.csdn.net/gscsdnzy/article/details/129995210

版权

//批量新增数据
public void SqlBulkCopyByDatatable(string connectionString, string TableName, DataTable dt)
{
   using (SqlConnection conn = new SqlConnection(connectionString))
   {
       using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction))
       {
           try
           {
               sqlbulkcopy.DestinationTableName = TableName;
               sqlbulkcopy.BatchSize = 1000000;
               sqlbulkcopy.BulkCopyTimeout = 60;
               for (int i = 0; i < dt.Columns.Count; i++)
               {
                   sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
               }
               sqlbulkcopy.WriteToServer(dt);
           }
           catch (System.Exception ex)
           {
               throw ex;
           }
       }
   }
}