EF泛型基类封装查询，添加，修改，删除

矫情吗；* 2023-01-04 13:29 136阅读 0赞

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Linq.Expressions;
    using System.Text;
    using System.Threading.Tasks;
    using shop_car_Model;
    namespace Shop_Car_DAL
    { 
      public class DAseDAL<T> where T :class
        { 
            CarContent cardb = new CarContent();
            /// <summary>
            /// IQueryable 延迟加载集合，调用时才会才会去加载内存。
            /// list查询后立即加载至内存中
            /// </summary>
            /// <returns></returns>
            public IQueryable<T> getEntitys(Expression<Func<T,bool>>  lambdawhere)
            { 
               return  cardb.Set<T>().Where(lambdawhere);
            }
            /// <summary>
            /// 添加
            /// </summary>
            /// <param name="entity"></param>
            /// <returns></returns>
            public  int ADD(T  entity)
            { 
                cardb.Set<T>().Add(entity);
                return cardb.SaveChanges();
    
            }
              /// <summary>
              /// 删除
              /// </summary>
              /// <param name="entity"></param>
              /// <returns></returns>
            public int Delete(T id)
            { 
                T entity = cardb.Set<T>().Find(id);
                cardb.Set<T>().Remove(entity);
                return cardb.SaveChanges();
    
            }
            /// <summary>
            /// 修改
            /// </summary>
            /// <param name="entity"></param>
            /// <returns></returns>
            public int Update(T entity)
            { 
                cardb.Entry(entity).State = System.Data.Entity.EntityState.Modified; 
                return cardb.SaveChanges();
    
            }
        }
    }

继承调用：

using shop\_car\_Model;

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    
    namespace Shop_Car_DAL
    { 
        class UserInfo_DAL : DAseDAL<UserInfo>
        { 
        }
    }