DbDataReader Class
Definition
Reads a forward-only stream of rows from a data source.
public ref class DbDataReader abstract : MarshalByRefObject, IDisposable, System::Collections::IEnumerable, System::Data::IDataReaderpublic abstract class DbDataReader : MarshalByRefObject, IDisposable, System.Collections.IEnumerable, System.Data.IDataReadertype DbDataReader = class
inherit MarshalByRefObject
interface IDataReader
interface IEnumerable
interface IDisposable
interface IDataRecordPublic MustInherit Class DbDataReader
Inherits MarshalByRefObject
Implements IDataReader, IDisposable, IEnumerable- Inheritance
- Derived
- Implements
Constructors
| DbDataReader() |
Initializes a new instance of the DbDataReader class. |
Properties
| Depth |
Gets a value indicating the depth of nesting for the current row. |
| FieldCount |
When overridden in a derived class, gets the number of columns in the current row. |
| HasRows |
When overridden in a derived class, gets a value that indicates whether this DbDataReader contains one or more rows. |
| IsClosed |
When overridden in a derived class, gets a value indicating whether the DbDataReader is closed. |
| Item[Int32] |
When overridden in a derived class, gets the value of the specified column as an instance of Object. |
| Item[String] |
When overridden in a derived class, gets the value of the specified column as an instance of Object. |
| RecordsAffected |
When overridden in a derived class, gets the number of rows changed, inserted, or deleted by execution of the SQL statement. |
| VisibleFieldCount |
Gets the number of fields in the DbDataReader that are not hidden. |
Methods
| Close() |
Closes the DbDataReader object. |
| CloseAsync() |
Asynchronously closes the DbDataReader object. |
| CreateObjRef(Type) |
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject) |
| Dispose() |
Releases all resources used by the current instance of the DbDataReader class. |
| Dispose(Boolean) |
Releases the unmanaged resources used by the DbDataReader and optionally releases the managed resources. |
| DisposeAsync() |
Asynchronously releases all resources used by the current instance of the DbDataReader class. |
| Equals(Object) |
Determines whether the specified object is equal to the current object. (Inherited from Object) |
| GetBoolean(Int32) |
When overridden in a derived class, gets the value of the specified column as a Boolean. |
| GetByte(Int32) |
When overridden in a derived class, gets the value of the specified column as a byte. |
| GetBytes(Int32, Int64, Byte[], Int32, Int32) |
When overridden in a derived class, reads a specified number of bytes from the specified column starting at a specified index and writes them to a buffer starting at a specified position in the buffer. |
| GetChar(Int32) |
When overridden in a derived class, gets the value of the specified column as a single character. |
| GetChars(Int32, Int64, Char[], Int32, Int32) |
When overridden in a derived class, reads a specified number of characters from a specified column starting at a specified index, and writes them to a buffer starting at a specified position. |
| GetData(Int32) |
Returns a nested data reader for the requested column. |
| GetDataTypeName(Int32) |
When overridden in a derived class, gets name of the data type of the specified column. |
| GetDateTime(Int32) |
When overridden in a derived class, gets the value of the specified column as a DateTime object. |
| GetDbDataReader(Int32) |
Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. |
| GetDecimal(Int32) |
When overridden in a derived class, gets the value of the specified column as a Decimal. |
| GetDouble(Int32) |
When overridden in a derived class, gets the value of the specified column as a double-precision floating point number. |
| GetEnumerator() |
When overridden in a derived class, returns an enumerator that can be used to iterate through the rows in the data reader. |
| GetFieldType(Int32) |
When overridden in a derived class, gets the data type of the specified column. |
| GetFieldValue<T>(Int32) |
Gets the value of the specified column as the requested type. |
| GetFieldValueAsync<T>(Int32) |
Asynchronously gets the value of the specified column as the requested type. |
| GetFieldValueAsync<T>(Int32, CancellationToken) |
Asynchronously gets the value of the specified column as the requested type. |
| GetFloat(Int32) |
When overridden in a derived class, gets the value of the specified column as a single-precision floating point number. |
| GetGuid(Int32) |
When overridden in a derived class, gets the value of the specified column as a globally unique identifier (GUID). |
| GetHashCode() |
Serves as the default hash function. (Inherited from Object) |
| GetInt16(Int32) |
When overridden in a derived class, gets the value of the specified column as a 16-bit signed integer. |
| GetInt32(Int32) |
When overridden in a derived class, gets the value of the specified column as a 32-bit signed integer. |
| GetInt64(Int32) |
When overridden in a derived class, gets the value of the specified column as a 64-bit signed integer. |
| GetLifetimeService() |
Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject) |
| GetName(Int32) |
When overridden in a derived class, gets the name of the column, given the zero-based column ordinal. |
| GetOrdinal(String) |
When overridden in a derived class, gets the column ordinal given the name of the column. |
| GetProviderSpecificFieldType(Int32) |
Gets the provider-specific type of the specified column. |
| GetProviderSpecificValue(Int32) |
Gets the value of the specified column as an instance of a provider-specific type. |
| GetProviderSpecificValues(Object[]) |
Gets all provider-specific attribute columns in the collection for the current row. |
| GetSchemaTable() |
Returns a DataTable that describes the column metadata of the DbDataReader. |
| GetStream(Int32) |
Gets a stream to retrieve data from the specified column. |
| GetString(Int32) |
When overridden in a derived class, gets the value of the specified column as an instance of String. |
| GetTextReader(Int32) |
Gets a text reader to retrieve data from the column. |
| GetType() |
Gets the Type of the current instance. (Inherited from Object) |
| GetValue(Int32) |
When overridden in a derived class, gets the value of the specified column as an instance of Object. |
| GetValues(Object[]) |
When overridden in a derived class, populates an array of objects with the column values of the current row. |
| InitializeLifetimeService() |
Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject) |
| IsDBNull(Int32) |
When overridden in a derived class, gets a value that indicates whether the column contains nonexistent or missing values. |
| IsDBNullAsync(Int32) |
Asynchronously gets a value that indicates whether the column contains non-existent or missing values. |
| IsDBNullAsync(Int32, CancellationToken) |
Asynchronously gets a value that indicates whether the column contains non-existent or missing values. |
| MemberwiseClone() |
Creates a shallow copy of the current Object. (Inherited from Object) |
| MemberwiseClone(Boolean) |
Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject) |
| NextResult() |
When overridden in a derived class, advances the reader to the next result when reading the results of a batch of statements. |
| NextResultAsync() |
Asynchronously advances the reader to the next result when reading the results of a batch of statements. |
| NextResultAsync(CancellationToken) |
Asynchronously advances the reader to the next result when reading the results of a batch of statements. |
| Read() |
When overridden in a derived class, advances the reader to the next record in a result set. |
| ReadAsync() |
Asynchronously advances the reader to the next record in a result set. |
| ReadAsync(CancellationToken) |
Asynchronously advances the reader to the next record in a result set. |
| ToString() |
Returns a string that represents the current object. (Inherited from Object) |
Explicit Interface Implementations
| IDataReader.Close() |
For a description of this member, see Close(). |
| IDataReader.GetSchemaTable() |
For a description of this member, see GetSchemaTable(). |
| IDataRecord.GetData(Int32) |
For a description of this member, see GetData(Int32). |
Extension Methods
| CanGetColumnSchema(DbDataReader) |
Gets a value that indicates whether a DbDataReader can get a column schema. |
| GetColumnSchema(DbDataReader) |
Gets the column schema (DbColumn collection) for a DbDataReader. |
| GetBoolean(DbDataReader, String) |
Gets the value of the specified column as a Boolean. |
| GetByte(DbDataReader, String) |
Gets the value of the specified column as a byte. |
| GetBytes(DbDataReader, String, Int64, Byte[], Int32, Int32) |
Reads a specified number of bytes from the specified column starting at a specified index and writes them to a buffer starting at a specified position in the buffer. |
| GetChar(DbDataReader, String) |
Gets the value of the specified column as a single character. |
| GetChars(DbDataReader, String, Int64, Char[], Int32, Int32) |
Reads a specified number of characters from a specified column starting at a specified index, and writes them to a buffer starting at a specified position. |
| GetData(DbDataReader, String) |
Returns a nested data reader for the requested column. |
| GetDataTypeName(DbDataReader, String) |
Gets name of the data type of the specified column. |
| GetDateTime(DbDataReader, String) |
Gets the value of the specified column as a DateTime object. |
| GetDecimal(DbDataReader, String) |
Gets the value of the specified column as a Decimal. |
| GetDouble(DbDataReader, String) |
Gets the value of the specified column as a double-precision floating point number. |
| GetFieldType(DbDataReader, String) |
Gets the data type of the specified column. |
| GetFieldValue<T>(DbDataReader, String) |
Gets the value of the specified column as the requested type. |
| GetFieldValueAsync<T>(DbDataReader, String, CancellationToken) |
Asynchronously gets the value of the specified column as the requested type. |
| GetFloat(DbDataReader, String) |
Gets the value of the specified column as a single-precision floating point number. |
| GetGuid(DbDataReader, String) |
Gets the value of the specified column as a globally unique identifier (GUID). |
| GetInt16(DbDataReader, String) |
Gets the value of the specified column as a 16-bit signed integer. |
| GetInt32(DbDataReader, String) |
Gets the value of the specified column as a 32-bit signed integer. |
| GetInt64(DbDataReader, String) |
Gets the value of the specified column as a 64-bit signed integer. |
| GetProviderSpecificFieldType(DbDataReader, String) |
Gets the provider-specific type of the specified column. |
| GetProviderSpecificValue(DbDataReader, String) |
Gets the value of the specified column as an instance of a provider-specific type. |
| GetStream(DbDataReader, String) |
Gets a stream to retrieve data from the specified column. |
| GetString(DbDataReader, String) |
Gets the value of the specified column as an instance of String. |
| GetTextReader(DbDataReader, String) |
Gets a text reader to retrieve data from the column. |
| GetValue(DbDataReader, String) |
Gets the value of the specified column as an instance of Object. |
| IsDBNull(DbDataReader, String) |
Gets a value that indicates whether the column contains nonexistent or missing values. |
| IsDBNullAsync(DbDataReader, String, CancellationToken) |
Asynchronously gets a value that indicates whether the column contains non-existent or missing values. |
| Cast<TResult>(IEnumerable) |
Casts the elements of an IEnumerable to the specified type. |
| OfType<TResult>(IEnumerable) |
Filters the elements of an IEnumerable based on a specified type. |
| AsParallel(IEnumerable) |
Enables parallelization of a query. |
| AsQueryable(IEnumerable) |
Converts an IEnumerable to an IQueryable. |