public ActionResult BuscarCliente(string cliente)
        {
            List <ClienteResponse> listadoCliente = new List <ClienteResponse>();

            try
            {
                using (var db = new CursoMVCEntities())
                {
                    listadoCliente = db.Database
                                     .SqlQuery <ClienteResponse>("EXEC dbo.spBuscarCliente {0}", cliente)
                                     .ToList();
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(Json(listadoCliente, JsonRequestBehavior.AllowGet));
        }
        // GET: User
        public ActionResult Index()
        {
            List <UserTableViewModel> lista = null;

            using (CursoMVCEntities db = new CursoMVCEntities())
            {
                lista = db.user
                        .Where(x => x.idState == 1)
                        .Select(x => new UserTableViewModel
                {
                    Email = x.email,
                    Id    = x.id,
                    Edad  = x.edad
                })
                        .OrderBy(x => x.Email)
                        .ToList();
            }

            return(View(lista));
        }