public Customer Insert(Customer customer)
 {
     using (INFODYNAMICSEntities db = new INFODYNAMICSEntities())
     {
         db.Customers.Add(customer);
         db.SaveChanges();
         return(customer);
     }
 }
 public void Update(Customer customer)
 {
     using (INFODYNAMICSEntities db = new INFODYNAMICSEntities())
     {
         db.Customers.Attach(customer);
         db.Entry(customer).State = EntityState.Modified;
         db.SaveChanges();
     }
 }
 public void Delete(Customer customer)
 {
     using (INFODYNAMICSEntities db = new INFODYNAMICSEntities())
     {
         db.Customers.Attach(customer);
         db.Customers.Remove(customer);
         db.SaveChanges();
     }
 }