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; } }