EF Core继承DbContext的上下文类参考，包含跟踪sql日志

最新推荐文章于 2024-04-03 07:46:10 发布

王焜棟琦

最新推荐文章于 2024-04-03 07:46:10 发布

阅读量3k

点赞数 1

分类专栏： EF Core 文章标签： EF CORE

本文链接：https://blog.csdn.net/u011511086/article/details/98470320

版权

EF Core 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

using Comm;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Logging.Console;
using Microsoft.Extensions.Logging.Debug;
using Microsoft.Extensions.Logging.TraceSource;
using Model.Entity;
using Model.View;
using System;
using System.Linq;

namespace DAL
{
    public class DataContext : DbContext
    {
        public DataContext(DbContextOptions<DataContext> options)
            : base(options)
        {
        }
 

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            // optionsBuilder.UseInternalServiceProvider()            
            //string connection = "";
            //optionsBuilder.UseSqlServer(connection);
            //optionsBuilder.UseSqlServer(optionsBuilder.Options.Extensions.)          

            //this.Database.SetCommandTimeout(60);

            //设置不跟踪所有查询  2019-8-4 15:24:33 add
            optionsBuilder.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);

            //参数记录 2019-8-4 15:24:33 add
            optionsBuilder.EnableSensitiveDataLogging();

            var loggerFactory = new LoggerFactory();
            //  loggerFactory.AddProvider(new ConsoleLoggerProvider((category, level)
            //=> category == DbLoggerCategory.Database.Command.Name
            //   && level == LogLevel.Information, true));
            
            //记录sql生成
            loggerFactory.AddDebug(
                (categoryName, logLevel) =>
                //(logLevel == LogLevel.Debug) && (categoryName == DbLoggerCategory.Database.Command.Name)
                logLevel == LogLevel.Information
                && categoryName == DbLoggerCategory.Database.Command.Name
                //|| (categoryName == DbLoggerCategory.Query.Name)
                //|| (categoryName == DbLoggerCategory.Model.Name)
                );

            optionsBuilder.UseLoggerFactory(loggerFactory);
        }

        //protected override void OnModelCreating(ModelBuilder modelBuilder)
        //{
        //    //modelBuilder.Entity<Student>().Property<string>("TenantId").HasField("_tenantId");
        //     Configure entity filters
        //    //modelBuilder.Entity<Student>().HasQueryFilter(b => EF.Property<string>(b, "TenantId") == _tenantId);
        //    //modelBuilder.Entity<Student>().HasQueryFilter(p => p.DataState != (short)EDataState.Delete);
        //    //modelBuilder.Entity<Media>().HasQueryFilter(p => p.DataState != (short)EDataState.Delete);            
        //}

        public virtual DbSet<Setting> Setting { get; set; }
        public virtual DbSet<Media> Media { get; set; }
        public virtual DbSet<Student> Student { get; set; }

    }

    

}