public T ObtenerPorId(int id) { using (var db = new AplicacionDBContext()) { return(db.Set <T>().FirstOrDefault(x => x.Id == id)); } }
public int Contar(Expression <Func <T, bool> > where) { using (var db = new AplicacionDBContext()) { return(db.Set <T>().Where(where).Count()); } }
public IEnumerable <T> EncontrarPor(ParametrosDeQuery <T> parametrosDeQuery) { var orderByClass = ObtenerOrderBy(parametrosDeQuery); Expression <Func <T, bool> > whereTrue = x => true; var where = (parametrosDeQuery.Where == null) ? whereTrue : parametrosDeQuery.Where; using (AplicacionDBContext db = new AplicacionDBContext()) { if (orderByClass.IsAscending) { return(db.Set <T>().Where(where).OrderBy(orderByClass.OrderBy) .Skip((parametrosDeQuery.Pagina - 1) * parametrosDeQuery.Top) .Take(parametrosDeQuery.Top).ToList()); } else { return(db.Set <T>().Where(where).OrderByDescending(orderByClass.OrderBy) .Skip((parametrosDeQuery.Pagina - 1) * parametrosDeQuery.Top) .Take(parametrosDeQuery.Top).ToList()); } } }