PortiaNet.HealthCheck.Writer.SQLServer 1.0.0

<img src="https://user-images.githubusercontent.com/11803924/159634426-45568864-0568-441c-9d0b-a28756f42f9f.png" width="400">

This library is the SQL writer for the PortiaNet.HealthCheck.Reporter and saves all reported logs to the client Microstof SQL Server.

Installation

You can install this tool from Nuget using Package Manager Console:

PM> Install-Package PortiaNet.HealthCheck.Writer.SQLServer

How do I get started?

After adding the HealthCheck middleware to the application pipeline, you need to add this library to DI and configure it as you prefer.

using PortiaNet.HealthCheck.Writer;

var builder = WebApplication.CreateBuilder(args);
...
builder.Services.AddSQLServerWriter(options =>
{
    options.TableName = "RequestTracks"; // Default Table Name
    options.MuteOnError = false; // To suppress/not suppress the internal errors like SQL Connection or privilege exceptions
    options.NodeName = "Main Node"; // When having different instances of one service, this parameter will help you to distinguish between their logs in the database 
    options.ConnectionString = "..."; // MS SQL Server Connection String to the database which you want to save the logs in it
});
...

How it works

By configuring the PortiaNet.HealthCheck.Writer.SQLServer library in DI, it adds a singletone instance of IHealthCheckReportService to the dependency injection. By calling the initiator of the injected class, it will check if the database which is mentioned in the connection string exists or not. If not then it will try to create it, Then the provided SQL Server credential should have dbcreator privilege. After ensuring about the database, the instance checks the table existance which is mentioned in the configuration. As like the database creation, it will create the table if it is not exist, then the provided SQL credential should have access to create new table in the same database.

To decrease the time handshakes and connection closing and reopenning overheads due to the number of API calls, this service keeps the sql connection open till its work get done.