SqlBulkCopy¸ßЧ²åÈëÊý¾Ý

/// <summary>

• /// ʹÓÃSqlBulkCopy·½Ê½²åÈëÊý¾Ý
• /// </summary>
• /// <returns></returns>
• private static long SqlBulkCopyInsert()
• {
• Stopwatch stopwatch = new Stopwatch();
• stopwatch.Start();
• DataTable dataTable = GetTableSchema();
• for (int i = 0; i < count; i++)
• {
• DataRow dataRow = dataTable.NewRow();
• dataRow[2] = Guid.NewGuid();
• dataTable.Rows.Add(dataRow);
• }
• //Console.WriteLine(stopwatch.ElapsedMilliseconds);//³õʼ»¯Êý¾Ýʱ¼ä
• SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(SqlHelper.SqlConnection);
• sqlBulkCopy.DestinationTableName = "Passport";
• if (dataTable != null && dataTable.Rows.Count != 0)
• {
• sqlBulkCopy.WriteToServer(dataTable);
• }
• sqlBulkCopy.Close();
• stopwatch.Stop();
• return stopwatch.ElapsedMilliseconds;
• }

תÔØÓÚ:https://www.cnblogs.com/hs0811/p/3276860.html