Dapper Plus - Logging - LogDump | C# Online Compiler

Dapper Plus - Logging - LogDump by ZZZ Projects

// Dapper Plus
// Doc: https://dapper-plus.net/log-dump

// @nuget: Dapper -Version 1.60.6
// @nuget: Z.Dapper.Plus

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using Dapper;
using Z.Dapper.Plus;
using Z.BulkOperations;

public class Program
{	
	public static void Main()
	{
		CreateDatabase();
		SeedDatabase();
		
		// Mapping
		DapperPlusManager.Entity<Customer>().Table("Customer");
		
		Execute();
	}
	
	public static void Execute()
	{
		// We will execute a BulkMerge on a list that contains 1 new customer and 2 existing customers.
		var list = new List<Customer>();
		list.Add(new Customer() { Name = "Customer_C_Inserted", Description = "Description_Customer_C_Inserted", IsActive = false });
		list.Add(new Customer() { CustomerID = 1, Name = "Customer_A_Updated", Description = "Description_Customer_A_Updated", IsActive = false });
		list.Add(new Customer() { CustomerID = 2, Name = "Customer_B_Updated", Description = "Description_Customer_B_Updated", IsActive = false });

		// Connection
		var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
		
		// Execute
		var sb = new StringBuilder();
		connection.UseBulkOptions(options => 
		{ 
			options.UseLogDump = true;
			options.LogDump = sb;
		})
		.BulkMerge(list); 

		// Result
		Console.WriteLine(sb.ToString());
	}
	
	public class Customer
	{
		public int CustomerID { get; set; }
		public string Name { get; set; }
		public string Description { get; set; }
		public Boolean IsActive { get; set; }
	}
	
	public static void CreateDatabase()
	{
		using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
		{
			connection.Open();
			using (var command = connection.CreateCommand())
			{
				command.CommandText = @"   
CREATE TABLE [dbo].[Customer] (
    [CustomerID]  INT            IDENTITY (1, 1) NOT NULL,
    [Name]        NVARCHAR (MAX) NULL,
    [Description] NVARCHAR (MAX) NULL,
    [IsActive]    BIT            NOT NULL,
    CONSTRAINT [PK_dbo.Customer] PRIMARY KEY CLUSTERED ([CustomerID] ASC)
);
";
				command.ExecuteNonQuery();
			}
		}
	}
	
	public static void SeedDatabase()
	{
		var list = new List<Customer>();
		list.Add(new Customer() { Name = "Customer_A", Description = "Description_Customer_A", IsActive = false });
		list.Add(new Customer() { Name = "Customer_B", Description = "Description_Customer_B", IsActive = false });
		
		var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
		connection.BulkInsert(list);
	}
}

​x
 
// Dapper Plus
// Doc: https://dapper-plus.net/log-dump
​
// @nuget: Dapper -Version 1.60.6
// @nuget: Z.Dapper.Plus
​
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using Dapper;
using Z.Dapper.Plus;
using Z.BulkOperations;
​
public class Program
{   
    public static void Main()
    {
        CreateDatabase();
        SeedDatabase();
        
        // Mapping
        DapperPlusManager.Entity<Customer>().Table("Customer");
        
        Execute();
    }
    
    public static void Execute()
    {
        // We will execute a BulkMerge on a list that contains 1 new customer and 2 existing customers.
        var list = new List<Customer>();
        list.Add(new Customer() { Name = "Customer_C_Inserted", Description = "Description_Customer_C_Inserted", IsActive = false });
        list.Add(new Customer() { CustomerID = 1, Name = "Customer_A_Updated", Description = "Description_Customer_A_Updated", IsActive = false });
        list.Add(new Customer() { CustomerID = 2, Name = "Customer_B_Updated", Description = "Description_Customer_B_Updated", IsActive = false });
​
        // Connection
        var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
        
        // Execute
        var sb = new StringBuilder();
        connection.UseBulkOptions(options => 
        { 
            options.UseLogDump = true;
            options.LogDump = sb;
        })
        .BulkMerge(list); 
​
        // Result
        Console.WriteLine(sb.ToString());
    }
    
    public class Customer
    {
        public int CustomerID { get; set; }
        public string Name { get; set; }
        public string Description { get; set; }
        public Boolean IsActive { get; set; }
    }
    
    public static void CreateDatabase()
    {
        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
        {
            connection.Open();
            using (var command = connection.CreateCommand())
            {
                command.CommandText = @"   
CREATE TABLE [dbo].[Customer] (
    [CustomerID]  INT            IDENTITY (1, 1) NOT NULL,
    [Name]        NVARCHAR (MAX) NULL,
    [Description] NVARCHAR (MAX) NULL,
    [IsActive]    BIT            NOT NULL,
    CONSTRAINT [PK_dbo.Customer] PRIMARY KEY CLUSTERED ([CustomerID] ASC)
);
";
                command.ExecuteNonQuery();
            }
        }
    }
    
    public static void SeedDatabase()
    {
        var list = new List<Customer>();
        list.Add(new Customer() { Name = "Customer_A", Description = "Description_Customer_A", IsActive = false });
        list.Add(new Customer() { Name = "Customer_B", Description = "Description_Customer_B", IsActive = false });
        
        var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer());
        connection.BulkInsert(list);
    }
}

========================================================================================================================
-------------------;;;;;;---------------------------------------------------------------------;;;;;;--------------------
========================================================================================================================

nnnnnnnnnnnn      nnnnnnnnn     nnn                bnnnd         bnnnnnm.   .mnnnnnd       bnnnd         bnnnnnnnnnd
nnnn              nn            nnn               bn    nd       bnn     n n     nnd      bn   nd        bnnnnnnnnnd
.nnnnnnnnnnn      neeeeeeen     nnn              bnn...nnd       bnn     n n     nnd     bnn...nnd           nnn
       nnnnn      nn            nnn             bnn     nnd      bnn      n      nnd    bnn     nnd          nnn
nnnnnnnnnnn.      nnnnnnnnn     nnnnnnnnn      bnnn      nnnd    bnn             nnd   bnnn      nnd         nnn

Bnnnnnnnn.          bnnnd        bnnnnnnnnnd       bnnnd        Nnnnn     nd    Bnnnnnnn.
Bnn     .nb        bn   nd       bnnnnnnnnnd      bn   nd       Nnn  .n    nd   Bnn
Bnn        B      bnn...nnd          nnn         bnn...nnd      Nnn     n  nd   Bnn    nnd
Bnn     .nb      bnn     nnd         nnn        bnn     nnd     Nnn      n.nd   Bnn      nd
Bnnnnnnnn.      bnn       nnd        nnn       bnnn      nnd    Nnn       nnd   Bnnnnnnnnnd

Bnnnnnnnn.       BnnD         nnn        nnnn      nnn    nnn      BBnnnnd    Bnnnnnnnn    bbb      bbb
Bnn     .nb       nn          nnn     nn      nn   nnn    nnn      BBn        Bnn          bb       bb
Bnn        B      nn          nnn     nn      nn       nnn         BBn        Bnnnnnnnn    bb       bb
Bnn      .nb      nn         .nnn.    nn      nn       nnn         BBn        Bnn          bb       bb
Bnnnnnnnnn.      BnnD      dnnnnn.       nnnn          nnn         BBnnnnd    Bnnnnnnnn    bbbbbbb  bbbbbbb

               ----=========----     KAMI MELAYANI PEMBELIAN HANDPHONE BERKUALITAS      ----=========----

====================================================================================================================
--------------------------------;;;;;;---------------------------------;;;;;;--------------------------------------
====================================================================================================================

----------------------------------------------------------------
                                   Menu Pilihan
----------------------------------------------------------------
1. Sony Xperia E1 White               =Rp 1.299.000
2. Lenovo A526 Blue                   =Rp 1.399.000
3. Samsung Galaxy Mega 6.3 19200      =Rp 4.950.000
4. Smartfren Andromax G2 Blue         =Rp 899.000
5. Samsung Galaxy S4 I9500            =Rp 6.650.000
----------------------------------------------------------------

Masukkan Angka Pilihan :

Last Run:	3:50:40 am
Compile:	0.237s
Execute:	0s
Memory:	88kb
CPU:	0.094s

View IL Code