/// <summary>
        /// Imports a redirect file into the Skybrud redirect table
        /// </summary>
        /// <param name="file"></param>
        /// <returns></returns>
        public virtual ImporterResponse Import(IRedirectsFile file)
        {
            var response = new ImporterResponse();

            file.Load();

            response.ImportedItems = file.ValidatedItems;
            response.File          = file;

            var inserter = new SqlServerBulkCopy();

            inserter.BulkImport(file.ValidatedItems);

            RaiseEvent(response);

            return(response);
        }
        public static DbBulkCopy GetDbBulkCopy(DbAccessor dba, string connectionString)
        {
            DbBulkCopy dbBulkCopy = null;

            if (dba.GetType() == typeof(SqlServerAccessor))
            {
                dbBulkCopy = new SqlServerBulkCopy(connectionString);
            }

            if (dbBulkCopy != null)
            {
                return(dbBulkCopy);
            }
            else
            {
                throw new Exception(string.Format("“{0}”没有对应的DbBulkCopy实现!", dba.GetType()));
            }
        }