使用SqlBulkCopy批量导入数据库的示例
VS建立控制台应用(.NET Framework)项目(SqlBurkCopyDemo),代码如下:
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace SqlBurkCopyDemo
{
public class Program
{
static void Main(string[] args)
{
Console.WriteLine("正在插入测试数据");
TimeSpan span = new TimeSpan();
try
{
//Copy copy = new Copy();
//span = copy.InsertData();
span = InsertData();
}
catch (Exception ex)
{
Console.WriteLine("异常!");
}
Console.WriteLine("共花费时间" + span.ToString() + "秒");
Console.ReadLine();
}
public static