.NET Bulk Operations Logging
Description
The Bulk Operations Logging
feature let you log all messages of type "Information".
Key Features
- Allow to see SQL that are executed
- Allow to see parameter & 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.
TBD
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(); using (var bulk = new BulkOperation(connection)) { bulk.DestinationTableName = "Customer"; bulk.UseLogDump = true; bulk.BulkMerge(list); sb = bulk.LogDump; } // Result Console.WriteLine(sb.ToString());
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 . |