1.後端批量插入代碼
using (var connection = new System.Data.SqlClient.SqlConnection("data source=XXX;initial catalog=XXX;persist security info=True;user id=XXX;password=XXX;"))
{
connection.Open();
var sql = "INSERT INTO XXX VALUES(@Code, @AddTime, @AddUser, @ControllerName, @ActionName, @Remark)";
var list = new List<XXX>();
Enumerable.Range(0, 10).ToList().ForEach(x =>
{
list.Add(new XXX
{
Code = DateTime.Now.ToString($"{x}-yyyy-MM-dd HH:mm:ss.ffff"),
AddTime = DateTime.Parse("2021-01-01"),
AddUser = $"AddUser-{x}",
ControllerName = $"ControllerName-{x}",
ActionName = $"ActionName-{x}",
Remark = $"Remark-{x}",
});
});
var result = connection.Execute(sql, list);
}
}
2.通過Microsoft SQL Server Manager Studio的Sql Server ProFiler【Tools/Sql Server ProFiler】可以看到多條插入記錄,是以資料量大了通過【步驟1】批量添加速度達不到預期
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsISPrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdsATOfd3bkFGazxCMx8VesATMfhHLlN3XnxCMwEzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5SOkhjNjZWN4E2M2gTMzEGZ4cDZ3YDN2AjZjNmM4MTM48CXwMzLchDMxIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLzM3Lc9CX6MHc0RHaiojIsJye.png)
INSERT INTO XXX(Code, AddTime, AddUser, ControllerName, ActionName, Remark)
VALUES(@Code0, @AddTime0, @AddUser0, @ControllerName0, @ActionName0, @Remark0)
,(@Code1, @AddTime1, @AddUser1, @ControllerName1, @ActionName1, @Remark1)
,(@Code2, @AddTime2, @AddUser2, @ControllerName2, @ActionName2, @Remark2)