使用appsettings.json文件时的Serilog.Sinks.MySQL配置

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=YourDatabase;Uid=YourUsername;Pwd=YourPassword;"
  },
  "Serilog": {
    "Using": [ "Serilog.Sinks.MySQL" ],
    "MinimumLevel": "Information",
    "WriteTo": [
      {
        "Name": "MySQL",
        "Args": {
          "connectionString": "Server=localhost;Database=YourDatabase;Uid=YourUsername;Pwd=YourPassword;",
          "tableName": "Logs",
          "autoCreateSqlTable": true
        }
      }
    ]
  }
}

public static void Main(string[] args)
{
    var configuration = new ConfigurationBuilder()
        .SetBasePath(Directory.GetCurrentDirectory())
        .AddJsonFile("appsettings.json")
        .Build();

    Log.Logger = new LoggerConfiguration()
        .ReadFrom.Configuration(configuration)
        .CreateLogger();

    // 其他初始化代码

    Log.Information("Application started");

    // 应用程序逻辑

    Log.Information("Application ended");

    Log.CloseAndFlush();
}