public List<CreditCard> GetAll() { using (_db = new MyCoolDbEntities()) { return _db.CreditCards.ToList(); } }
public CreditCard GetById(int id) { using (_db = new MyCoolDbEntities()) { return _db.CreditCards.Where(c => c.Id == id).SingleOrDefault(); } }
public void Delete(CreditCard model) { using (_db = new MyCoolDbEntities()) { var entity = _db.CreditCards.Where(c => c.Id == model.Id).SingleOrDefault(); _db.CreditCards.DeleteObject(entity); _db.SaveChanges(); } }
public void Insert(CreditCard model) { using (_db = new MyCoolDbEntities()) { _db.CreditCards.AddObject(model); _db.SaveChanges(); } }
public void Update(CreditCard entity) { using (_db = new MyCoolDbEntities()) { _db.CreditCards.Attach(entity); _db.ObjectStateManager.ChangeObjectState(entity, System.Data.EntityState.Modified); _db.CreditCards.ApplyCurrentValues(entity); _db.SaveChanges(); } }