Blazor.Serilog.Sinks.SQLite 1.0.0

private void CreateSqlTable(SQLiteConnection sqlConnection)
{
    var colDefs = "Id INTEGER PRIMARY KEY AUTOINCREMENT,";
    colDefs += "TimeStamp TEXT,";
    colDefs += "Level VARCHAR(10),";
    colDefs += "Exception TEXT,";
    colDefs += "Message TEXT,";
    colDefs += "Properties TEXT";
    colDefs += "MessageTemplate TEXT";
    colDefs += "LogEvent TEXT";
    colDefs += "UserName TEXT";
    colDefs += "ClientIP TEXT";
    colDefs += "ClientAgent TEXT";

    var sqlCreateText = $"CREATE TABLE IF NOT EXISTS {_tableName} ({colDefs})";

    var sqlCommand = new SQLiteCommand(sqlCreateText, sqlConnection);
    sqlCommand.ExecuteNonQuery();
}

private SQLiteCommand CreateSqlInsertCommand(SQLiteConnection connection)
{
    var sqlInsertText = "INSERT INTO {0} (Timestamp, Level, Exception, Message, Properties,MessageTemplate,LogEvent,UserName,ClientIP,ClientAgent)";
    sqlInsertText += " VALUES (@timeStamp, @level, @exception, @message, @properties,@messageTemplate,@logEvent,@userName,@clientIP,@clientAgent)";
    sqlInsertText = string.Format(sqlInsertText, _tableName);

    var sqlCommand = connection.CreateCommand();
    sqlCommand.CommandText = sqlInsertText;
    sqlCommand.CommandType = CommandType.Text;

    sqlCommand.Parameters.Add(new SQLiteParameter("@timeStamp", DbType.DateTime2));
    sqlCommand.Parameters.Add(new SQLiteParameter("@level", DbType.String));
    sqlCommand.Parameters.Add(new SQLiteParameter("@exception", DbType.String));
    sqlCommand.Parameters.Add(new SQLiteParameter("@message", DbType.String));
    sqlCommand.Parameters.Add(new SQLiteParameter("@properties", DbType.String));
    sqlCommand.Parameters.Add(new SQLiteParameter("@messageTemplate", DbType.String));
    sqlCommand.Parameters.Add(new SQLiteParameter("@logEvent", DbType.String));
    sqlCommand.Parameters.Add(new SQLiteParameter("@userName", DbType.String));
    sqlCommand.Parameters.Add(new SQLiteParameter("@clientIP", DbType.String));
    sqlCommand.Parameters.Add(new SQLiteParameter("@clientAgent", DbType.String));

    return sqlCommand;
}