public void DataEdit()
{
var dataList = CommonHelper.GetTestListDto(5000);
var dataListTwo = CommonHelper.GetTestListDtoTwo(5000);
var table = SqlBulkCopyHelper.ListToTable(dataList, "BulkTest");
var tableTwo = SqlBulkCopyHelper.ListToTable(dataListTwo, "BulkTestTwo");
var tableUpdate = SqlCoreHelper.ExecuteDataSetText("select top 5000 Id,FieldD from BulkTest order by FieldU asc", null).Tables[0];
var tableTwoUpdate = SqlCoreHelper.ExecuteDataSetText("select top 5000 Id,FieldD from BulkTestTwo order by FieldU asc", null).Tables[0];
foreach (DataRow item in tableUpdate.Rows)
{
item["FieldD"] = "555";
}
foreach (DataRow item in tableTwoUpdate.Rows)
{
item["FieldD"] = "666";
}
tableUpdate.TableName = "BulkTest";
tableTwoUpdate.TableName = "BulkTestTwo";
Stopwatch sw = new Stopwatch();
sw.Start();
SqlBulkCopyHelper.BulkEditTables(new List <DataTable>()
{
table, tableTwo
}, new List <DataTable>()
{
tableUpdate, tableTwoUpdate
});
sw.Stop();
string bb = sw.Elapsed.TotalSeconds.ToString();
Console.WriteLine(bb);
}
public void DataInsert()
{
var dataList = CommonHelper.GetTestListDto(5000);
var dataListTwo = CommonHelper.GetTestListDtoTwo(5000);
var table = SqlBulkCopyHelper.ListToTable(dataList, "BulkTest");
var tableTwo = SqlBulkCopyHelper.ListToTable(dataListTwo, "BulkTestTwo");
Stopwatch sw = new Stopwatch();
sw.Start();
SqlBulkCopyHelper.BulkInsertTables(new List <DataTable>()
{
table, tableTwo
}).Wait();
sw.Stop();
string bb = sw.Elapsed.TotalSeconds.ToString();
Console.WriteLine(bb);
}