Exemple #1
0
        /// <summary>
        /// Imports the file and returns a reader.
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="transaction">The transaction.</param>
        /// <param name="parameters">The parameters.</param>
        /// <returns>IDataReader.</returns>
        /// <exception cref="System.ArgumentNullException">
        /// transaction
        /// or
        /// parameters
        /// </exception>
        public virtual IDataReader ImportFileReader <T>(SqlTransaction transaction, IImportFileParameters <T> parameters)
        {
            if (transaction == null)
            {
                throw new ArgumentNullException("transaction");
            }
            if (parameters == null)
            {
                throw new ArgumentNullException("parameters");
            }

            return(this.ImportData <T>(transaction, transaction.Connection, parameters, new FileSqlRecord <T>(parameters), true));
        }
Exemple #2
0
        /// <summary>
        /// Imports the file.
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="connection">The connection.</param>
        /// <param name="parameters">The parameters.</param>
        /// <exception cref="System.ArgumentNullException">
        /// connection
        /// or
        /// parameters
        /// </exception>
        public virtual void ImportFile <T>(SqlConnection connection, IImportFileParameters <T> parameters)
        {
            if (connection == null)
            {
                throw new ArgumentNullException("connection");
            }
            if (parameters == null)
            {
                throw new ArgumentNullException("parameters");
            }

            this.ImportData <T>(null, connection, parameters, new FileSqlRecord <T>(parameters));
        }
Exemple #3
0
        /// <summary>
        /// Imports the file and returns a reader.
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="connectionString">The connection string.</param>
        /// <param name="parameters">The parameters.</param>
        /// <returns>IDataReader.</returns>
        /// <exception cref="System.ArgumentNullException">
        /// connectionString
        /// or
        /// parameters
        /// </exception>
        public virtual IDataReader ImportFileReader <T>(string connectionString, IImportFileParameters <T> parameters)
        {
            if (String.IsNullOrWhiteSpace(connectionString))
            {
                throw new ArgumentNullException("connectionString");
            }
            if (parameters == null)
            {
                throw new ArgumentNullException("parameters");
            }

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                return(this.ImportData <T>(null, connection, parameters, new FileSqlRecord <T>(parameters), true));
            }
        }
Exemple #4
0
 public FileSqlRecord(IImportFileParameters <T> parameters)
     : base(parameters, parameters.Parser.HasRows())
 {
     this._data     = parameters.Parser.ParseFile();
     this._rowIndex = Math.Max(parameters.Parser.RowStart - 1, 1);
 }