Пример #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        public virtual T GetByID(int Id)
        {
            T result = default(T);

            using (AsaLocalEntities db = new AsaLocalEntities())
            {
                result = db.Set <T>().AsNoTracking().Where(m => m.Id == Id).FirstOrDefault();
            }

            return(result);
        }
Пример #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="function"></param>
        /// <param name="pageNumber"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public PagedList <T> Get(Expression <Func <T, bool> > WhereFilter, Expression <Func <T, T> > orderSelector, int pageNumber = 1, int pageSize = 15)
        {
            PagedList <T> result = new PagedList <T>(Enumerable.Empty <T>(), m => m, pageNumber, pageSize);

            using (AsaLocalEntities db = new AsaLocalEntities())
            {
                result = db.Set <T>().AsNoTracking().Where(WhereFilter).OrderBy(orderSelector).ToPagedList(pageNumber, pageSize);
            }

            return(result);
        }
Пример #3
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="pageNumber"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public PagedList <T> GetAll(int pageNumber = 1, int pageSize = 15)
        {
            PagedList <T> result = new PagedList <T>(Enumerable.Empty <T>(), m => m, pageNumber, pageSize);

            using (AsaLocalEntities db = new AsaLocalEntities())
            {
                result = db.Set <T>().AsNoTracking().ToPagedList(pageNumber, pageSize);
            }

            return(result);
        }