EF 三层 BLL DAL

项目图片

DAL

增

using EF.Entity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF.DAL
{
    public class AddBaseDal<T> where T:class
    {
        BaseDbContext db = new BaseDbContext();

        public void Add(T t)
        {
            db.Set<T>().Add(t);
            db.SaveChanges();
        }
    }

    public class AddTA_Bll : AddBaseDal<TA>
    { 
    
    }
    public class AddTB_Bll : AddBaseDal<TB>
    { 
    
    }
}

查

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF.DAL
{
    using EF.Entity;
    using System.Linq.Expressions;

    //写一个父类，公用的用于查询的方法
    public class QueryBaseDal<T> where T : class
    {
        BaseDbContext db = new BaseDbContext();

        public List<T> QueryWhere(Expression<Func<T,bool>> where)
        {
            return db.Set<T>().Where(where).ToList();
        }
    }

    public class QueryTA_Dal : QueryBaseDal<TA>
    { 
        
    }

    public class QueryTB_DaL : QueryBaseDal<TB>
    { 
    
    }
}

BLL层

增

using EF.Entity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF.BLL
{
    using EF.DAL;
    public class AddBaseBll<T> where T:class
    {

        public void Add(T t)
        {
            AddBaseDal<T> dal = new AddBaseDal<T>();
            dal.Add(t);
        }
    }

    public class AddTA_Bll : AddBaseBll<TA>
    {

    }

    public class AddTB_Bll : AddBaseBll<TB>
    {

    }
}

查

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EF.BLL
{
    using EF.DAL;
using EF.Entity;
using System.Linq.Expressions;
    public class QueryBaseBll<T>where T:class
    {
        public List<T> QueryWhere(Expression<Func<T,bool>> where)
        {
            QueryBaseDal<T> dal = new QueryBaseDal<T>();
            return dal.QueryWhere(where);
        }

    }
    public class QueryTA_Bll : QueryBaseBll<TA>
    { 
    
    }

    public class TB_Bll : QueryBaseBll<TB>
    { 
    
    }
}