// @nuget: Z.BulkOperations

​

using Z.BulkOperations;

using System.Collections.Generic;

using System.Data.SqlClient;

public class Program

{   

    // table name is : Customers

    public class Customers 

    {

        public int CustomerID {get;set;}

        public string CustomerName {get;set;}

        public string ContactName {get;set;}

        public string Address {get;set;}

        public string City {get;set;}

        public string PostalCode {get;set;}

        public string Country {get;set;}

    }

    public static void Main()

    {

        var dt = new List<Customers>() { new Customers() { CustomerName = "ExampleBulkInsert", ContactName = "Example Name :" +  1}}; 

        using(var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools())) 

        {

            connection.Open();

            var bulk = new BulkOperation(connection);

            // Output Identity Value        

            bulk.ColumnMappings.Add("CustomerID", ColumnMappingDirectionType.Output);

            bulk.BulkInsert(dt);

        }

        FiddleHelper.WriteTable(dt);

    }

}