private static void Method_Four_EF_SP(List <Order> orders)
{
Console.WriteLine("EntityFrameWork XML StoreProcedore");
string xmlText = XMLSERIL.SerializeObj <List <Order> >(orders);
using (WebApiEntities entities = new WebApiEntities())
{
var res = entities.InsertFromXML(xmlText);
}
Console.WriteLine("Total Batch Size Is :" + System.Text.ASCIIEncoding.Unicode.GetByteCount(xmlText) / 1000000 + " mb");
}
private static void Method_Three_EF_XTBulkInsert(List <Order> orders, Watch watch)
{
Console.WriteLine("EntityFrameWork BulkInsert Extension");
watch.start();
using (WebApiEntities entities = new WebApiEntities())
{
entities.BulkInsert <Order>(orders, options =>
{
options.BatchSize = orders.Count;
options.BatchTimeout = 180;
});
//var res = entities.InsertFromXML(xmlText);
}
watch.End($"result: BulkInsert " + orders.Count + " Rows In : ");
}
private static void Method_Two_EF(List <Order> orders, Writer writer, Watch watch)
{
Console.WriteLine("EntityFrameWork AddRange And SaveChanges");
using (WebApiEntities entities = new WebApiEntities())
{
///entities.Orders.AddRange(orders);
watch.start();
writer.Write("Insert " + orders.Count + " Lines Start!");
watch.start();
entities.Orders.AddRange(orders);
entities.SaveChanges();
watch.End("result: " + orders.Count() + " Insert In :");
}
try
{
}
catch (Exception)
{
throw;
}
}
