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:
EntityDataReader calls the DbDataReader.NextResult only when EntityDataReader.NextResult is explicitly called. If DbDataReader.NextResult throws an exeption, the EntityDataReader will wrap it in an EntityException (or a derived exception).
Close only closes the DbDataReader, without consuming any pending records or result sets.
Dispose only disposes of the DbDataReader, without consuming any pending records or result sets.
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 |
| 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 |
| 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) |