IfxDataAdapter public properties

The following table shows the public properties of the IfxDataAdapter class.

Table 1. IfxDataAdapter public properties
Property Description
AcceptChangedDuringFill Gets or sets a value indicating if AcceptChanges is called on a DataRow after it is added to the DataTable during any of the Fill operations.
AcceptChangesDuringUpdate Gets or sets whether AcceptChanges is called during an Update.
DeleteCommand Gets or sets an SQL statement for deleting records from the database.
FillLoadOption Gets or sets the LoadOption that determines how the adapter fills the DataTable from the DbDataReader.
InsertCommand Gets or sets an SQL statement used to insert new records into the database.
MissingMappingAction The action to be taken when incoming data does not have matching table or column data sets. Indicates or specifies whether unmapped source tables or columns are passed with their source names so that they can be filtered or to raise an error. The MissingMappingAction property can have any of the values from the MissingMappingAction enumeration, described after the table.
MissingSchemaAction Indicates or specifies whether missing source tables, columns, and their relationships are added to the data set schema, ignored, or cause an error to be returned. The MissingSchemaAction property can have any of the MissingSchemaAction enumeration values described after the table.
ReturnProviderSpecifictypes Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values.
SelectCommand Gets or sets an SQL statement used to select records in the database.
TableMappings Indicates how a source table is mapped to a data set table. The default table name of a DataTable is Table. The default DataTableMapping that uses the default DataTable name is also Table.
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.
UpdateCommand Gets or sets an SQL statement used to update records in the database.
The MissingMappingAction property can have the following values:
  • Error—A SystemException is generated.
  • Ignore—A column or table without a mapping is ignored.
  • Passthrough—The source column and table are created if they do not already exist and they are added to the DataSet. This is the default value.
The MissingSchemaAction property can have the following values:
  • Add—Adds any columns necessary to complete the schema.
  • AddWithKey—Adds the necessary columns and primary key information to complete the schema. By default, primary keys are not created in the DataSet unless this property is specified. Setting this value ensures that incoming records that match existing records are updated instead of getting appended, which could potentially result in multiple copies of the same row.
  • Error—A SystemException is generated.
  • Ignore—Ignores the extra columns.