public void InsertAddressWithAddRangeWithoutTransaction()
{
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.InsertAddressWithAddRangeWithoutTransaction(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;
}
}