将EF框架实现数据增删查改、分页、排序封装为泛型类（封装通用EF数据操作类）

  public class BaseDal<T> where T:class,new()
    {
        //此处生成自己的数据实体对象   
        Entities Db = new Entities();
        //**********

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public T AddEntity(T entity)
        {
            Db.Set<T>().Add(entity);
            Db.SaveChanges();
            return entity;
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public bool DeleteEntity(T entity)
        {
            Db.Entry<T>(entity).State = System.Data.Entity.EntityState.Deleted;
            return Db.SaveChanges() > 0;
            
        }

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public bool EditEntity(T entity)
        {
            Db.Entry<T>(entity).State = System.Data.Entity.EntityState.Modified;
            return Db.SaveChanges() > 0;
            
        }

        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="whereLambda">System.Linq.Expressions.Expression<Func<UserInfo, bool>>为参数(lambda表达式树)类型</param>
        /// <returns></returns>
        public IQueryable<T> LoadEntities(Expression<Func<T, bool>> whereLambda)
        {
            return Db.Set<T>().Where<T>(whereLambda);
        }

        /// <summary>
        /// 分页
        /// </summary>
        /// <typeparam name="s">方法的泛型类型（由于可参照排序字段数据类型不一样）</typeparam>
        /// <param name="pageIndex">页码</param>
        /// <param name="pageSize">每页展示的数据条数</param>
        /// <param name="totalCount">数据总条数</param>
        /// <param name="whereLambda">用于数据过滤</param>
        /// <param name="orderbyLambda">用于数据排序</param>
        /// <param name="isAsc">判断升序或者降序true升序</param>
        /// <returns></returns>
        public IQueryable<T> LoadPageEntities<s>(int pageIndex, int pageSize, out int totalCount, Expression<Func<T, bool>> whereLambda, Expression<Func<T, s>> orderbyLambda, bool isAsc)
        {
            var temp = Db.Set<T>().Where<T>(whereLambda);
            totalCount = temp.Count();
            if (isAsc)//true升序
            {
                temp = temp.OrderBy<T, s>(orderbyLambda).Skip<T>((pageIndex - 1) * pageSize).Take<T>(pageSize);
            }
            else
            {
                temp = temp.OrderBy<T, s>(orderbyLambda).Skip<T>((pageIndex - 1) * pageSize).Take<T>(pageSize);
            }
            return temp;
        }
    }

以上代码在开发过程中可能会存在生成的实体对象即Entity不唯一的问题，即生成多个对象，会操作出错，因此要考虑实现线程内对象唯一的问题，实现方式在下一篇博客中。

https://blog.csdn.net/qq_40564078/article/details/103112292