public void InsertAddressWithAddRangeWithoutTransaction(IEnumerable <Address> addresses)
{
using (var ebayDatabaseFirstContext = new EbayDatabaseFirstDbContext())
{
ebayDatabaseFirstContext.Address.AddRange(addresses);
ebayDatabaseFirstContext.SaveChanges();
}
}
public void CleanAddressData()
{
using (var ebayDatabaseFirstContext = new EbayDatabaseFirstDbContext())
{
ebayDatabaseFirstContext.Database.ExecuteSqlInterpolated($"delete from common.Address where Id > 3");
ebayDatabaseFirstContext.Database.ExecuteSqlInterpolated($"DBCC CHECKIDENT ('common.Address', RESEED, 3)");
}
}
public void InsertCustomerWithAddRangeWithoutTransaction(IEnumerable <Customer> customers)
{
using (var ebayDatabaseFirstContext = new EbayDatabaseFirstDbContext())
{
ebayDatabaseFirstContext.Customer.AddRange(customers);
ebayDatabaseFirstContext.SaveChanges();
}
}
public void CleanCustomerData()
{
using (var ebayDatabaseFirstContext = new EbayDatabaseFirstDbContext())
{
ebayDatabaseFirstContext.Database.ExecuteSqlInterpolated($"delete from common.Customer where Id > 5");
ebayDatabaseFirstContext.Database.ExecuteSqlInterpolated($"DBCC CHECKIDENT ('common.Customer', RESEED, 5)");
}
}
public void DeleteAddressesWithAuditing(IEnumerable <Address> addresses)
{
using (var ebayDatabaseFirstDbContext = new EbayDatabaseFirstDbContext())
{
ebayDatabaseFirstDbContext.Address.RemoveRange(addresses);
ebayDatabaseFirstDbContext.SaveChanges();
}
}
public void InsertAddressWithAddWithoutTransactionSaveChangesBefore(IEnumerable <Address> addresses)
{
using (var ebayDatabaseFirstContext = new EbayDatabaseFirstDbContext())
{
foreach (var address in addresses)
{
InsertAddressWithAdd(ebayDatabaseFirstContext, address);
ebayDatabaseFirstContext.SaveChanges();
}
}
}
public void Save(Customer customer)
{
try
{
using (var ebayDatabaseFirstContext = new EbayDatabaseFirstDbContext())
{
ebayDatabaseFirstContext.Customer.Add(customer);
ebayDatabaseFirstContext.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
public void InsertCustomerAndAddressWithAddWithoutTransaction(IEnumerable <Customer> customers, IEnumerable <Address> addresses)
{
using (var ebayDatabaseFirstContext = new EbayDatabaseFirstDbContext())
{
foreach (var address in addresses)
{
ebayDatabaseFirstContext.Address.Add(address);
}
foreach (var customer in customers)
{
ebayDatabaseFirstContext.Customer.Add(customer);
}
ebayDatabaseFirstContext.SaveChanges();
}
}
private void InsertAddressWithAdd(EbayDatabaseFirstDbContext ebayDatabaseFirstContext, Address address)
{
ebayDatabaseFirstContext.Address.Add(address);
}
