// @nuget: Dapper -Version 1.60.6

// @nuget: Z.Dapper.Plus

​

using Dapper;

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using Z.Dapper.Plus;

using System.Linq;

public class Program

{   

    public class Customer 

    {

        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()

    {

        DapperPlusManager.Entity<Customer>().Table("Customers").Identity(x => x.CustomerID);

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

        {

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

            connection.BulkInsert(list);

            FiddleHelper.WriteTable(list);

        }   

    }

}