public static void DeleteCustomer(Customer c)
{
using (var context = new BookRegistrationEntities())
{
context.Customer.Add(c); // "Track" with EF
context.Entry(c).State = EntityState.Deleted; // Tell EF we are removing it
int rowsAffected = context.SaveChanges(); // Update on database
// int rowsAffected is optional
}
}
public static Customer UpdateCustomer(Customer c)
{
using (var context = new BookRegistrationEntities())
{
context.Customer.Add(c); // Add to context
// Tell EF we are updating an existing entity
context.Entry(c).State = EntityState.Modified; // Tell EF it has been modified
context.SaveChanges();
return(c);
}
}
/// <summary>
/// Adds a customer. Returns the newly added customer
/// with the CustomerID populated
/// </summary>
/// <param name="c">The new Customer to be added</param>
/// <returns></returns>
public static Customer AddCustomer(Customer c)
{
using (var context = new BookRegistrationEntities())
{
context.Customer.Add(c);
// SaveChanges MUST BE CALLED for insert/update/delete
context.SaveChanges();
// Return newly added customer with CustomerID populated
return(c);
}
}