CSharp: donet 7 create logging File with EF Core 7.02
/// <summary> /// https://learn.microsoft.com/zh-cn/ef/core/logging-events-diagnostics/simple-logging /// </summary> /// <param name="optionsBuilder"></param> protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { //读取配置文件 var config = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) //Environment.CurrentDirectory .AddJsonFile("appsettings.json") .AddInMemoryCollection() .Build(); var connStr = config["ConnectionStrings:GeovinDuDbContext"]; //日志 //optionsBuilder.UseLoggerFactory(loggerFactory); optionsBuilder.LogTo(_logStream.WriteLine); // optionsBuilder.LogTo(Console.WriteLine).EnableDetailedErrors(); // optionsBuilder.LogTo(Console.WriteLine,LogLevel.Debug,DbContextLoggerOptions.UtcTime | DbContextLoggerOptions.SingleLine); // optionsBuilder.UseSqlServer("Server=DESKTOP-NQK85G5\\GEOVIN2008;Database=geovindu;User Id=sa;Password=geovindu;"); optionsBuilder.UseSqlServer(connStr); } //日志文本 private StreamWriter _logStream = new StreamWriter("geovindulog.txt", append: true); /// <summary> /// /// </summary> public override void Dispose() { base.Dispose(); _logStream.Dispose(); } /// <summary> /// /// </summary> /// <returns></returns> public override async ValueTask DisposeAsync() { await base.DisposeAsync(); await _logStream.DisposeAsync(); }
哲学管理(学)人生, 文学艺术生活, 自动(计算机学)物理(学)工作, 生物(学)化学逆境, 历史(学)测绘(学)时间, 经济(学)数学金钱(理财), 心理(学)医学情绪, 诗词美容情感, 美学建筑(学)家园, 解构建构(分析)整合学习, 智商情商(IQ、EQ)运筹(学)生存.---Geovin Du(涂聚文)