DatabaseLogging

Send ASP.NET Core logs to any Entity Framework database (ILogger / ILoggerFactory)

PS: Your app doesn't need to ASP.NET Core. You just have to use Microsoft.Extensions.Logging

This is in alpha so looking PRs to add unit tests, and improvements. Feedback also welcome through the issues.

Why?

• Log to the database in your development environment and query the results. There is no need to sift through pages of log files. This gives you similar functionality to Application Insights.

• Record your logs in pipelines with SQLite and query the results afterwards

• Write to an SQLite log on Android or iOS so you can easily query the data afterwards

• No bloat or need for non-standard config with systems like NLog, log4net or Serilog

• Log to unstructured databases (No SQL) like Cosmos Db with Entity Framework

Quick Start

• Add Nuget DatabaseLogging (currently alpha, so be sure to include pre-release)
• Add the Entity Framework NuGet for the database you want to use. (E.g. Microsoft.EntityFrameworkCore.Sqlite or Microsoft.EntityFrameworkCore.SqlServer)
• Call AddDatabase and initialize the DbContext with code for the database platform

Note: the DbContext will call Database.EnsureCreated() so the connection string needs to point to a database where this will succeed. It will probably need to be a clean database first time around

SQL Server

var serviceCollection = new ServiceCollection();
serviceCollection.AddLogging((builder) =>
{
    builder.AddDatabase((options) =>
    {
        options.GetDatabaseContext = () =>
        {
            var context = new Context((builder) =>
            {
                builder.UseSqlServer("Server=(local);Database=Logging;Trusted_Connection=True;MultipleActiveResultSets=true");
            });

            return context;
        };
    });
});

SQLite

var serviceCollection = new ServiceCollection();
serviceCollection.AddLogging((builder) =>
{
    builder.AddDatabase((options) =>
    {
        options.GetDatabaseContext = () =>
        {
            var context = new Context((builder) =>
            {
                var connection = new SqliteConnection("Data Source=Log.db");
                connection.Open();

                var command = connection.CreateCommand();

                //Create the database if it doesn't already exist
                command.CommandText = "PRAGMA foreign_keys = ON;";
                _ = command.ExecuteNonQuery();
                _ = builder.UseSqlite(connection);
            });

            return context;
        };
    });
});

Create the Logger

var serviceProvider = serviceCollection.BuildServiceProvider();
var loggerFactory = serviceProvider.GetRequiredService<ILoggerFactory>();
var logger = loggerFactory.CreateLogger<TestClass>();
logger.LogInformation("Test {Hi}", 123);