public static Customer Update(Customer c)
{
BookRegContext context = new BookRegContext();
context.Entry(c).State = EntityState.Modified;
context.SaveChanges();
return(c);
}
public static Customer AddCustomer(Customer c)
{
BookRegContext context = new BookRegContext();
context.Customer.Add(c);
context.SaveChanges();
return(c);
}
public static void AddBook(Book b)
{
//Database context
BookRegContext context = new BookRegContext();
//Create insert query
//Adds insert to a list of pending queries
context.Book.Add(b);
//Executes all pending Insert/Update/Delete
context.SaveChanges();
}
public static void DeleteCustomer(Customer c)
{
var context = new BookRegContext();
//context.Customer.Attach(c);
//context.Customer.Remove(c);
//Alternative
context.Entry(c).State =
System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
public static void DeleteCustomer(Customer c)
{
BookRegContext context = new BookRegContext();
//Telling Entity Framework (EF) that the customer
//exists, and we want it removed from the DB
//context.Customer.Attach(c);
//context.Customer.Remove(c);
//ALTERNATIVE
context.Entry(c).State = EntityState.Deleted;
context.SaveChanges();
}