System.Data.DataTableReader.Read C# (CSharp) Method

Read() public method

public Read ( ) : bool
return bool
        public override bool Read()
        {
            if (!_started)
            {
                _started = true;
            }

            ValidateOpen(nameof(Read));
            ValidateReader();

            if (_reachEORows)
            {
                return false;
            }

            if (_rowCounter >= _currentDataTable.Rows.Count - 1)
            {
                _reachEORows = true;
                if (_listener != null)
                {
                    _listener.CleanUp();
                }
                return false;
            }

            _rowCounter++;
            ValidateRow(_rowCounter);
            _currentDataRow = _currentDataTable.Rows[_rowCounter];

            while (_currentDataRow.RowState == DataRowState.Deleted)
            {
                _rowCounter++;
                if (_rowCounter == _currentDataTable.Rows.Count)
                {
                    _reachEORows = true;
                    if (_listener != null)
                    {
                        _listener.CleanUp();
                    }
                    return false;
                }
                ValidateRow(_rowCounter);
                _currentDataRow = _currentDataTable.Rows[_rowCounter];
            }
            if (_currentRowRemoved)
            {
                _currentRowRemoved = false;
            }

            return true;
        }

Usage Example

        public void Fact()
        {
            var connection = default (DbConnection);
            var reader = default(DbDataReader);

            try
            {
                connection = KandaXunitProviderFactory.Instance.CreateConnection();
                connection.Open();

                var schema = connection.GetTablesSchema();
                reader = new DataTableReader(schema);

                while (reader.Read())
                {
                    var name = reader.GetString(reader.GetOrdinal(@"TABLE_NAME"));
                    var type = reader.GetString(reader.GetOrdinal(@"TABLE_TYPE"));

                    //this.transformEntity(name, type);
                    this.transformInsertTable(name, type);
                }
            }
            finally
            {
                if (reader != null) { reader.Close(); }
                if (connection != null) { connection.Close(); }
            }
        }
All Usage Examples Of System.Data.DataTableReader::Read