class Program
{
static void Main(string[] args)
{
Stopwatch sw = new Stopwatch();
DataTable dt = GetTableSchema();
for (int i = ; i < ; i++)
{
DataRow r = dt.NewRow();
//0行未自增列，为空就好
r[] = i;
r[] = string.Format("User-{0}", i);
r[] = (decimal)i;
r[] = DateTime.Now;
r[] = i;
r[] = string.Format("remak-{0}", i);
r[] = ;
r[] = true;
dt.Rows.Add(r);
}
sw.Start();
BulkToDB(dt);
sw.Stop();
Console.WriteLine(string.Format("Elapsed Time is {0} Milliseconds", sw.ElapsedMilliseconds));
Console.ReadLine();
}
public static void BulkToDB(DataTable dt)
{
SqlConnection sqlConn = new SqlConnection(
ConfigurationManager.ConnectionStrings["wolfTest"].ConnectionString);
SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConn);
bulkCopy.DestinationTableName = "wolf_example";
bulkCopy.BatchSize = dt.Rows.Count;
try
{
sqlConn.Open();
if (dt != null && dt.Rows.Count != )
bulkCopy.WriteToServer(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlConn.Close();
if (bulkCopy != null)
bulkCopy.Close();
}
}
public static DataTable GetTableSchema()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[]{
new DataColumn("Num",typeof(int)),
new DataColumn("Type",typeof(int)),
new DataColumn("Name",typeof(string)),
new DataColumn("Money",typeof(decimal)),
new DataColumn("CTime",typeof(DateTime)),
new DataColumn("UserID",typeof(int)),
new DataColumn("Remak",typeof(string)),
new DataColumn("Sex",typeof(int)),
new DataColumn("IsShow",typeof(bool)),
});
return dt;
}
}