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