C# 快速插入大量数据

static void Main(string[] args)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("name", typeof(string));
            dt.Columns.Add("type", typeof(string));
            //给dt内存表插入数据              
            for (int i = 0; i < 1000000; i++)
            {
                DataRow dr = dt.NewRow();
                dr["name"] = "测试" + i;
                dr["type"] = "内容" + i;
                //dt.Rows.Add("测试" + i);
                dt.Rows.Add(dr);
            }
            Console.WriteLine("====开始=====");
            System.Diagnostics.Stopwatch st = new System.Diagnostics.Stopwatch();
            st.Start();
            using (SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=1qa@WS3ed;database=a"))
            {
                conn.Open();
                using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn))
                {
                    try
                    {
                        //插入到数据库的目标表 TbA：表名  
                        bulkCopy.DestinationTableName = "[dbo].[a]";
                        //内存表的字段 对应数据库表的字段   
                        bulkCopy.ColumnMappings.Add("name", "names");
                        bulkCopy.ColumnMappings.Add("type", "b");
                        bulkCopy.WriteToServer(dt);
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex);
                    }
                }
            }
            st.Stop();
            Console.WriteLine("成功!测试时间为：" + st.ElapsedMilliseconds);
            Console.ReadKey();
        }