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(); }