| SphinxQLDataAdapter Class |
Namespace: SphinxConnector.SphinxQL
The SphinxQLDataAdapter type exposes the following members.
| Name | Description | |
|---|---|---|
| SphinxQLDataAdapter |
Initializes a new instance of the SphinxQLDataAdapter class.
| |
| SphinxQLDataAdapter(String, SphinxQLConnection) |
Initializes a new instance of the SphinxQLDataAdapter class.
|
| Name | Description | |
|---|---|---|
| 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 Component. (Inherited from Component.) | |
| Equals | (Inherited from Object.) | |
| Fill(DataSet) | Adds or refreshes rows in the DataSet. (Inherited from DbDataAdapter.) | |
| Fill(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.) | |
| Fill(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.) | |
| Fill(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.) | |
| Fill(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.) | |
| FillSchema(DataTable, SchemaType) | Configures the schema of the specified DataTable based on the specified SchemaType. (Inherited from DbDataAdapter.) | |
| FillSchema(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.) | |
| FillSchema(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.) | |
| GetFillParameters | Gets the parameters set by the user when executing an SQL SELECT statement. (Inherited from DbDataAdapter.) | |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) | |
| GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.) | |
| GetType | Gets the Type of the current instance. (Inherited from Object.) | |
| InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.) | |
| ResetFillLoadOption | Resets FillLoadOption to its default state and causes Fill(DataSet) to honor AcceptChangesDuringFill. (Inherited from DataAdapter.) | |
| ShouldSerializeAcceptChangesDuringFill | Determines whether the AcceptChangesDuringFill property should be persisted. (Inherited from DataAdapter.) | |
| ShouldSerializeFillLoadOption | Determines whether the FillLoadOption property should be persisted. (Inherited from DataAdapter.) | |
| ToString | Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.) | |
| Update(DataSet) | Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataSet. (Inherited from DbDataAdapter.) | |
| Update(DataRow) | Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array of DataRow objects. (Inherited from DbDataAdapter.) | |
| Update(DataTable) | Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataTable. (Inherited from DbDataAdapter.) | |
| Update(DataSet, String) | Calls 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.) |
| Name | Description | |
|---|---|---|
| AcceptChangesDuringFill | 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.) | |
| AcceptChangesDuringUpdate | Gets or sets whether AcceptChanges is called during a Update(DataSet). (Inherited from DataAdapter.) | |
| Container | Gets the IContainer that contains the Component. (Inherited from Component.) | |
| ContinueUpdateOnError | Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update. (Inherited from DataAdapter.) | |
| DeleteCommand |
Gets or sets a command for deleting records from the data set.
| |
| FillLoadOption | Gets or sets the LoadOption that determines how the adapter fills the DataTable from the DbDataReader. (Inherited from DataAdapter.) | |
| InsertCommand |
Gets or sets a command used to insert new records into the data source.
| |
| MissingMappingAction | Determines the action to take when incoming data does not have a matching table or column. (Inherited from DataAdapter.) | |
| MissingSchemaAction | Determines the action to take when existing DataSet schema does not match incoming data. (Inherited from DataAdapter.) | |
| ReturnProviderSpecificTypes | Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values. (Inherited from DataAdapter.) | |
| SelectCommand |
Gets or sets a command used to select records in the data source.
| |
| Site | (Inherited from Component.) | |
| TableMappings | Gets a collection that provides the master mapping between a source table and a DataTable. (Inherited from DataAdapter.) | |
| UpdateBatchSize | 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.) | |
| UpdateCommand |
Gets or sets a command used to update records in the data source.
|
| Name | Description | |
|---|---|---|
| Disposed | Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.) | |
| FillError | Returned when an error occurs during a fill operation. (Inherited from DataAdapter.) | |
| RowUpdated |
Occurs during update after a command is executed against the data source.
| |
| RowUpdating |
Occurs during update before a command is executed against the data source.
|
| Name | Description | |
|---|---|---|
| IDbDataAdapterDeleteCommand |
Gets or sets a command for deleting records from the data set.
| |
| IDbDataAdapterInsertCommand |
Gets or sets a command used to insert new records into the data source.
| |
| IDbDataAdapterSelectCommand |
Gets or sets a command used to select records in the data source.
| |
| IDbDataAdapterUpdateCommand |
Gets or sets a command used to update records in the data source.
| |
| ICloneableClone | Creates a new object that is a copy of the current instance. (Inherited from DbDataAdapter.) | |
| IDataAdapterTableMappings | Indicates how a source table is mapped to a dataset table. (Inherited from DataAdapter.) |
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(); }