Represents a set of data commands and a connection that are used to fill a DataSet. This class cannot be inherited.

Namespace: Gronewold.SphinxConnector.SphinxQL
Assembly: Gronewold.SphinxConnector (in Gronewold.SphinxConnector.dll) Version: 2.7.0.3011 (2.7.0.3011)

Syntax

C#
public sealed class SphinxQLDataAdapter : DbDataAdapter, 
	IDbDataAdapter, IDataAdapter
Visual Basic
Public NotInheritable Class SphinxQLDataAdapter _
	Inherits DbDataAdapter _
	Implements IDbDataAdapter, IDataAdapter

Examples

This example shows how to populate a DataTable object with data from an index with the help of the SphinxQLDataAdapter class.
CopyC#
SphinxQLDataAdapter dataAdapter = new SphinxQLDataAdapter();

using (var sphinxQLConnection = new SphinxQLConnection("Data Source=localhost;Port=9306"))
{
    var sphinxQLCommand = new SphinxQLCommand("SELECT * from sakila;", sphinxQLConnection);

    sphinxQLConnection.Open();

    dataAdapter.SelectCommand = sphinxQLCommand;

    DataTable dataTable = new DataTable();

    dataAdapter.Fill(dataTable);
    dataAdapter.Dispose();
}

Inheritance Hierarchy

System..::..Object
  System..::..MarshalByRefObject
    System.ComponentModel..::..Component
      System.Data.Common..::..DataAdapter
        System.Data.Common..::..DbDataAdapter
          Gronewold.SphinxConnector.SphinxQL..::..SphinxQLDataAdapter

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.

See Also