public void InsertAddressWithAddWithoutTransactionSaveChangesAfter() { var ebayTransactionLabMapper = new EbayTransactionLabMapper(); ebayTransactionLabMapper.CleanAddressData(); var address = new List <Address>() { new Address() { Street = "5000 Gandy Street", ZipPostCode = "13057", City = "East Syracuse" }, new Address() { Street = "354 Cemetery Street", ZipPostCode = "95004", City = "Aromas" }, new Address() { Street = "2031 Reppert Coal Road", ZipPostCode = "45232", City = "Cincinnati" } // Street larger than the field in the database }; try { ebayTransactionLabMapper.InsertAddressWithAddWithoutTransactionSaveChangesAfter(address); } catch (Exception ex) { // The records don't be inserted because SaveChanges was used after the error record was added throw; } }
public void InsertCustomerAndAddressWithAddRangeWithoutTransactionWithDbContextRecycle() { var ebayTransactionLabMapper = new EbayTransactionLabMapper(); ebayTransactionLabMapper.CleanCustomerData(); ebayTransactionLabMapper.CleanAddressData(); var address = new List <Address>() { new Address() { Street = "5000 Gandy Street", ZipPostCode = "13057", City = "East Syracuse" }, new Address() { Street = "354 Cemetery Street", ZipPostCode = "95004", City = "Aromas" } }; var customers = new List <Customer>() { new Customer() { Name = "Eleanor A Gutierrez", Birthday = new DateTime(1956, 3, 29), Email = "*****@*****.**", Cpf = "62844343082", AddressId = 4 }, new Customer() { Name = "Joseph W Barnes", Birthday = new DateTime(1958, 1, 26), Email = "*****@*****.**", Cpf = "7829693200811", AddressId = 1 }, // Cpf larger than the field in the database new Customer() { Name = "Leslie M Bump", Birthday = new DateTime(1980, 8, 14), Email = "*****@*****.**", Cpf = "16325104056", AddressId = 2 } }; try { ebayTransactionLabMapper.InsertAddressWithAddRangeWithoutTransaction(address); ebayTransactionLabMapper.InsertCustomerWithAddRangeWithoutTransaction(customers); } catch (Exception ex) { // The Address records will be inserted because SaveChanges was used in a diferent context of Customer records throw; } }