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