![]() | SphinxQLDataReader Class |
Namespace: SphinxConnector.SphinxQL
The SphinxQLDataReader type exposes the following members.
Name | Description | |
---|---|---|
![]() | Depth |
Gets a value indicating the depth of nesting for the current row. Always returns 0.
(Overrides DbDataReader.Depth.) |
![]() | FieldCount |
Gets the number of columns in the current row.
(Overrides DbDataReader.FieldCount.) |
![]() | HasRows |
Gets a value that indicates whether this SphinxQLDataReader contains one or more rows.
(Overrides DbDataReader.HasRows.) |
![]() | IsClosed |
Gets a value indicating whether the SphinxQLDataReader is closed.
(Overrides DbDataReader.IsClosed.) |
![]() | Item[Int32] |
Gets the Object with the specified ordinal.
(Overrides DbDataReader.Item[Int32].) |
![]() | Item[String] |
Gets the Object with the specified name.
(Overrides DbDataReader.Item[String].) |
![]() | RecordsAffected |
Gets the number of rows changed, inserted, or deleted by execution of the SphinxQL statement.
(Overrides DbDataReader.RecordsAffected.) |
![]() | VisibleFieldCount | Gets the number of fields in the DbDataReader that are not hidden. (Inherited from DbDataReader.) |
Name | Description | |
---|---|---|
![]() | Close |
Closes the SphinxQLDataReader object.
(Overrides DbDataReader.Close().) |
![]() | CloseAsync |
Asynchronously closes the SphinxQLDataReader object.
|
![]() | 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.) |
![]() | Dispose | Releases all resources used by the current instance of the DbDataReader class. (Inherited from DbDataReader.) |
![]() | DisposeAsync |
Asynchronously dispose the SphinxQLDataReader object.
|
![]() | Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
![]() | GetBoolean(Int32) |
Gets the value of the specified column as a Boolean.
(Overrides DbDataReader.GetBoolean(Int32).) |
![]() | GetBoolean(String) |
Gets the value of the specified column as a Boolean.
|
![]() | GetByte |
Gets the value of the specified column as a byte.
(Overrides DbDataReader.GetByte(Int32).) |
![]() | 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.
Currently not supported.
(Overrides DbDataReader.GetBytes(Int32, Int64,Byte[], Int32, Int32).) |
![]() | GetChar(Int32) |
Gets the value of the specified column as a single character.
(Overrides DbDataReader.GetChar(Int32).) |
![]() | GetChar(String) |
Gets the value of the specified column as a single character.
|
![]() | 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.
Currently not supported.
(Overrides DbDataReader.GetChars(Int32, Int64,Char[], Int32, Int32).) |
![]() | GetData | Returns a DbDataReader object for the requested column ordinal. (Inherited from DbDataReader.) |
![]() | GetDataTypeName |
Gets the name of the data type of the specified column.
(Overrides DbDataReader.GetDataTypeName(Int32).) |
![]() | GetDateTime(Int32) |
Gets the value of the specified column as a DateTime object.
(Overrides DbDataReader.GetDateTime(Int32).) |
![]() | GetDateTime(String) |
Gets the value of the specified column as a DateTime object.
|
![]() | GetDecimal(Int32) |
Gets the value of the specified column as a Decimal object.
(Overrides DbDataReader.GetDecimal(Int32).) |
![]() | GetDecimal(String) |
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.
(Overrides DbDataReader.GetDouble(Int32).) |
![]() | GetDouble(String) |
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.
(Overrides DbDataReader.GetEnumerator().) |
![]() | GetFieldType |
Gets the data type of the specified column.
(Overrides DbDataReader.GetFieldType(Int32).) |
![]() | GetFieldValue<T> | Synchronously gets the value of the specified column as a type. (Inherited from DbDataReader.) |
![]() | GetFieldValueAsync<T>(Int32) | Asynchronously gets the value of the specified column as a type. (Inherited from DbDataReader.) |
![]() | GetFieldValueAsync<T>(Int32, CancellationToken) | Asynchronously gets the value of the specified column as a type. (Inherited from DbDataReader.) |
![]() | GetFloat(Int32) |
Gets the value of the specified column as a single-precision floating point number.
(Overrides DbDataReader.GetFloat(Int32).) |
![]() | GetFloat(String) |
Gets the value of the specified column as a single-precision floating point number.
|
![]() | GetGuid |
Gets the value of the specified column as a globally-unique identifier (GUID).
(Overrides DbDataReader.GetGuid(Int32).) |
![]() | GetHashCode | Serves as the default hash function. (Inherited from Object.) |
![]() | GetInt16(Int32) |
Gets the value of the specified column as a 16-bit signed integer.
(Overrides DbDataReader.GetInt16(Int32).) |
![]() | GetInt16(String) |
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.
(Overrides DbDataReader.GetInt32(Int32).) |
![]() | GetInt32(String) |
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.
(Overrides DbDataReader.GetInt64(Int32).) |
![]() | GetInt64(String) |
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.) |
![]() | GetMvaValues(Int32) |
Gets the values of a multi value attribute.
|
![]() | GetMvaValues(String) |
Gets the values of a multi value attribute.
|
![]() | GetName |
Gets the name of the column, given the zero-based column ordinal.
(Overrides DbDataReader.GetName(Int32).) |
![]() | GetOrdinal |
Gets the column ordinal given the name of the column. This method
is case insensitive.
(Overrides DbDataReader.GetOrdinal(String).) |
![]() | GetProviderSpecificFieldType | Returns the provider-specific field type of the specified column. (Inherited from DbDataReader.) |
![]() | GetProviderSpecificValue | Gets the value of the specified column as an instance of Object. (Inherited from DbDataReader.) |
![]() | GetProviderSpecificValues | Gets all provider-specific attribute columns in the collection for the current row. (Inherited from DbDataReader.) |
![]() | GetSchemaTable |
Returns a DataTable that describes the column metadata of the SphinxQLDataReader.
(Overrides DbDataReader.GetSchemaTable().) |
![]() | GetSphinxTimestamp(Int32) |
Gets the value of the specified column as a SphinxTimestamp.
|
![]() | GetSphinxTimestamp(String) |
Gets the value of the specified column as a SphinxTimestamp.
|
![]() | GetStream | Retrieves data as a Stream. (Inherited from DbDataReader.) |
![]() | GetString(Int32) |
Gets the value of the specified column as an instance of String.
(Overrides DbDataReader.GetString(Int32).) |
![]() | GetString(String) |
Gets the value of the specified column as an instance of String.
|
![]() | GetTextReader | Retrieves data as a TextReader. (Inherited from DbDataReader.) |
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | GetUInt32(Int32) |
Gets the value of the specified column as a 32-bit unsigned integer.
|
![]() | GetUInt32(String) |
Gets the value of the specified column as a 32-bit unsigned integer.
|
![]() | GetUInt64(Int32) |
Gets the value of the specified column as a 64-bit unsigned integer.
|
![]() | GetUInt64(String) |
Gets the value of the specified column as a 64-bit unsigned integer.
|
![]() | GetValue(Int32) |
Gets the value of the specified column as an instance of Object.
(Overrides DbDataReader.GetValue(Int32).) |
![]() | GetValue(String) |
Gets the value of the specified column as an instance of Object.
|
![]() | GetValues |
Gets all attribute columns in the collection for the current row.
(Overrides DbDataReader.GetValues(Object[]).) |
![]() | InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
![]() | IsDBNull(Int32) |
Gets a value that indicates whether the column contains nonexistent or missing values.
(Overrides DbDataReader.IsDBNull(Int32).) |
![]() | IsDBNull(String) |
Gets a value that indicates whether the column contains nonexistent or missing values.
|
![]() | IsDBNullAsync(Int32) | An asynchronous version of IsDBNull(Int32), which gets a value that indicates whether the column contains non-existent or missing values. (Inherited from DbDataReader.) |
![]() | IsDBNullAsync(Int32, CancellationToken) | An asynchronous version of IsDBNull(Int32), which gets a value that indicates whether the column contains non-existent or missing values. Optionally, sends a notification that operations should be cancelled. (Inherited from DbDataReader.) |
![]() ![]() | NextResult |
Asynchronously advances the reader to the next result when reading the results of multiple queries.
(Overrides DbDataReader.NextResult().) |
![]() | 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(CancellationToken) with CancellationToken.None. (Inherited from DbDataReader.) |
![]() ![]() | NextResultAsync(CancellationToken) |
Asynchronously advances the reader to the next result when reading the results of multiple queries.
(Overrides DbDataReader.NextResultAsync(CancellationToken).) |
![]() | Read |
Advances the reader to the next record in a result set.
(Overrides DbDataReader.Read().) |
![]() | ReadAsync() | An asynchronous version of Read(), which advances the reader to the next record in a result set. This method invokes ReadAsync(CancellationToken) with CancellationToken.None. (Inherited from DbDataReader.) |
![]() | ReadAsync(CancellationToken) |
Asynchronously advances the reader to the next record in a result set.
(Overrides DbDataReader.ReadAsync(CancellationToken).) |
![]() | ToString | Returns a string that represents the current object. (Inherited from Object.) |
Name | Description | |
---|---|---|
![]() ![]() | IDataRecord.GetData | For a description of this member, see GetData(Int32). (Inherited from DbDataReader.) |
using (SphinxQLConnection sphinxQLConnection = new SphinxQLConnection("Data Source = localhost;Port=9306")) { SphinxQLCommand sphinxQLCommand = new SphinxQLCommand("SELECT * from sakila;", sphinxQLConnection); sphinxQLConnection.Open(); using (SphinxQLDataReader sphinxQLDataReader = sphinxQLCommand.ExecuteReader()) { while (sphinxQLDataReader.Read()) { Console.WriteLine(sphinxQLDataReader.GetInt32("id")); } } }