Serilog.Sinks.Database 1.0.0

Serilog.Sinks.Database

Serilog sink that writes in one of these five databases : | Database | Library | Example of connection string | | ---------- | -------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | SqlServer | System.Data.SqlClient | const string sqlConnectionString = "Data Source=NBK-437;Persist Security Info=True;Initial Catalog=test;Integrated Security=SSPI;"; | | Oracle | Oracle.ManagedDataAccess | const string oraConnectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XEPDB1)));User Id=DBWUSR;Password=DBWUSR;"; | | MySql | MySql.Data | const string mysConnectionString = "Server=localhost;Database=test;Uid=sa;Pwd=ASqlAdmin01;"; | | PostgreSQL | Npgsql | const string posConnectionString = "Server=127.0.0.1;Port=5432;Database=test;User Id=postgres;Password=ASqlAdmin01;"; | | Sqlite | Microsoft.Data.Sqlite | const string litConnectionString = @"Data Source=c:\temp\test.db;"; |

Getting started

Install Serilog.Sinks.Database from NuGet

Install-Package Serilog.Sinks.Database

Configure logger by calling WriteTo.Database

DBType dbType = DBType.MySql;
            
var logger = new LoggerConfiguration()
      .WriteTo.Database(dbType, "Server=localhost;Database=test;Uid=sa;Pwd=ASqlAdmin01;", "SerLogs",Events.LogEventLevel.Verbose,false,1)
      .CreateLogger();

logger.Information("This informational message will be written to wich database you want");