Logging

Description

The Dapper Plus Logging feature let 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 is 2 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