CommonUtils.Core/ef/DbContextPlus.cs

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

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

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;
using System;
using System.Linq;
using System.Linq.Expressions;

namespace CommonUtils
{
    public class DbContextPlus<TDb> : DbContext where TDb : DbContext
    {
        public DbContextPlus(DbContextOptions<TDb> options) : base(options)
        {
            "我是数据库构造行数1,我被调用了".Print();
        }

        public DbContextPlus(DbContextOptions<TDb> options, ILogger<DbContextPlus<TDb>> logger) : base(options)
        {
            logger.LogInformation("我是数据库构造行数2,我被调用了");
        }

        public IQueryable<TEntity> FromSql<TEntity>(string sql) where TEntity : DbEntity
        => Set<TEntity>().FromSqlRaw(sql);

        //protected override void OnModelCreating(ModelBuilder builder)
        //{
        //    //唯一
        //    builder.Entity<User>(eb =>
        //    {
        //        eb.HasIndex(e => e.Account).IsUnique();
        //    });
        //    //索引
        //    builder.Entity<User>(eb =>
        //    {
        //        eb.HasIndex(e => e.Account);
        //    });
        //}

        //static DbContextPlus()
        //{
        //    //联表
        //    DbContextUtil.SetInclude<User>(m => m.Roles);
        //}

        public static Expression<Func<TEntity, bool>> NewQuery<TEntity>() where TEntity : DbEntity
        => LambdaUtil.True<TEntity>();

        //public static WebApplicationBuilder InstanceProvider;
        public static IServiceCollection InstanceProvider;

        public static TDb Instance
        {
            get
            {
                //return InstanceProvider.GetService<TDb>();
                if (InstanceProvider == null)
                    InstanceProvider = CoreUtil.Services;
                return InstanceProvider.Get<TDb>();
            }
        }