Dapper Plus 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

Name Description
Log The Log property is an action executed when a message of type "Information" happens.
UseLogDump When the UseLogDump property is true, the LogDump property stores all messages of type "Information".
LogDump The LogDump property stores all messages of type "Information". This option requires to set the UseLogDump property to true.

Contents