SimpLog.Database.MSSQL 0.0.1-alpha1

What is SimpLog

Simple and very flexible tool for development with .NET Core. Saves logs to a file, or a database where you want. Also gives opportunity to receive logs via email with the proper configuration.

Log Types in SimpLog

Features of SimpLog.Databases.MSSQL

📚 Database structure for logging into a database

You need two tables, no matter the database. The databases are as follows:

Scripts for creating tables:

if object_id('StoreLog', 'U') is null     
create table [StoreLog](        
    [ID] int IDENTITY(1,1) PRIMARY KEY,
    [Log_Type] varchar(50),
    [Log_Error] varchar(50),
    [Log_Created] varchar(50),
    [Log_FileName] varchar(50),
    [Log_Path] varchar(50),
    [Log_SendEmail] bit,
    [Email_ID] int,
    [Saved_In_Database] varchar(50)     
)  
if object_id('EmailLog', 'U') is null     
create table [EmailLog](        
    [ID] int IDENTITY(1,1) PRIMARY KEY,
    [From_Email] varchar(50),
    [To_Email] varchar(50),
    [Bcc] varchar(50),
    [Email_Subject] varchar(50),
    [Email_Body] varchar(50),
    [Time_Sent] varchar(50)     
) 

Configuration

In Program.cs In Program.cs only if you use buffer type for saving into a log file. In other cases it is not needed at all.

Nothing needed

In Controller

private SimpLog.Databases.MSSQL.Services.SimpLogServices.SimpLog _simpLog = new SimpLog.Databases.MSSQL.Services.SimpLogServices.SimpLog();

and call the log like

_simpLog.Trace("place your message here");

options are as follows

_simpLog.Info({1}, {2}, {3}); 

and only {1} is required

In simplog.json

Create simplog.json file in the root folder of your startup project. On the same level where is appsettings.json. Please have in mind that every configuration in simplog.json is optional ☺️

  "SimpLog": {                              -> all of the below fields are optional
    "Database_Configuration": {             -> Database configurations
      "Connection_String": string,          -> Depending on database type, use the correct connection string.
      "Global_Database_Type": string,       -> The type of a database. Please spell it correctly "MSSql" or "MySql" or "Postgre" or "MongoDb". N.B! Be carefull with spelling!
      "Use_OleDB": bool,                    -> Still not implementet, not any functionality here.
      "Global_Enabled_Save": bool           -> You can globally disable or enable saving into database. Default value is
    },
    "LogType": {
      "Trace": {                            -> TYPE OF LOG == Trace.
        "SaveInDatabase": true              -> For the TYPE OF LOG, should be enabled saving into database. Default value is true.
      },
      "Debug": {                            -> Analogically TYPE OF LOG here is Debug 
        "SaveInDatabase": true
      },
      "Info": {                             -> Analogically TYPE OF LOG here is Info
        "SaveInDatabase": true
      },
      "Notice": {                           -> Analogically TYPE OF LOG here is Notice
        "SaveInDatabase": true
      },
      "Warn": {                             -> Analogically TYPE OF LOG here is Warn
        "SaveInDatabase": true
      },
      "Error": {                            -> Analogically TYPE OF LOG here is Error
        "SaveInDatabase": true
      },
      "Fatal": {                            -> Analogically TYPE OF LOG here is Fatal
        "SaveInDatabase": true
      }
    }
  }

Hope you enjoy the NuGet Package! 😉