Duration (Pacific Standard Time):
To (Pacific Standard Time):
Impact:
  • None
User Action:
  • None
.NET Framework Class Library

DbDataReader Class

Reads a forward-only stream of rows from a data source.

Namespace:  System.Data.Common
Assembly:  System.Data (in System.Data.dll)
Public MustInherit Class DbDataReader _
	Inherits MarshalByRefObject _
	Implements IDataReader, IDisposable, IDataRecord, IEnumerable

The DbDataReader type exposes the following members.

  Name Description
Protected method Supported by the XNA Framework DbDataReader Initializes a new instance of the DbDataReader class.
Top
  Name Description
Public property Supported by the XNA Framework Depth Gets a value indicating the depth of nesting for the current row.
Public property Supported by the XNA Framework FieldCount Gets the number of columns in the current row.
Public property Supported by the XNA Framework HasRows Gets a value that indicates whether this DbDataReader contains one or more rows.
Public property Supported by the XNA Framework IsClosed Gets a value indicating whether the DbDataReader is closed.
Public property Supported by the XNA Framework Item[Int32] Gets the value of the specified column as an instance of Object.
Public property Supported by the XNA Framework Item[String] Gets the value of the specified column as an instance of Object.
Public property Supported by the XNA Framework RecordsAffected Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.
Public property Supported by the XNA Framework VisibleFieldCount Gets the number of fields in the DbDataReader that are not hidden.
Top
  Name Description
Public method Supported by the XNA Framework Close Closes the DbDataReader object.
Public method CreateObjRef Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public method Supported by the XNA Framework Dispose() Releases all resources used by the current instance of the DbDataReader class.
Protected method Supported by the XNA Framework Dispose(Boolean) Releases the managed resources used by the DbDataReader and optionally releases the unmanaged resources.
Public method Supported by the XNA Framework Equals(Object) Determines whether the specified object is equal to the current object. (Inherited from Object.)
Protected method Supported by the XNA Framework Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method Supported by the XNA Framework GetBoolean Gets the value of the specified column as a Boolean.
Public method Supported by the XNA Framework GetByte Gets the value of the specified column as a byte.
Public method Supported by the XNA Framework GetBytes Reads a stream of bytes from the specified column, starting at location indicated by dataOffset, into the buffer, starting at the location indicated by bufferOffset.
Public method Supported by the XNA Framework GetChar Gets the value of the specified column as a single character.
Public method Supported by the XNA Framework GetChars Reads a stream of characters from the specified column, starting at location indicated by dataOffset, into the buffer, starting at the location indicated by bufferOffset.
Public method Supported by the XNA Framework GetData Returns a DbDataReader object for the requested column ordinal.
Public method Supported by the XNA Framework GetDataTypeName Gets name of the data type of the specified column.
Public method Supported by the XNA Framework GetDateTime Gets the value of the specified column as a DateTime object.
Protected method Supported by the XNA Framework GetDbDataReader Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation.
Public method Supported by the XNA Framework GetDecimal Gets the value of the specified column as a Decimal object.
Public method Supported by the XNA Framework GetDouble Gets the value of the specified column as a double-precision floating point number.
Public method Supported by the XNA Framework GetEnumerator Returns an IEnumerator that can be used to iterate through the rows in the data reader.
Public method Supported by the XNA Framework GetFieldType Gets the data type of the specified column.
Public method GetFieldValue<T> Synchronously gets the value of the specified column as a type.
Public method GetFieldValueAsync<T>(Int32) Asynchronously gets the value of the specified column as a type.
Public method GetFieldValueAsync<T>(Int32, CancellationToken) Asynchronously gets the value of the specified column as a type.
Public method Supported by the XNA Framework GetFloat Gets the value of the specified column as a single-precision floating point number.
Public method Supported by the XNA Framework GetGuid Gets the value of the specified column as a globally-unique identifier (GUID).
Public method Supported by the XNA Framework GetHashCode Serves as the default hash function. (Inherited from Object.)
Public method Supported by the XNA Framework GetInt16 Gets the value of the specified column as a 16-bit signed integer.
Public method Supported by the XNA Framework GetInt32 Gets the value of the specified column as a 32-bit signed integer.
Public method Supported by the XNA Framework GetInt64 Gets the value of the specified column as a 64-bit signed integer.
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method Supported by the XNA Framework GetName Gets the name of the column, given the zero-based column ordinal.
Public method Supported by the XNA Framework GetOrdinal Gets the column ordinal given the name of the column.
Public method Supported by the XNA Framework GetProviderSpecificFieldType Returns the provider-specific field type of the specified column.
Public method Supported by the XNA Framework GetProviderSpecificValue Gets the value of the specified column as an instance of Object.
Public method Supported by the XNA Framework GetProviderSpecificValues Gets all provider-specific attribute columns in the collection for the current row.
Public method Supported by the XNA Framework GetSchemaTable Returns a DataTable that describes the column metadata of the DbDataReader.
Public method GetStream Retrieves data as a Stream.
Public method Supported by the XNA Framework GetString Gets the value of the specified column as an instance of String.
Public method GetTextReader Retrieves data as a TextReader.
Public method Supported by the XNA Framework GetType Gets the Type of the current instance. (Inherited from Object.)
Public method Supported by the XNA Framework GetValue Gets the value of the specified column as an instance of Object.
Public method Supported by the XNA Framework GetValues Populates an array of objects with the column values of the current row.
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method Supported by the XNA Framework IsDBNull Gets a value that indicates whether the column contains nonexistent or missing values.
Public method IsDBNullAsync(Int32) An asynchronous version of IsDBNull, which gets a value that indicates whether the column contains non-existent or missing values.
Public method IsDBNullAsync(Int32, CancellationToken) An asynchronous version of IsDBNull, which gets a value that indicates whether the column contains non-existent or missing values. Optionally, sends a notification that operations should be cancelled.
Protected method Supported by the XNA Framework MemberwiseClone() Creates a shallow copy of the current Object. (Inherited from Object.)
Protected method MemberwiseClone(Boolean) Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.)
Public method Supported by the XNA Framework NextResult Advances the reader to the next result when reading the results of a batch of statements.
Public method NextResultAsync() An asynchronous version of NextResult, which advances the reader to the next result when reading the results of a batch of statements.Invokes NextResultAsync with CancellationToken.None.
Public method NextResultAsync(CancellationToken) This is the asynchronous version of NextResult. Providers should override with an appropriate implementation. The cancellationToken may optionally be ignored.The default implementation invokes the synchronous NextResult method and returns a completed task, blocking the calling thread. The default implementation will return a cancelled task if passed an already cancelled cancellationToken. Exceptions thrown by NextResult will be communicated via the returned Task Exception property.Other methods and properties of the DbDataReader object should not be invoked while the returned Task is not yet completed.
Public method Supported by the XNA Framework Read Advances the reader to the next record in a result set.
Public method ReadAsync() An asynchronous version of Read, which advances the reader to the next record in a result set. This method invokes ReadAsync with CancellationToken.None.
Public method ReadAsync(CancellationToken) This is the asynchronous version of Read. Providers should override with an appropriate implementation. The cancellationToken may optionally be ignored.The default implementation invokes the synchronous Read method and returns a completed task, blocking the calling thread. The default implementation will return a cancelled task if passed an already cancelled cancellationToken. Exceptions thrown by Read will be communicated via the returned Task Exception property.Do not invoke other methods and properties of the DbDataReader object until the returned Task is complete.
Public method Supported by the XNA Framework ToString Returns a string that represents the current object. (Inherited from Object.)
Top
  Name Description
Public Extension Method AsParallel Enables parallelization of a query. (Defined by ParallelEnumerable.)
Public Extension Method AsQueryable Converts an IEnumerable to an IQueryable. (Defined by Queryable.)
Public Extension Method Supported by the XNA Framework Cast<TResult> Casts the elements of an IEnumerable to the specified type. (Defined by Enumerable.)
Public Extension Method Supported by the XNA Framework OfType<TResult> Filters the elements of an IEnumerable based on a specified type. (Defined by Enumerable.)
Top
  Name Description
Explicit interface implemetation Private method Supported by the XNA Framework IDataRecord.GetData For a description of this member, see IDataRecord.GetData.
Top

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.