.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 the LogDump.
• LogDump = sb: To specify the StringBuilder 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