SQL 批量添加

最新推荐文章于 2024-07-03 13:27:00 发布

@朱较瘦

最新推荐文章于 2024-07-03 13:27:00 发布

阅读量1.3k

点赞数

本文链接：https://blog.csdn.net/zhulongxi/article/details/51769236

版权

  public static bool BulkInserToYoutubeTable(DataTable youtubeTable)
        {

            try
            {
                using (SqlBulkCopy sqlBC = new SqlBulkCopy(ConnectionString, SqlBulkCopyOptions.UseInternalTransaction))
                {
                    sqlBC.BatchSize = youtubeTable.Rows.Count;
                    sqlBC.BulkCopyTimeout = 100000000;
                    sqlBC.DestinationTableName = "FetchedVideoFeedEventSummary_Youtube_New";
                    sqlBC.ColumnMappings.Add("Resource", "Resource");
                    sqlBC.ColumnMappings.Add("Feedkey", "Feedkey");
                    sqlBC.ColumnMappings.Add("CurrentTime", "CurrentTime");
                    sqlBC.ColumnMappings.Add("ProcessTime", "ProcessTime");
                    sqlBC.ColumnMappings.Add("DownloadTime", "DownloadTime");
                    sqlBC.ColumnMappings.Add("DiscoveredVideos", "DiscoveredVideos");
                    sqlBC.WriteToServer(youtubeTable);
                    Console.WriteLine("Bulk Copy complete, total:{0},{1}", youtubeTable.Rows.Count, DateTime.Now.ToString());
                    return true;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Bulk Copy Error: {0} {1}", DateTime.Now.ToString(), ex.Message);
                return false;
            }
        }