Bulk Operations - BulkInsert - Documentation - BulkInsert<T>(items) (DataTable) | C# Online Compiler

Bulk Operations - BulkInsert - Documentation - BulkInsert<T>(items) (DataTable) by ZZZ Projects

// Bulk Operations
// Doc: https://bulk-operations.net/bulk-insert

// @nuget: Z.BulkOperations

using System;
using System.Data;
using Z.BulkOperations;
using System.Data.SqlClient;
using System.Collections.Generic;
					
public class Program
{
	public static void Main()
	{
		GenerateDatabase();
		var dtCustomers = GenerateCustomers(5);
		
		
		using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
		{
			connection.Open();
			
			// SAVE customers
			using (var bulk = new BulkOperation(connection))
			{
				bulk.DestinationTableName = "Customers";

				bulk.BulkInsert(dtCustomers);
			}
			
			// SHOW data
			using (var command = connection.CreateCommand())
			{
				command.CommandText = @"
SELECT * FROM Customers
";
				var ds = new DataSet();
				var sqlDataAdapter = new SqlDataAdapter(command);
        		sqlDataAdapter.Fill(ds);
				
				ds.Tables[0].TableName = "1 - Customers";
				
				FiddleHelper.WriteTable(ds.Tables[0]);
			}
		}
	}
	
	public static DataTable GenerateCustomers(int count) 
	{
		DataTable dtTable = new DataTable("Customers");
		
		dtTable.Columns.Add("CustomerID", typeof(int));
  		dtTable.Columns.Add("Name", typeof(string)); 
	
		for(int i = 0; i < count; i++)
		{
			var drCustomer = dtTable.NewRow();  
			drCustomer["Name"] = "Customer_" + i;  
			dtTable.Rows.Add(drCustomer);
		}
		
		return dtTable;
	}
	
	public static void GenerateDatabase()
	{
		using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
		{
			connection.Open();
			using (var command = connection.CreateCommand())
			{
				command.CommandText = @"   
CREATE TABLE [Customers]
(
	[CustomerID] [INT] IDENTITY(1,1) NOT NULL,
	[Name] [NVARCHAR](MAX) NULL,
	CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED 
	(
		[CustomerID] ASC
	)
)";
				command.ExecuteNonQuery();
			}
		}
	}
}

​x
 
// Bulk Operations
// Doc: https://bulk-operations.net/bulk-insert
​
// @nuget: Z.BulkOperations
​
using System;
using System.Data;
using Z.BulkOperations;
using System.Data.SqlClient;
using System.Collections.Generic;
                    
public class Program
{
    public static void Main()
    {
        GenerateDatabase();
        var dtCustomers = GenerateCustomers(5);
        
        
        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
        {
            connection.Open();
            
            // SAVE customers
            using (var bulk = new BulkOperation(connection))
            {
                bulk.DestinationTableName = "Customers";
​
                bulk.BulkInsert(dtCustomers);
            }
            
            // SHOW data
            using (var command = connection.CreateCommand())
            {
                command.CommandText = @"
SELECT * FROM Customers
";
                var ds = new DataSet();
                var sqlDataAdapter = new SqlDataAdapter(command);
                sqlDataAdapter.Fill(ds);
                
                ds.Tables[0].TableName = "1 - Customers";
                
                FiddleHelper.WriteTable(ds.Tables[0]);
            }
        }
    }
    
    public static DataTable GenerateCustomers(int count) 
    {
        DataTable dtTable = new DataTable("Customers");
        
        dtTable.Columns.Add("CustomerID", typeof(int));
        dtTable.Columns.Add("Name", typeof(string)); 
    
        for(int i = 0; i < count; i++)
        {
            var drCustomer = dtTable.NewRow();  
            drCustomer["Name"] = "Customer_" + i;  
            dtTable.Rows.Add(drCustomer);
        }
        
        return dtTable;
    }
    
    public static void GenerateDatabase()
    {
        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
        {
            connection.Open();
            using (var command = connection.CreateCommand())
            {
                command.CommandText = @"   
CREATE TABLE [Customers]
(
    [CustomerID] [INT] IDENTITY(1,1) NOT NULL,
    [Name] [NVARCHAR](MAX) NULL,
    CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED 
    (
        [CustomerID] ASC
    )
)";
                command.ExecuteNonQuery();
            }
        }
    }
}

Cached Result
Last Run:	6:36:01 pm
Compile:	0.141s
Execute:	0s
Memory:	177kb
CPU:	0.016s

View IL Code