Entity Framework（3）查询

  #region 查询

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        /// <param name="where">条件</param>
        /// <param name="count">符合条件的记录数</param>
        /// <returns></returns>
        public bool Exists(Expression<Func<T, bool>> where, out int count)
        {
            if (where == null)
            {
                throw new ArgumentNullException("条件（where）不能为空");
            }
            try
            {
                IEnumerable<T> query = db.Set<T>().Where(where).AsQueryable();
                count = query.Count();
                return count > 0 ? true : false;
            }
            catch
            {
                throw;
            }
        }

        /// <summary>
        /// 获取前几条数据
        /// </summary>
        /// <typeparam name="Key">用于排序的属性</typeparam>
        /// <param name="where">条件</param>
        /// <param name="orderBy">排序的字段</param>
        /// <param name="isAsc">true顺序，false倒序</param>
        /// <param name="top">前n条</param>
        /// <returns></returns>
        public IQueryable<T> QureyTop<Key>(Expression<Func<T, bool>> where, Expression<Func<T, Key>> orderBy, bool isAsc, int top, out int total)
        {
            if (where == null)
            {
                throw new ArgumentNullException("条件（where）不能为空");
            }
            if (orderBy == null)
            {
                throw new ArgumentNullException("排序字段（orderBy）不能为空");
            }
            try
            {
                IQueryable<T> query = db.Set<T>().Where(where);
                total = query.Count();
                if (isAsc)
                {
                    query = query.OrderBy(orderBy).Take(top);
                }
                else
                {
                    query = query.OrderByDescending(orderBy).Take(top);
                }
                return query.AsQueryable();
            }
            catch
            {
                throw;
            }
        }

        /// <summary>
        /// 获取总条数
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        public int Total(Expression<Func<T, bool>> where)
        {
            if (where == null)
            {
                throw new ArgumentNullException("条件（where）不能为空");
            }
            IEnumerable<T> query = db.Set<T>().Where(where).AsQueryable();
            return query.Count();
        }

        /// <summary>
        /// 条件查询带分页
        /// </summary>
        /// <typeparam name="Key">用于排序的属性</typeparam>
        /// <param name="where">条件</param>
        /// <param name="orderBy">排序</param>
        /// <param name="isAsc">true顺序，false倒叙</param>
        /// <param name="pageIndex">页数</param>
        /// <param name="pageSize">每页条数</param>
        /// <param name="total">总数据量</param>
        /// <returns></returns>
        public IQueryable<T> PagingQuery<Key>(Expression<Func<T, bool>> where, Expression<Func<T, Key>> orderBy, bool isAsc, int pageIndex, int pageSize, out int total)
        {
            if (where == null)
            {
                throw new ArgumentNullException("条件（where）不能为空");
            }
            if (orderBy == null)
            {
                throw new ArgumentNullException("排序字段（orderBy）不能为空");
            }
            try
            {
                IQueryable<T> query = db.Set<T>().Where(where);
                total = query.Count();
                if (isAsc)
                {
                    query = Paging(query.OrderBy(orderBy), pageIndex, pageSize);
                }
                else
                {
                    query = Paging(query.OrderByDescending(orderBy), pageIndex, pageSize);
                }
                return query.AsQueryable();
            }
            catch
            {
                throw;
            }
        }

        /// <summary>
        /// 分页
        /// </summary>
        /// <param name="query">翻页前的集合</param>
        /// <param name="pageIndex">页数</param>
        /// <param name="pageSize">每页条数</param>
        /// <returns></returns>
        private IQueryable<T> Paging(IQueryable<T> query, int pageIndex, int pageSize)
        {
            try
            {
                if (pageIndex < 1)
                {
                    throw new ArgumentOutOfRangeException("页数不能小于1");
                }
                if (pageSize < 0)
                {
                    throw new ArgumentOutOfRangeException("每页条数不能小于0");
                }
                return query.Skip((pageIndex - 1) * pageSize).Take(pageSize);
            }
            catch
            {
                throw;
            }
        }

        #endregion

亲测可用，懒得贴测试代码了