Reads a forward-only stream of rows from Sphinx. This class cannot be inherited.
Namespace: Gronewold.SphinxConnector.SphinxQLAssembly: Gronewold.SphinxConnector (in Gronewold.SphinxConnector.dll) Version: 2.7.0.3011 (2.7.0.3011)
Syntax
| C# |
|---|
public sealed class SphinxQLDataReader : DbDataReader |
| Visual Basic |
|---|
Public NotInheritable Class SphinxQLDataReader _ Inherits DbDataReader |
Examples
The following example shows how to read data from Sphinx with the SphinxQLDataReader class.
CopyC#
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)); } } }
Inheritance Hierarchy
System..::..Object
System..::..MarshalByRefObject
System.Data.Common..::..DbDataReader
Gronewold.SphinxConnector.SphinxQL..::..SphinxQLDataReader
System..::..MarshalByRefObject
System.Data.Common..::..DbDataReader
Gronewold.SphinxConnector.SphinxQL..::..SphinxQLDataReader
Thread Safety
Static members of this type are safe for multi-threaded operations. Instance members of this type are not safe for multi-threaded operations.