Classes that implement IWhereConstraint are sub-command builders used by the MultiTableDataAdapter.
For a list of all members of this type, see IWhereConstraint Members.
| Type | Description |
|---|---|
| ArbitraryWhereConstraint | Generates a search condition that compares the value in the column against the given predicate. |
| WhereConstraintBase | Provides a helpful base implementation for types that implement IWhereConstraint. |
| WhereConstraintCollection | A collection of IWhereConstraint objects to be joined by logical operators in the WHERE clause of a generated command. |
| InSubqueryWhereConstraint | Generates a search condition that compares the value in a column to the results of a subquery. |
| JoinWhereConstraint | Generates a search condition that compares the value in a column to the value in another column. |
| MaxValueWhereConstraint | Generates a search condition that compares the contents of a column to the maximum value of the same column in the same table. |
| ParameterWhereConstraint | Generates a search condition that compares the contents of a column to the value of a parameter. |
| RelatedRowWhereConstraint | Generates a search condition that limits query results to those rows that are related to the specified row. |
| RelatedTableWhereConstraint | Specifies that a table should appear in a generated SQL command. |
| RelationWhereConstraint | Generates a search condition that joins two tables using the properties of a DataRelation. |
| ValueWhereConstraint | Generates a search condition that compares the contents of a column to a constant value. |
Classes that implement the IWhereConstraint interface are used by the MultiTableDataAdapter to limit the rows that are returned from Fill operations. The DataSetToolkit provides several classes that implement the IWhereConstraint interface. Most search conditions can be created with a combination of ValueWhereConstraint, JoinWhereConstraint and WhereConstraintCollection objects.
Interface implementers are expected to generate ANSI SQL compliant commands.
Namespace: Hydrus.DataSetToolkit
Assembly: DataSetToolkit (in DataSetToolkit.dll)
IWhereConstraint Members | Hydrus.DataSetToolkit Namespace