.NET Bulk Operations LogDump

Description

The LogDump property stores all messages of type "Information".

This option requires to set the UseLogDump property to true.

/// <summary>Gets or sets the `LogDump` property. The `LogDump` property stores all messages of type "Information". This option requires to set the [UseLogDump](use-log-dump) property to `true`.</summary>
public StringBuilder LogDump { get; set; }

Example

We will demonstrate how to use the UseLogDump and LogDump properties to log all messages.

Execute

We will execute a BulkMerge on a list that contains 1 new customer, and 2 existing customers.

We will use the following BulkOptions:

• UseLogDump: To enable the LogDump.
• LogDump: To specify the StringBuilder to use to dump all messages.

Code

// Execute
// 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());

Try it: .NET Core | .NET Framework

Result

We outputted the StringBuilder text which contains all SQL statements executed in the database.