SqlBulkCopy来实现批量插入数据的功能

 DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[] { new DataColumn("n", typeof(int)),
                                                   new DataColumn("name", typeof(string)) });
            for (int i = 1; i < 1000; i++)
            {
                DataRow r = dt.NewRow();
                r["n"] = i;
                r["name"] = "test";
                dt.Rows.Add(r);
            }

            string connStr = "Data Source=.;Initial Catalog=testdb;UID=sa;PWD=test;";
            SqlConnection sqlcon = new SqlConnection(connStr);
            sqlcon.Open();

            using (SqlBulkCopy bulk = new SqlBulkCopy(connStr))
            {
                bulk.BatchSize = dt.Rows.Count;
                bulk.DestinationTableName = "test3";
                bulk.ColumnMappings.Add("n", "ID");
                bulk.ColumnMappings.Add("name", "Name");
                bulk.WriteToServer(dt);
            }
            sqlcon.Close();