Hardwired.Logging.SqlLogger 1.0.4

Hardwired SQL Logger

<details> <summary>Configuring Sql Logger</summary>

There is two ways for configuring SQL Logger.

1. Configuration File

appsettings.json

{
  "Logging": {

    "LogLevel": {
      "Default": "Trace",
      "System": "Information",
      "Microsoft": "Information"
    },

    "HardwiredLogging": {
      "Schema": "logging",
      "ConnectionString": "Data Source=[datasource];Initial Catalog=[database];Integrated Security=true;",
      "LogLevel": "Information",
      "LogTableLevel": "Information",
      "SerializationMethod": "Json",
      "UpdateDatabase" : true 
    },

    "Console": {
      "IncludeScopes": true
    }
  }
}

Building Configuration

_configuration = new ConfigurationBuilder()
    .AddJsonFile("appsettings.json")
    .Build();

Add Logging

serviceCollection.AddLogging(builder =>
{
    builder.AddHardwiredSqlLogger(_configuration);
});

or

var configurationSection = _configuration
    .GetSection("Logging")
    .GetSection("HardwiredLogging");

serviceCollection.AddLogging(builder =>
{
    builder.AddHardwiredSqlLogger(configurationSection);
});

2. Logger Provider Options

serviceCollection.AddLogging(builder =>
{
    builder.AddHardwiredSqlLogger(config =>
    {
        config.ConnectionString = "Data Source=[datasource];Initial Catalog=[database];Integrated Security=true;";
        config.LogLevel = LogLevel.Information;
        config.Schema = "logging";
        config.RetryCount = 3;
    });
});

</details>

<details> <summary>Provider Options</summary>

ISqlLoggerProviderOptions

ConnectionString    (string)  : SQl server connection string
Schema              (string)  : Default schema for logging tables
LogLevel            (enum)    : Minimum log level for general logs
LogTableLevel       (enum)    : Minimum log level for model logs
SerializationMethod (enum)    : Serialization method for model's complex properties
UpdateDatabase      (bool)    : Generate and execute sql commands for create or update tables
                                after starting
RetryCount          (int)     : Number of tries for inserting logs

</details>

<details> <summary>Model Logging</summary> Hardwired sql logger creates a table for each model that you want to log.

Model :

class RequestLogModel 
{
  public int Id { get; set; }
  public string Title { get; set; }
  [MaxLength(80)]
  public string Address { get; set; }
  public long Quantity { get; set; }
  public List<string> Tags { get; set; }
}

Mapping :

builder.AddHardwiredSqlLogger(_configuration, option =>
{
  option
    .Map<RequestLogModel>("RequestLog")
    .Map<VisitLogModel>("VisitLog");
});

Usage :

public class Business
{
  private readonly ILogger _logger;
  public Business(ILogger<Business> logger)
  {
      _logger = logger;
  }

  public void SampleMethod()
  {
      var model = new RequestLogModel()
      {
          Id = 1,
          Title = "myTitle",
          Address = "Tehran",
          Quantity = 50,
          Tags = new List<string>(){ "a","b","c" }
      };

      using (var scope = logger.BeginScope(model))
      {
        _logger.LogInformation("Request Received.");
      }
  }
}

Inserted Row :

</details>