Class in CsvHelper
An IDataReader over a CsvReader, for APIs that read data readers: DataTable.Load, SqlBulkCopy.WriteToServer and the like. Every column is a string column named after the header (Column1, Column2 and so on without one); the typed getters (GetInt32 and the others) parse fields as the reader's CsvReader.Parse<T>(int) does.
public sealed class CsvDataReader : DbDataReaderCsvHelperCsvHelper.dllA field is DBNull (IsDBNull) when it is one of the reader's CsvReaderOptions.NullValues; an empty field is an empty string unless "" is one of them. The columns are those of the header, or, without a header, of the first record.
public CsvDataReader(CsvReader reader, bool leaveOpen = false)Creates a data reader over reader, which it reads from its current position.
readerCsvReaderleaveOpenboolreader stays open when the data reader is closed.reader is null.public override int Depth { get; }Always 0: CSV is not nested.
public override int FieldCount { get; }The number of columns: those of the header, or of the first record.
public override bool HasRows { get; }true while the data reader is open; whether records remain is only known by reading.
public override bool IsClosed { get; }Whether Close has been called.
public override int RecordsAffected { get; }Always -1: reading changes no records.
public override object this[int ordinal] { get; }Gets the value of column ordinal. See GetValue.
ordinalintpublic override object this[string name] { get; }Gets the value of the column called name. See GetValue.
namestringpublic override void Close()Closes the data reader, and disposes the CSV reader unless it was created with leaveOpen.
protected override void Dispose(bool disposing)Closes the data reader. See Close.
disposingboolpublic override bool GetBoolean(int ordinal)Parses the field as a bool. See CsvReader.Parse<T>(int).
ordinalintpublic override byte GetByte(int ordinal)Parses the field as a byte, in the reader's format provider.
ordinalintpublic override long GetBytes(int ordinal, long dataOffset, byte[]? buffer, int bufferOffset, int length)Copies the UTF-8 bytes of the field into buffer.
ordinalintdataOffsetlongbufferbyte[]?null to get the length of the field.bufferOffsetintbuffer to copy to.lengthintbuffer is null.public override char GetChar(int ordinal)Gets the first character of the field.
ordinalintpublic override long GetChars(int ordinal, long dataOffset, char[]? buffer, int bufferOffset, int length)Copies the characters of the field into buffer.
ordinalintdataOffsetlongbufferchar[]?null to get the length of the field.bufferOffsetintbuffer to copy to.lengthintbuffer is null.public override string GetDataTypeName(int ordinal)Always String.
ordinalintString.public override DateTime GetDateTime(int ordinal)Parses the field as a DateTime. See CsvReader.Parse<T>(int).
ordinalintpublic override decimal GetDecimal(int ordinal)Parses the field as a decimal. See CsvReader.Parse<T>(int).
ordinalintpublic override double GetDouble(int ordinal)Parses the field as a double. See CsvReader.Parse<T>(int).
ordinalintpublic override IEnumerator GetEnumerator()Returns an enumerator of the records, as IDataRecords.
public override Type GetFieldType(int ordinal)Always string: CSV fields are text.
ordinalintpublic override float GetFloat(int ordinal)Parses the field as a float. See CsvReader.Parse<T>(int).
ordinalintpublic override Guid GetGuid(int ordinal)Parses the field as a Guid. See CsvReader.Parse<T>(int).
ordinalintpublic override short GetInt16(int ordinal)Parses the field as a short, in the reader's format provider.
ordinalintpublic override int GetInt32(int ordinal)Parses the field as an int. See CsvReader.Parse<T>(int).
ordinalintpublic override long GetInt64(int ordinal)Parses the field as a long. See CsvReader.Parse<T>(int).
ordinalintpublic override string GetName(int ordinal)Gets the name of column ordinal.
ordinalintColumn and the 1-based number without a header.ordinal is not a column.public override int GetOrdinal(string name)Gets the index of the column called name, matched as by CsvReader.GetFieldIndex(string).
namestringpublic override DataTable GetSchemaTable()Describes the columns for DataTable.Load and other consumers: their names, ordinals and type (string), all of them nullable.
public override string GetString(int ordinal)Gets the field as a string. See CsvReader.GetString(int).
ordinalintpublic override object GetValue(int ordinal)Gets the value of column ordinal: its text, or DBNull.Value when IsDBNull says so.
ordinalintpublic override int GetValues(object[] values)Copies the values of the current record into values. See GetValue.
valuesobject[]values is null.public override bool IsDBNull(int ordinal)Whether the field is one of the reader's CsvReaderOptions.NullValues.
ordinalinttrue for a null value.public override bool NextResult()Always false: a CSV file has one result set.
false.public override bool Read()Advances to the next record. See CsvReader.Read.