Page History

Entity-ORM이 발생시키는 SQL로그를 추적하는 방법을 살펴보자

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;  //Nuget을 통해 다운로드받는다.
using Microsoft.Extensions.Logging.Console;
using Microsoft.Extensions.Logging.Debug;


namespace accountapi.Config
{
    public class LogSettings
    {
        public static readonly LoggerFactory ConsoleLogger = new LoggerFactory(new[] {
            new ConsoleLoggerProvider((category, level) => category == DbLoggerCategory.Database.Command.Name
               && level == LogLevel.Debug, true) 
        });

        public static readonly LoggerFactory DebugLogger = new LoggerFactory(new[] {
            new DebugLoggerProvider((_, logLevel) => logLevel >= LogLevel.Debug)
        });
    }
}

var builder = new DbContextOptionsBuilder<AccountContent>()
    .UseLoggerFactory(LogSettings.DebugLogger)  //Entity ORM의 로그셋팅
    .UseMySql(AccountControlerTest.ConnectionString);
var context = new AccountContent(builder.Options);