Click or drag to resize

SphinxQLDataAdapter Class

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

Namespace:  SphinxConnector.SphinxQL
Assembly:  SphinxConnector (in SphinxConnector.dll) Version: 5.3.0
Syntax
public sealed class SphinxQLDataAdapter : DbDataAdapter, 
	IDbDataAdapter, IDataAdapter

The SphinxQLDataAdapter type exposes the following members.

Constructors
  NameDescription
Public methodSphinxQLDataAdapter
Initializes a new instance of the SphinxQLDataAdapter class.
Public methodSphinxQLDataAdapter(String, SphinxQLConnection)
Initializes a new instance of the SphinxQLDataAdapter class.
Top
Properties
  NameDescription
Public propertyAcceptChangesDuringFill
Gets or sets a value indicating whether AcceptChanges is called on a DataRow after it is added to the DataTable during any of the Fill operations.
(Inherited from DataAdapter.)
Public propertyAcceptChangesDuringUpdate (Inherited from DataAdapter.)
Public propertyContainer
Gets the IContainer that contains the Component.
(Inherited from Component.)
Public propertyContinueUpdateOnError
Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update.
(Inherited from DataAdapter.)
Public propertyDeleteCommand
Gets or sets a command for deleting records from the data set.
Public propertyFillLoadOption
Gets or sets the LoadOption that determines how the adapter fills the DataTable from the DbDataReader.
(Inherited from DataAdapter.)
Public propertyInsertCommand
Gets or sets a command used to insert new records into the data source.
Public propertyMissingMappingAction
Determines the action to take when incoming data does not have a matching table or column.
(Inherited from DataAdapter.)
Public propertyMissingSchemaAction
Determines the action to take when existing DataSet schema does not match incoming data.
(Inherited from DataAdapter.)
Public propertyReturnProviderSpecificTypes
Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values.
(Inherited from DataAdapter.)
Public propertySelectCommand
Gets or sets a command used to select records in the data source.
Public propertySite
Gets or sets the ISite of the Component.
(Inherited from Component.)
Public propertyTableMappings
Gets a collection that provides the master mapping between a source table and a DataTable.
(Inherited from DataAdapter.)
Public propertyUpdateBatchSize
Gets or sets a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.
(Inherited from DbDataAdapter.)
Public propertyUpdateCommand
Gets or sets a command used to update records in the data source.
Top
Methods
  NameDescription
Public methodCreateObjRef
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 methodDispose
Releases all resources used by the Component.
(Inherited from Component.)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodFill(DataSet)
Adds or refreshes rows in the DataSet.
(Inherited from DbDataAdapter.)
Public methodFill(DataTable)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataTable name.
(Inherited from DbDataAdapter.)
Public methodFill(DataSet, String)
Adds or refreshes rows in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DbDataAdapter.)
Public methodFill(Int32, Int32, DataTable)
Adds or refreshes rows in a DataTable to match those in the data source starting at the specified record and retrieving up to the specified maximum number of records.
(Inherited from DbDataAdapter.)
Public methodFill(DataSet, Int32, Int32, String)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DbDataAdapter.)
Public methodFillSchema(DataSet, SchemaType)
Adds a DataTable named "Table" to the specified DataSet and configures the schema to match that in the data source based on the specified SchemaType.
(Inherited from DbDataAdapter.)
Public methodFillSchema(DataTable, SchemaType)
Configures the schema of the specified DataTable based on the specified SchemaType.
(Inherited from DbDataAdapter.)
Public methodFillSchema(DataSet, SchemaType, String)
Adds a DataTable to the specified DataSet and configures the schema to match that in the data source based upon the specified SchemaType and DataTable.
(Inherited from DbDataAdapter.)
Public methodGetFillParameters
Gets the parameters set by the user when executing an SQL SELECT statement.
(Inherited from DbDataAdapter.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodInitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Public methodResetFillLoadOption
Resets FillLoadOption to its default state and causes Fill(DataSet) to honor AcceptChangesDuringFill.
(Inherited from DataAdapter.)
Public methodShouldSerializeAcceptChangesDuringFill
Determines whether the AcceptChangesDuringFill property should be persisted.
(Inherited from DataAdapter.)
Public methodShouldSerializeFillLoadOption
Determines whether the FillLoadOption property should be persisted.
(Inherited from DataAdapter.)
Public methodToString
Returns a String containing the name of the Component, if any. This method should not be overridden.
(Inherited from Component.)
Public methodUpdate(DataRow)
Updates the values in the database by executing the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array in the DataSet.
(Inherited from DbDataAdapter.)
Public methodUpdate(DataSet)
Updates the values in the database by executing the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataSet.
(Inherited from DbDataAdapter.)
Public methodUpdate(DataTable)
Updates the values in the database by executing the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataTable.
(Inherited from DbDataAdapter.)
Public methodUpdate(DataSet, String)
Updates the values in the database by executing the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet with the specified DataTable name.
(Inherited from DbDataAdapter.)
Top
Events
  NameDescription
Public eventDisposed
Occurs when the component is disposed by a call to the Dispose method.
(Inherited from Component.)
Public eventFillError
Returned when an error occurs during a fill operation.
(Inherited from DataAdapter.)
Public eventRowUpdated
Occurs during update after a command is executed against the data source.
Public eventRowUpdating
Occurs during update before a command is executed against the data source.
Top
Explicit Interface Implementations
  NameDescription
Explicit interface implementationPrivate methodICloneableClone
Creates a new object that is a copy of the current instance.
(Inherited from DbDataAdapter.)
Explicit interface implementationPrivate propertyIDbDataAdapterDeleteCommand
Gets or sets a command for deleting records from the data set.
Explicit interface implementationPrivate propertyIDbDataAdapterInsertCommand
Gets or sets a command used to insert new records into the data source.
Explicit interface implementationPrivate propertyIDbDataAdapterSelectCommand
Gets or sets a command used to select records in the data source.
Explicit interface implementationPrivate propertyIDbDataAdapterUpdateCommand
Gets or sets a command used to update records in the data source.
Explicit interface implementationPrivate propertyIDataAdapterTableMappings
Indicates how a source table is mapped to a dataset table.
(Inherited from DataAdapter.)
Top
Examples
This example shows how to populate a DataTable object with data from an index with the help of the SphinxQLDataAdapter class.
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();
}
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
See Also