private OperationResult BulkInsert(DataTable internalTable, int timeOut = 20000, string connectionStringName = "BaseContext")
        {
            using (var connection = new BaseDatabase(connectionStringName, timeOut).Connection)
            {
                var bulkSql = new SqlBulkCopy
                              (
                    connection,
                    SqlBulkCopyOptions.TableLock |
                    SqlBulkCopyOptions.FireTriggers,
                    null
                              );
                try
                {
                    bulkSql.DestinationTableName = internalTable.TableName;
                    bulkSql.BulkCopyTimeout      = timeOut;
                    foreach (DataColumn coluna in internalTable.Columns)
                    {
                        if ((coluna.Table.TableName == "ExtraCards" ||
                             coluna.Table.TableName == "OrderItems" ||
                             coluna.Table.TableName == "OrderItemsDeleted") &&
                            (coluna.Caption == "Monthly" || coluna.Caption == "Formatting"))
                        {
                            continue;
                        }

                        bulkSql.ColumnMappings.Add(coluna.ColumnName, coluna.ColumnName);
                    }

                    connection.Open();
                    bulkSql.WriteToServer(internalTable);
                    connection.Close();

                    return(new OperationResult());
                }
                catch (Exception ex)
                {
                    return(new OperationResult(false, ex.Message));
                }
            }
        }