using Microsoft.Extensions.Logging;

using System;

using System.Collections.Generic;

using System.Text;

namespace BCode.DataBase.Log

{

    public class EFCoreLoggerProvider : ILoggerProvider

    {

        public ILogger CreateLogger(string categoryName) => new EFCoreLogger(categoryName);

        public void Dispose() { }

    }

}

using Microsoft.Extensions.Logging;

using System;

namespace BCode.DataBase.Log

{

    public class EFCoreLogger : ILogger

    {

        private readonly string categoryName;

        public EFCoreLogger(string categoryName) => this.categoryName = categoryName;

        public bool IsEnabled(LogLevel logLevel) => true;

        public void Log<TState>(LogLevel logLevel, EventId eventId, TState state, Exception exception, Func<TState, Exception, string> formatter)

        {

            //EF Core执行SQL语句时的categoryName为Microsoft.EntityFrameworkCore.Database.Command,日志级别为Information

            if (categoryName == "Microsoft.EntityFrameworkCore.Database.Command" && logLevel == LogLevel.Information)

            {

                var logContent = formatter(state, exception);

                Console.WriteLine(logContent);

            }

        }

        public IDisposable BeginScope<TState>(TState state) => null;

    }

}

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            var loggerFactory = new LoggerFactory();

            loggerFactory.AddProvider(new EFCoreLoggerProvider());

            //添加EnableSensitiveDataLogging，启用敏感数据记录

            optionsBuilder.UseMySQL(_connectionString).UseLoggerFactory(loggerFactory).EnableSensitiveDataLogging();

        }