public List<ClienteModel> GetAll() { using (var context = new ClienteIndexContext()) { return (from m in context.Clientes select m).ToList(); } }
public void Update(ClienteModel cliente) { using (var context = new ClienteIndexContext()) { context.Entry(cliente).State = EntityState.Modified; context.SaveChanges(); } }
public List<ClienteModel> GetByName(string name) { using (var context = new ClienteIndexContext()) { return (from m in context.Clientes where m.Apellido.StartsWith(name) select m).ToList(); } }
public ClienteModel GetById(int id) { using (var context = new ClienteIndexContext()) { return (from m in context.Clientes where m.Id == id select m).SingleOrDefault(); } }
public void Create(ClienteModel cliente) { using (var context = new ClienteIndexContext()) { context.Clientes.Add(cliente); context.SaveChanges(); } }
public void Delete(int id) { using (var context = new ClienteIndexContext()) { var cliente = context.Clientes.Find(id); context.Clientes.Remove(cliente); context.SaveChanges(); } }