Logging

Description

The Dapper Plus Logging feature lets you log all messages of type "Information".

Key Features

• Allow to see SQL that are executed
• Allow to see parameter name and value
• Allow to see execution time

Getting Started

There are two ways to use the logging features

Logging with an action

To use the Logging feature with an action, you need to define a delegate to execute.

var sb = new StringBuilder();
connection.UseBulkOptions(options => 
{ 
	options.Log = s => sb.AppendLine(s);
})
.BulkMerge(list);

// Result
Console.WriteLine(sb.ToString());

Try it: TODO | .NET Framework

Logging with the LogDump

To use the Logging feature with the LogDump, you need to use the UseBulkOptions method to set:

• UseLogDump = true: To enable the LogDump.
• LogDump = sb: To specify the StringBuilder to use to dump all messages.

// Execute
var sb = new StringBuilder();
connection.UseBulkOptions(options => 
{ 
	options.UseLogDump = true;
	options.LogDump = sb;
})
.BulkMerge(list); 

// Result
Console.WriteLine(sb.ToString());

Try it: .NET Core | .NET Framework

Scenarios

• Log into a Database
• Log into a File
• Log into NLog

Options