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();
            }
        }