![]() | SphinxQLDataReader Class |
Namespace: SphinxConnector.SphinxQL
The SphinxQLDataReader type exposes the following members.
Name | Description | |
---|---|---|
![]() | Close |
Closes the SphinxQLDataReader object.
(Overrides DbDataReaderClose.) |
![]() | 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.) |
![]() | Equals | (Inherited from Object.) |
![]() | GetBoolean(Int32) |
Gets the value of the specified column as a Boolean.
(Overrides DbDataReaderGetBoolean(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 DbDataReaderGetByte(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 DbDataReaderGetBytes(Int32, Int64, Byte, Int32, Int32).) |
![]() | GetChar(Int32) |
Gets the value of the specified column as a single character.
(Overrides DbDataReaderGetChar(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 DbDataReaderGetChars(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 DbDataReaderGetDataTypeName(Int32).) |
![]() | GetDateTime(Int32) |
Gets the value of the specified column as a DateTime object.
(Overrides DbDataReaderGetDateTime(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 DbDataReaderGetDecimal(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 DbDataReaderGetDouble(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 DbDataReaderGetEnumerator.) |
![]() | GetFieldType |
Gets the data type of the specified column.
(Overrides DbDataReaderGetFieldType(Int32).) |
![]() | GetFloat(Int32) |
Gets the value of the specified column as a single-precision floating point number.
(Overrides DbDataReaderGetFloat(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 DbDataReaderGetGuid(Int32).) |
![]() | GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
![]() | GetInt16(Int32) |
Gets the value of the specified column as a 16-bit signed integer.
(Overrides DbDataReaderGetInt16(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 DbDataReaderGetInt32(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 DbDataReaderGetInt64(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 DbDataReaderGetName(Int32).) |
![]() | GetOrdinal |
Gets the column ordinal given the name of the column. This method
is case insensitive.
(Overrides DbDataReaderGetOrdinal(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 DbDataReaderGetSchemaTable.) |
![]() | GetSphinxTimestamp(Int32) |
Gets the value of the specified column as a SphinxTimestamp.
|
![]() | GetSphinxTimestamp(String) |
Gets the value of the specified column as a SphinxTimestamp.
|
![]() | GetString(Int32) |
Gets the value of the specified column as an instance of String.
(Overrides DbDataReaderGetString(Int32).) |
![]() | GetString(String) |
Gets the value of the specified column as an instance of String.
|
![]() | 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 DbDataReaderGetValue(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 DbDataReaderGetValues(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 DbDataReaderIsDBNull(Int32).) |
![]() | IsDBNull(String) |
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 multiple queries.
(Overrides DbDataReaderNextResult.) |
![]() | Read |
Advances the reader to the next record in a result set.
(Overrides DbDataReaderRead.) |
![]() | ToString | Returns a string that represents the current object. (Inherited from Object.) |
Name | Description | |
---|---|---|
![]() | Depth |
Gets a value indicating the depth of nesting for the current row. Always returns 0.
(Overrides DbDataReaderDepth.) |
![]() | FieldCount |
Gets the number of columns in the current row.
(Overrides DbDataReaderFieldCount.) |
![]() | HasRows |
Gets a value that indicates whether this SphinxQLDataReader contains one or more rows.
(Overrides DbDataReaderHasRows.) |
![]() | IsClosed |
Gets a value indicating whether the SphinxQLDataReader is closed.
(Overrides DbDataReaderIsClosed.) |
![]() | ItemInt32 |
Gets the Object with the specified ordinal.
(Overrides DbDataReaderItemInt32.) |
![]() | ItemString |
Gets the Object with the specified name.
(Overrides DbDataReaderItemString.) |
![]() | RecordsAffected |
Gets the number of rows changed, inserted, or deleted by execution of the SphinxQL statement.
(Overrides DbDataReaderRecordsAffected.) |
![]() | VisibleFieldCount | Gets the number of fields in the DbDataReader that are not hidden. (Inherited from DbDataReader.) |
Name | Description | |
---|---|---|
![]() ![]() | IDataRecordGetData | 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")); } } }