C#高效插入sql数据库数据

创建表：

CREATE TABLE Product(
Id UNIQUEIDENTIFIER PRIMARY KEY,
NAME VARCHAR(50) NOT NULL,
Price DECIMAL(18,2) NOT NULL
)

c#代码：

   void InsertTwo()
        {
            Console.WriteLine("使用Bulk插入的实现方式");
            Stopwatch sw = new Stopwatch();
            DataTable dt = GetTableSchema();


            using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=AIS20170511104745;Persist Security Info=True;User ID=sa;Password=sa123456"))
            {
                SqlBulkCopy bulkCopy = new SqlBulkCopy(conn);
                bulkCopy.DestinationTableName = "Product";
                bulkCopy.BatchSize = dt.Rows.Count;
                conn.Open();
                sw.Start();


                for (int i = 0;