C#(.Net)知识点记录-优快云博客

一：批量插入"SqlBulkCopy"的应用

PS:"SqlBulkCopy"的官方释义："Lets you efficiently bulk load a SQL Server table with data from another source"；命名空间：System.Data.SqlClient；是一种比较高效的批量数据插入的方式

工作中用到的SqlBulkCopy示例代码

public static void SqlBulkCopyByDatatable(string tableName, DataTable dt)
{
 using (var connection = new SqlConnection(connectionString))
 {
  using (var sqlbulkcopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction))
  {
   sqlbulkcopy.DestinationTableName = tableName;
   for (int i = 0; i < dt.Columns.Count; i++)
   {
    sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
   }
    sqlbulkcopy.WriteToServer(dt);
    connection.Close();
  }
 }
}

[HttpPost]
public ActionResult BuildQrCode(int count)
{
   //获取目前最大的编号
   var maxCode = CompanyManager.GetMaxCode();
   var jss = new JavaScriptSerializer();
   var wx = new WxHandleContainer(_appId, _secret);
   var accessToken = wx.GetToken();
   var dt = new DataTable();
   dt.Columns.Add("Code");
   dt.Columns.Add("AgentId");
   dt.Columns.Add("ImagePath");
   dt.Columns.Add("Status");
   for(var i=0;i<count;i++)
   {
      var dr = dt.NewRow();
      var code = GetCode(maxCode);
      maxCode = code;
      dr["Code"] = code;
      dr["AgentId"] = 0;
      dr["ImagePath"] = GetImagePath(code,jss,accessToken);
      dr["Status"] = 0;
      dt.Rows.Add(dr);
   }
   CompanyManager.SqlBulkCopyByDatatable("dbo.FuiouQrCode", dt);
   return Json(new { statu = "success"}, JsonRequestBehavior.AllowGet);