How to use SqlBulkCopy with Strongly Typed DataTables

01-ListExtensions.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;

namespace ConsoleApplication1.SqlBulkCopy
{
    public static class ListExtensions
    {
        public static T AddNew<T>(this IList<T> list, T newItem)
        {
            list.Add(newItem);
            return newItem;
        }

        public static T AddNew<T>(this ICollection<T> list, T newItem)
        {
            list.Add(newItem);
            return newItem;
        }

        public static DataTable AsDataTable<T>(this IList<T> items)
        {
            PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(T));
            var table = new DataTable();
            foreach (PropertyDescriptor prop in properties)
            {
                table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
            }

            int t = table.Columns.Count;
            foreach (T item in items)
            {
                DataRow row = table.NewRow();
                foreach (PropertyDescriptor prop in properties)
                {
                    row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
                }
                table.Rows.Add(row);
            }
            return table;
        }
    }
}

02-ISqlBulkCopyService.cs

namespace ConsoleApplication1.SqlBulkCopy
{
    public interface ISqlBulkCopyService
    {
        void Save(SqlBulkCopyConfiguration configuration);
    }
}

03-SqlBulkCopyService.cs

using System;
using System.Data.SqlClient;


namespace ConsoleApplication1.SqlBulkCopy
{
    public class SqlBulkCopyService : ISqlBulkCopyService
    {
        public void Save(SqlBulkCopyConfiguration configuration)
        {
            using (var connection = new SqlConnection(configuration.ConnectionString))
            {
                connection.Open();
                SqlTransaction transaction = connection.BeginTransaction();

                using (var bulkCopy = new System.Data.SqlClient.SqlBulkCopy(connection, SqlBulkCopyOptions.Default, transaction))
                {
                    bulkCopy.BatchSize = configuration.BatchSize;
                    bulkCopy.DestinationTableName = configuration.TableName;
                    try
                    {
                        foreach (var column in configuration.DataTable.Columns)
                        {
                            bulkCopy.ColumnMappings.Add(column.ToString(), column.ToString());
                        }
                        bulkCopy.WriteToServer(configuration.DataTable);
                        transaction.Commit();
                    }
                    catch (Exception e)
                    {
                        transaction.Rollback();
                        connection.Close();
                        throw new Exception(e.Message);
                    }
                }
            }
        }
    }
}

04-SqlBulkCopyConfiguration.cs

using System.Data;

namespace ConsoleApplication1.SqlBulkCopy
{
    public class SqlBulkCopyConfiguration
    {
        public string ConnectionString { get; set; }
        public int BatchSize { get; set; }
        public DataTable DataTable { get; set; }
        public string TableName { get; set; }
    }
}

05-LoanApplication.cs

using System;

namespace ConsoleApplication1.SqlBulkCopy
{
    public class LoanApplication
    {
        public int ApplicationId { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public DateTime CreatedDate { get; set; }
    }
}

06-Program.cs

static async Task Main(string[] args)
{

    //Usage
    IList<LoanApplication> loanApplications = new List<LoanApplication>() { new LoanApplication() { ApplicationId = 1, CreatedDate = DateTime.Now, FirstName = "Michael", LastName = "Green" },
    new LoanApplication() { ApplicationId = 2, CreatedDate = DateTime.Now, FirstName = "Amy", LastName = "Green" }};

    if (loanApplications != null && loanApplications.Count()  > 0)
    {
        SqlBulkCopyConfiguration config = new SqlBulkCopyConfiguration()
        {
            BatchSize = 100,
            ConnectionString = "DatabaseConnectionString",
            DataTable = ListExtensions.AsDataTable<LoanApplication>(loanApplications),
            TableName = "dbo.SomeTableToInsertRecords"
        };
        new SqlBulkCopyService().Save(config);
    }

    Console.ReadLine();
}