用.NET SqlBulkCopy类执行批量复制

using System;

using System.Collections.Generic;

using System.Text;

using System.Data.SqlClient;

namespace BCP {

class Program {

static void Main(){

string cString = "Data Source=(local);User ID=tester;Password=tester;Initial Catalog=Northwind;";

using (SqlConnectionconn = new SqlConnection(cString)){
conn.Open();
SqlCommandcomm = new SqlCommand("SELECT EmployeeID, FirstName, LastName, HomePhone FROM Employees;", conn);
SqlDataReader reader = comm.ExecuteReader();

using (SqlConnection conn2 = new SqlConnection(cString)){

conn2.Open();

using (SqlBulkCopybcp = new SqlBulkCopy(conn2)){
bcp.DestinationTableName = "dbo.Employees_bcp";

try {
bcp.WriteToServer(reader);

} catch (Exception ex) {
Console.WriteLine(ex.Message);

} finally {
reader.Close();

} } } } } } }