/// <summary>
/// Bulk insert data reader using connection string.
/// </summary>
/// <param name="dataReader"></param>
/// <param name="connectionString"></param>
/// <param name="destinationTableName"></param>
/// <param name="sqlServerBulkInsertOptions"></param>
public static void BulkInsertSqlServer(this IDataReader dataReader, string connectionString, string destinationTableName, SqlServerBulkInsertOptions sqlServerBulkInsertOptions = null)
{
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
dataReader.BulkInsertSqlServer(connection, destinationTableName, sqlServerBulkInsertOptions);
}
}
