EntityDataReader Class

Definition

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

public class EntityDataReader : System.Data.Common.DbDataReader, System.Data.IExtendedDataRecord
Inheritance
Implements

Inherited Members

System.Data.Common.DbDataReader

System.MarshalByRefObject

System.Object

Remarks

Combines the functionality of the DbDataReader class and the IExtendedDataRecord interface.

An EntityDataReader has no public constructor. It can only be obtained through one of the EntityCommand.ExecuteReader method overloads.

SQL Server puts output parameters from stored procedures at the end of the result stream, after all the result sets. Therefore, to get output parameter values, an application must consume all the records in all the result sets. If the application closes the EntityDataReader (which would also close the DbDataReader), output parameters might not be populated.

EntityDataReader does not implicitly consume result sets to make output parameters available. Therefore, note the following:

For code examples, see Working with EntityClient.

Properties

DataRecordInfo

Gets DataRecordInfo for this IExtendedDataRecord.

Depth

Gets a value indicating the depth of nesting for the current row.

FieldCount

Gets the number of columns in the current row.

HasRows

Gets a value that indicates whether this EntityDataReader contains one or more rows.

IsClosed

Gets a value indicating whether the EntityDataReader is closed.

Item[Int32]

Gets the value of the specified column as an instance of Object.

Item[String]

Gets the value of the specified column as an instance of Object.

RecordsAffected

Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.

VisibleFieldCount

Gets the number of fields in the EntityDataReader that are not hidden.

Methods

Close()

Closes the EntityDataReader object.

Dispose(Boolean)

Releases the resources consumed by this EntityDataReader and calls Close().

GetBoolean(Int32)

Gets the value of the specified column as a Boolean.

GetByte(Int32)

Gets the value of the specified column as a byte.

GetBytes(Int32, Int64, Byte[], Int32, Int32)

Reads a stream of bytes from the specified column, starting at location indicated by dataIndex, into the buffer, starting at the location indicated by bufferIndex.

GetChar(Int32)

Gets the value of the specified column as a single character.

GetChars(Int32, Int64, Char[], Int32, Int32)

Reads a stream of characters from the specified column, starting at location indicated by dataIndex, into the buffer, starting at the location indicated by bufferIndex.

GetDataReader(Int32)

Returns nested readers as DbDataReader objects.

GetDataRecord(Int32)

Returns a nested DbDataRecord.

GetDataTypeName(Int32)

Gets the name of the data type of the specified column.

GetDateTime(Int32)

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)

Gets the value of the specified column as a Decimal object.

GetDouble(Int32)

Gets the value of the specified column as a double-precision floating point number.

GetEnumerator()

Returns an IEnumerator that can be used to iterate through the rows in the data reader.

GetFieldType(Int32)

Gets the data type of the specified column.

GetFloat(Int32)

Gets the value of the specified column as a single-precision floating point number.

GetGuid(Int32)

Gets the value of the specified column as a globally-unique identifier (GUID).

GetInt16(Int32)

Gets the value of the specified column as a 16-bit signed integer.

GetInt32(Int32)

Gets the value of the specified column as a 32-bit signed integer.

GetInt64(Int32)

Gets the value of the specified column as a 64-bit signed integer.

GetName(Int32)

Gets the name of the column, given the zero-based column ordinal.

GetOrdinal(String)

Gets the column ordinal given the name of the column.

GetProviderSpecificFieldType(Int32)

Returns the provider-specific field type of the specified column.

GetProviderSpecificValue(Int32)

Gets the value of the specified column as an instance of Object.

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.

GetString(Int32)

Gets the value of the specified column as an instance of String.

GetValue(Int32)

Gets the value of the specified column as an instance of Object.

GetValues(Object[])

Populates an array of objects with the column values of the current row.

IsDBNull(Int32)

Gets a value that indicates whether the column contains nonexistent or missing values.

NextResult()

Advances the reader to the next result when reading the results of a batch of statements.

Read()

Advances the reader to the next record in a result set.

Extension Methods

Cast<TResult>(IEnumerable)
OfType<TResult>(IEnumerable)
AsParallel(IEnumerable)
AsQueryable(IEnumerable)