public decimal GetDeleteTimeStatisticsAddRangeWithDbContextRecycle(bool useDbSetToSave) { var fifteenThousandAddressWithoutId = MakeFifteenThousandAddress(generateIncrementalId: false); var amazonAddressInsertLabMapper = new AmazonAddressInsertLabMapper(); var amazonAddressDeleteLabMapper = new AmazonAddressDeleteLabMapper(); var fiveThousandUpdatesTimes = new List <decimal>(); using (var amazonCodeFirstContext = new AmazonCodeFirstDbContext()) { amazonAddressInsertLabMapper.CleanAddressData(amazonCodeFirstContext); } amazonAddressInsertLabMapper.InsertAddressWithDbSetWithAddRange(fifteenThousandAddressWithoutId); for (int i = 0; i < 3; i++) { var fiveThousandAddress = MakeFiveThousandAddress((i * 5000) + 4); using (var amazonCodeFirstContext = new AmazonCodeFirstDbContext()) { var fiveThousandUpdateTime = useDbSetToSave ? amazonAddressDeleteLabMapper.DeleteAddressWithDbSetWithAddRange(amazonCodeFirstContext, fiveThousandAddress) : amazonAddressDeleteLabMapper.DeleteAddressWithDbContextWithAddRange(amazonCodeFirstContext, fiveThousandAddress); fiveThousandUpdatesTimes.Add(fiveThousandUpdateTime); } } var fiveThousandUpdateTimeAverage = Enumerable.Average(fiveThousandUpdatesTimes); var insertTime = decimal.Divide(fiveThousandUpdateTimeAverage, 5_000); return(insertTime); }
public decimal GetDeleteTimeStatisticsAddRange(bool useDbSetToSave) { var fifteenThousandAddressWithoutId = MakeFifteenThousandAddress(generateIncrementalId: false); var fifteenThousandAddress = MakeFifteenThousandAddress(generateIncrementalId: true); var amazonAddressInsertLabMapper = new AmazonAddressInsertLabMapper(); var amazonAddressDeleteLabMapper = new AmazonAddressDeleteLabMapper(); using (var amazonCodeFirstContext = new AmazonCodeFirstDbContext()) { amazonAddressInsertLabMapper.CleanAddressData(amazonCodeFirstContext); amazonAddressInsertLabMapper.InsertAddressWithDbSetWithAddRange(fifteenThousandAddressWithoutId); var deleteTimeAllRecords = useDbSetToSave ? amazonAddressDeleteLabMapper.DeleteAddressWithDbSetWithAddRange(fifteenThousandAddress) : amazonAddressDeleteLabMapper.DeleteAddressWithDbContextWithAddRange(fifteenThousandAddress); var deleteTime = decimal.Divide(deleteTimeAllRecords, fifteenThousandAddress.Count()); return(deleteTime); } }