Export (0) Print
Expand All

SqlDataReader Methods

The SqlDataReader type exposes the following members.

  Name Description
Public method Close Closes the SqlDataReader object. (Overrides DbDataReader.Close().)
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 Dispose() Releases all resources used by the current instance of the DbDataReader class. (Inherited from DbDataReader.)
Protected method Dispose(Boolean) Releases the managed resources used by the DbDataReader and optionally releases the unmanaged resources. (Inherited from DbDataReader.)
Public method Equals(Object) Determines whether the specified object is equal to the current object. (Inherited from Object.)
Protected method 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 GetBoolean Gets the value of the specified column as a Boolean. (Overrides DbDataReader.GetBoolean(Int32).)
Public method GetByte Gets the value of the specified column as a byte. (Overrides DbDataReader.GetByte(Int32).)
Public method GetBytes Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset. (Overrides DbDataReader.GetBytes(Int32, Int64, Byte[], Int32, Int32).)
Public method GetChar Gets the value of the specified column as a single character. (Overrides DbDataReader.GetChar(Int32).)
Public method GetChars Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset. (Overrides DbDataReader.GetChars(Int32, Int64, Char[], Int32, Int32).)
Public method GetData Returns a DbDataReader object for the requested column ordinal. (Inherited from DbDataReader.)
Public method GetDataTypeName Gets a string representing the data type of the specified column. (Overrides DbDataReader.GetDataTypeName(Int32).)
Public method GetDateTime Gets the value of the specified column as a DateTime object. (Overrides DbDataReader.GetDateTime(Int32).)
Public method GetDateTimeOffset Retrieves the value of the specified column as a DateTimeOffset object.
Protected method GetDbDataReader Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. (Inherited from DbDataReader.)
Public method GetDecimal Gets the value of the specified column as a Decimal object. (Overrides DbDataReader.GetDecimal(Int32).)
Public method GetDouble Gets the value of the specified column as a double-precision floating point number. (Overrides DbDataReader.GetDouble(Int32).)
Public method GetEnumerator Returns an IEnumerator that iterates through the SqlDataReader. (Overrides DbDataReader.GetEnumerator().)
Public method GetFieldType Gets the Type that is the data type of the object. (Overrides DbDataReader.GetFieldType(Int32).)
Public method GetFieldValue<T> Synchronously gets the value of the specified column as a type. GetFieldValueAsync is the asynchronous version of this method. (Overrides DbDataReader.GetFieldValue<T>(Int32).)
Public method GetFieldValueAsync<T>(Int32) Asynchronously gets the value of the specified column as a type. (Inherited from DbDataReader.)
Public method GetFieldValueAsync<T>(Int32, CancellationToken) Asynchronously gets the value of the specified column as a type. GetFieldValue<T> is the synchronous version of this method. (Overrides DbDataReader.GetFieldValueAsync<T>(Int32, CancellationToken).)
Public method GetFloat Gets the value of the specified column as a single-precision floating point number. (Overrides DbDataReader.GetFloat(Int32).)
Public method GetGuid Gets the value of the specified column as a globally unique identifier (GUID). (Overrides DbDataReader.GetGuid(Int32).)
Public method GetHashCode Serves as the default hash function. (Inherited from Object.)
Public method GetInt16 Gets the value of the specified column as a 16-bit signed integer. (Overrides DbDataReader.GetInt16(Int32).)
Public method GetInt32 Gets the value of the specified column as a 32-bit signed integer. (Overrides DbDataReader.GetInt32(Int32).)
Public method GetInt64 Gets the value of the specified column as a 64-bit signed integer. (Overrides DbDataReader.GetInt64(Int32).)
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method GetName Gets the name of the specified column. (Overrides DbDataReader.GetName(Int32).)
Public method GetOrdinal Gets the column ordinal, given the name of the column. (Overrides DbDataReader.GetOrdinal(String).)
Public method GetProviderSpecificFieldType Gets an Object that is a representation of the underlying provider-specific field type. (Overrides DbDataReader.GetProviderSpecificFieldType(Int32).)
Public method GetProviderSpecificValue Gets an Object that is a representation of the underlying provider specific value. (Overrides DbDataReader.GetProviderSpecificValue(Int32).)
Public method GetProviderSpecificValues Gets an array of objects that are a representation of the underlying provider specific values. (Overrides DbDataReader.GetProviderSpecificValues(Object[]).)
Public method GetSchemaTable Returns a DataTable that describes the column metadata of the SqlDataReader. (Overrides DbDataReader.GetSchemaTable().)
Public method GetSqlBinary Gets the value of the specified column as a SqlBinary.
Public method GetSqlBoolean Gets the value of the specified column as a SqlBoolean.
Public method GetSqlByte Gets the value of the specified column as a SqlByte.
Public method GetSqlBytes Gets the value of the specified column as SqlBytes.
Public method GetSqlChars Gets the value of the specified column as SqlChars.
Public method GetSqlDateTime Gets the value of the specified column as a SqlDateTime.
Public method GetSqlDecimal Gets the value of the specified column as a SqlDecimal.
Public method GetSqlDouble Gets the value of the specified column as a SqlDouble.
Public method GetSqlGuid Gets the value of the specified column as a SqlGuid.
Public method GetSqlInt16 Gets the value of the specified column as a SqlInt16.
Public method GetSqlInt32 Gets the value of the specified column as a SqlInt32.
Public method GetSqlInt64 Gets the value of the specified column as a SqlInt64.
Public method GetSqlMoney Gets the value of the specified column as a SqlMoney.
Public method GetSqlSingle Gets the value of the specified column as a SqlSingle.
Public method GetSqlString Gets the value of the specified column as a SqlString.
Public method GetSqlValue Returns the data value in the specified column as a SQL Server type.
Public method GetSqlValues Fills an array of Object that contains the values for all the columns in the record, expressed as SQL Server types.
Public method GetSqlXml Gets the value of the specified column as an XML value.
Public method GetStream Retrieves binary, image, varbinary, UDT, and variant data types as a Stream. (Overrides DbDataReader.GetStream(Int32).)
Public method GetString Gets the value of the specified column as a string. (Overrides DbDataReader.GetString(Int32).)
Public method GetTextReader Retrieves Char, NChar, NText, NVarChar, text, varChar, and Variant data types as a TextReader. (Overrides DbDataReader.GetTextReader(Int32).)
Public method GetTimeSpan Retrieves the value of the specified column as a TimeSpan object.
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Public method GetValue Gets the value of the specified column in its native format. (Overrides DbDataReader.GetValue(Int32).)
Public method GetValues Populates an array of objects with the column values of the current row. (Overrides DbDataReader.GetValues(Object[]).)
Public method GetXmlReader Retrieves data of type XML as an XmlReader.
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method IsCommandBehavior Determines whether the specified CommandBehavior matches that of the SqlDataReader .
Public method IsDBNull Gets a value that indicates whether the column contains non-existent or missing values. (Overrides DbDataReader.IsDBNull(Int32).)
Public method IsDBNullAsync(Int32) An asynchronous version of IsDBNull, which gets a value that indicates whether the column contains non-existent or missing values. (Inherited from DbDataReader.)
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.The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object. (Overrides DbDataReader.IsDBNullAsync(Int32, CancellationToken).)
Protected method 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 NextResult Advances the data reader to the next result, when reading the results of batch Transact-SQL statements. (Overrides DbDataReader.NextResult().)
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. (Inherited from DbDataReader.)
Public method NextResultAsync(CancellationToken) An asynchronous version of NextResult, which advances the data reader to the next result, when reading the results of batch Transact-SQL statements.The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object. (Overrides DbDataReader.NextResultAsync(CancellationToken).)
Public method Read Advances the SqlDataReader to the next record. (Overrides DbDataReader.Read().)
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. (Inherited from DbDataReader.)
Public method ReadAsync(CancellationToken) An asynchronous version of Read, which advances the SqlDataReader to the next record.The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object. (Overrides DbDataReader.ReadAsync(CancellationToken).)
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Top

  Name Description
Explicit interface implemetation Private method IDataRecord.GetData Returns an IDataReader for the specified column ordinal.
Top
Show:
© 2014 Microsoft