Queue.cs

public void Add(MessageLog message)
{
    using (var conn = _connectionFactory.OpenConnection())
    {
        conn.Execute(
            "INSERT INTO logs VALUES (" +
            "@Id," +
            "@Name," +
            "@Payload::jsonb," +
            "@Metadata," +
            "@RaiseDate)",
            message
        );
}
    
// the order of adding is not preserved

Test.cs

foreach (var @event in c.RecordedEvents)
{
    psqlLogs.Add(new MessageLog
    {
        Id = Guid.NewGuid(),
        Metadata = "",
        Name = @event.GetType().Name,
        Payload = JsonConvert.SerializeObject(@event),
        RaiseDate = DateTime.Now
    });
}

// when debugging
// i have three items in c.RecordedEvents lets call them A, B and C