// @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 Supplier<T>

    {

        public int SupplierID {get;set;}

        public string SupplierName {get;set;}

        public string ContactName {get;set;}

        public T Something {get;set;}

    }

    public class MoreInfo

    {

        public string Address {get;set;}

        public string City {get;set;}

        public string PostalCode {get;set;}

    }

    public static void Main()

    {

        DapperPlusManager.Entity<Supplier<MoreInfo>>()

            .Table("Suppliers")

            .Identity(x => x.SupplierID)

            .Map(x => new { x.SupplierName, x.ContactName, Address = x.Something.Address, City = x.Something.City, PostalCode = x.Something.PostalCode });

        List<Supplier<MoreInfo>> suppliers = new List<Supplier<MoreInfo>>()

            { 

                new Supplier<MoreInfo>() { SupplierName = "ExampleSupplierBulkInsert", Something = 

                    new MoreInfo() { Address = "Address_Z", City = "City_Z", PostalCode = "PostalCode_Z" }  }

            };

​

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

        {   

            connection.BulkInsert(suppliers);

        }   

​

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

        {

            // For see all Colum of Table, with one row.

            FiddleHelper.WriteTable(connection.QueryFirstOrDefault("Select * FROM Suppliers WHERE SupplierName = 'ExampleSupplierBulkInsert'"));

        }

    }

}