private static decimal LINQtoSQLUpdateTest() { List <decimal> testresults = new List <decimal>(); System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch(); var AWL2SContext = new AWL2SDataContext(); for (int j = 0; j < iInnerloop; j++) { var customers = from c in AWL2SContext.L2SCustomers select c; foreach (L2SCustomer cust in customers) { L2SCustomer o = cust; o.ModifiedDate = o.ModifiedDate.AddDays(1); } for (int iAdd = 0; iAdd < 10; iAdd++) { L2SCustomer cust = new L2SCustomer(); cust.NameStyle = true; cust.FirstName = "new"; cust.LastName = "cust"; cust.PasswordHash = "pw"; cust.PasswordSalt = "salt"; cust.rowguid = Guid.NewGuid(); cust.ModifiedDate = DateTime.Now; AWL2SContext.L2SCustomers.InsertOnSubmit(cust); } sw.Reset(); sw.Start(); AWL2SContext.SubmitChanges(); sw.Stop(); testresults.Add((decimal)sw.ElapsedMilliseconds); clearnewcusts(connectionString); } // figure out how long this took //toss first result, calc average of rest clearnewcusts(connectionString); testresults.Remove(0); return(testresults.Average()); }
partial void DeleteL2SCustomer(L2SCustomer instance);
partial void UpdateL2SCustomer(L2SCustomer instance);
partial void InsertL2SCustomer(L2SCustomer instance);