ZhouliProject/Zhouli.DAL/Implements/BaseDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Linq.Expressions;
using Dapper;
using System.Data;
using Microsoft.Extensions.Configuration;
using MySql.Data.MySqlClient;

namespace Zhouli.DAL.Implements
{
    public class BaseDAL<T> where T : class, new()
    {

        /// <summary>
        /// IDbConnection(Dapper使用)
        /// </summary>
        protected readonly IDbConnection _dbConnection;
        /// <summary>
        /// 数据库上下文
        /// </summary>
        protected readonly DbEntity.Models.ZhouLiContext _db;
        /// <summary>
        /// 构造函数依赖注入
        /// </summary>
        /// <param name="_db"></param>
        public BaseDAL(DbEntity.Models.ZhouLiContext db, IDbConnection dbConnection)
        {
            _db = db;
            _dbConnection = dbConnection;
        }
        public void Add(T t)
        {
            _db.Set<T>().Add(t);
        }
        public void AddRange(IEnumerable<T> t)
        {
            _db.AddRange(t);
        }
        public void Delete(T t)
        {
            _db.Set<T>().Remove(t);
        }
        public void Delete(IEnumerable<T> t)
        {
            _db.Set<T>().RemoveRange(t);
        }
        public void Delete(Expression<Func<T, bool>> whereLambda)
        {
            _db.Set<T>().RemoveRange(_db.Set<T>().Where(whereLambda));
        }
        public int GetCount(Expression<Func<T, bool>> whereLambda)
        {
            return _db.Set<T>().Count(whereLambda);
        }
        public void Update(T t)
        {
            //var newt = _db.Set<T>().First();