public void TransferDate()
        {
            ReaderToColumnMap map = new ReaderToColumnMap("StatehoodDate", "AdmissionDate");
            map.Initialize(_destinationTable, _reader);

            // Move to first row
            _reader.Read();

            map.Fill(_row, _reader);

            Assert.AreEqual(_texasDate, (DateTime)_row["AdmissionDate"]);
        }
        public void TransferADBNull()
        {
            ReaderToColumnMap map = new ReaderToColumnMap("StatehoodDate", "AdmissionDate");
            map.Initialize(_destinationTable, _reader);

            // Move to second row
            _reader.Read();
            _reader.Read();

            map.Fill(_row, _reader);

            Assert.AreEqual(DBNull.Value, _row["AdmissionDate"]);
        }
        public void TransferLong()
        {
            ReaderToColumnMap map = new ReaderToColumnMap("Population", "Residents");
            map.Initialize(_destinationTable, _reader);

            // Move to first row
            _reader.Read();

            map.Fill(_row, _reader);

            Assert.AreEqual(5, (long)_row["Residents"]);
        }
 public void InitializeWithAnInvalidReaderNameAndThrowAnException()
 {
     ReaderToColumnMap map = new ReaderToColumnMap("NotARealColumn", "AdmissionDate");
     map.Initialize(_destinationTable, _reader);
 }
 public void InitializeWithAnInvalidColumnNameAndThrowAnException()
 {
     ReaderToColumnMap map = new ReaderToColumnMap("StatehoodDate", "NotARealColumn");
     map.Initialize(_destinationTable, _reader);
 }
        public void TransferString()
        {
            ReaderToColumnMap map = new ReaderToColumnMap("State", "StateName");
            map.Initialize(_destinationTable, _reader);

            // Move to first row
            _reader.Read();

            map.Fill(_row, _reader);

            Assert.AreEqual("Texas", (string)_row["StateName"]);
        }