SQL 批量添加

来源：互联网发布：智能聊天机器人软件编辑：程序博客网时间：2024/05/22 03:16
  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;            }        }
0 0