The methods of the DynamicQuery class are listed below. For a complete list of DynamicQuery class members, see the DynamicQuery Members topic.
Public Instance Methods
 AddAggregateParameter | Adds the AggregateParameter to the internal ArrayList. |
| AddConjunction | A Query has a default conjunction between WHERE parameters, this method lets you intermix those and alternate between AND/OR. |
| AddGroupBy | Overloaded. Adds a GROUP BY clause to the query. If you want to order the data by two columns you will need to call this method twice. If you call AddGroupBy, ANSI SQL requires an AddGroupBy for each AddResultColumn that is not an aggregate. Check your DBMS docs. |
| AddGroupByFormat | Adds a GROUP BY clause to the query using the FieldName. The field is formatted using the current data provider's FieldFormat. |
| AddInsertColumn | Overloaded. Adds a column and column value parameter to the INSERT query |
| AddInsertColumnWithValue | The default result set for Query.Load is all of the columns in your Table or View. Once you call AddResultColumn this changes to only the columns you have added via this method. For instance, if you call AddResultColumn twice then only two columns will be returned in your result set. |
| AddOrderBy | Overloaded. Adds an ORDER BY clause to the query. If you want to order the data by two columns you will need to call this method twice. |
| AddOrderByFormat | Overloaded. Adds an ORDER BY clause to the query. The field is formatted using the FieldFormat. |
| AddResultColumn | Overloaded. The default result set for Query.Load is all of the columns in your Table or View. Once you call AddResultColumn this changes to only the columns you have added via this method. For instance, if you call AddResultColumn twice then only two columns will be returned in your result set. |
| AddResultColumnFormat | Adds a provider-specific formatted column name to the SELECT statement |
| AddUpdateColumn | The default result set for Query.Load is all of the columns in your Table or View. Once you call AddResultColumn this changes to only the columns you have added via this method. For instance, if you call AddResultColumn twice then only two columns will be returned in your result set. |
| AddUpdateColumnWithValue | The default result set for Query.Load is all of the columns in your Table or View. Once you call AddResultColumn this changes to only the columns you have added via this method. For instance, if you call AddResultColumn twice then only two columns will be returned in your result set. |
| AddWhereParameter | Adds the WhereParameter to the internal ArrayList. |
| ClearAll | Clears all the result columns and parameters from the current instance |
| CloseParenthesis | Used for advanced queries |
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| FlushAggregateParameters | Clears the internal ArrayList of AggregateParameters |
| FlushWhereParameters | Clears the internal ArrayList of WhereParameters |
| GetDeleteCommandWrapper | Overloaded. Builds the inline SQL command for a DELETE |
| GetHashCode (inherited from Object) | Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table. |
| GetInsertCommandWrapper | Overloaded. Builds the inline SQL command for an INSERT |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| GetUpdateCommandWrapper | Overloaded. Builds the inline SQL command for a UPDATE |
| Initialize | Initializes a new instance of the DynamicQuery class with the specified DatabaseTypeData and DynamicQueryConfigurationView. |
| Insert | Overloaded. Execute the INSERT query. The default conjunction between the WHERE parameters is "AND". |
| InsertValuesClear | Calling this will clear all values from the UPDATE statement. |
| Load | Overloaded. Execute the Query and loads your BusinessEntity. The default conjunction between the WHERE parameters is "AND" |
| OpenParenthesis | Used for advanced queries |
| ResultColumnsClear | Calling this will set the result columns back to "all". |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
| Update | Overloaded. Execute the Update query. The default conjunction between the WHERE parameters is "AND". |
| UpdateValuesClear | Calling this will clear all values from the UPDATE statement. |
Protected Instance Methods
 BuildDeleteQuery | When implemented by a class, builds a provider-specific SQL DELETE query. |
| BuildInsertQuery | When implemented by a class, builds a provider-specific SQL INSERT query. |
| BuildSelectQuery | When implemented by a class, builds a provider-specific SQL SELECT query. |
| BuildUpdateQuery | When implemented by a class, builds a provider-specific SQL UPDATE query. |
| Finalize (inherited from Object) | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |
See Also
DynamicQuery Class | NCI.EasyObjects Namespace