30% OFF - 10th Anniversary discount on new purchases until December 15 with code: ZZZANNIVERSARY10
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 theLogDump
.LogDump = sb
: To specify theStringBuilder
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 . |
ZZZ Projects