private static void InsertCustomer(Customer customer)
{
using (var context = new DataAccess.AdventureWorksLTContext())
{
context.Set <Customer>().Add(customer);
context.SaveChanges();
}
}
//Question 3.
//1) Write a method to create test data for Employees table (seeding data).
private static void CreateEmployeeTestData(List <Employee> employees)
{
using (var context = new DataAccess.AdventureWorksLTContext())
{
foreach (var employee in employees)
{
context.Set <Employee>().Add(employee);
}
context.SaveChanges();
}
}
//Create
private static void InsertCustomers(List <Customer> customers)
{
using (var context = new DataAccess.AdventureWorksLTContext())
{
foreach (var customer in customers)
{
context.Set <Customer>().Add(customer);
}
context.SaveChanges();
}
}
//Delete
// DeleteCustomers??? Do we really need to delete many customers at the same time? What are the requirements for that?
// Do we delete them by id range or what would be the parameters?
private static void DeleteCustomerById(int id)
{
using (var context = new DataAccess.AdventureWorksLTContext())
{
var customer = context.Customer
//.Include(c => c.SalesOrderHeader)
//.Include(c => c.CustomerAddress)
.SingleOrDefault(c => c.CustomerId == id);
context.Set <Customer>().Remove(customer);
context.SaveChanges();
}
}
