The methods of the Sql2005DynamicQuery class are listed below. For a complete list of Sql2005DynamicQuery class members, see the Sql2005DynamicQuery Members topic.
Public Instance Methods
 AddAggregateParameter (inherited from DynamicQuery) | Adds the AggregateParameter to the internal ArrayList. |
| AddConjunction (inherited from DynamicQuery) | A Query has a default conjunction between WHERE parameters, this method lets you intermix those and alternate between AND/OR. |
| AddGroupBy (inherited from SqlServerDynamicQuery) | Overloaded. Adds a GROUP BY parameter to the query |
| AddGroupBy (inherited from DynamicQuery) | 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 (inherited from DynamicQuery) | Adds a GROUP BY clause to the query using the FieldName. The field is formatted using the current data provider's FieldFormat. |
| AddInsertColumn (inherited from DynamicQuery) | Overloaded. Adds a column and column value parameter to the INSERT query |
| AddInsertColumnWithValue (inherited from DynamicQuery) | 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 (inherited from SqlServerDynamicQuery) | Overloaded. Adds an aggregate parameter to the ORDER BY clause of the query |
| AddOrderBy (inherited from DynamicQuery) | 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 (inherited from DynamicQuery) | Overloaded. Adds an ORDER BY clause to the query. The field is formatted using the FieldFormat. |
| AddResultColumn (inherited from SqlServerDynamicQuery) | Overloaded. Adds a field to the SELECT clause of the query |
| AddResultColumn (inherited from DynamicQuery) | 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 (inherited from DynamicQuery) | Adds a provider-specific formatted column name to the SELECT statement |
| AddUpdateColumn (inherited from DynamicQuery) | 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 (inherited from DynamicQuery) | 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 (inherited from DynamicQuery) | Adds the WhereParameter to the internal ArrayList. |
| ClearAll (inherited from DynamicQuery) | Clears all the result columns and parameters from the current instance |
| CloseParenthesis (inherited from DynamicQuery) | Used for advanced queries |
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| FlushAggregateParameters (inherited from DynamicQuery) | Clears the internal ArrayList of AggregateParameters |
| FlushWhereParameters (inherited from DynamicQuery) | Clears the internal ArrayList of WhereParameters |
| GetDeleteCommandWrapper (inherited from DynamicQuery) | 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 (inherited from DynamicQuery) | Overloaded. Builds the inline SQL command for an INSERT |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| GetUpdateCommandWrapper (inherited from DynamicQuery) | Overloaded. Builds the inline SQL command for a UPDATE |
| Initialize (inherited from DynamicQuery) | Initializes a new instance of the DynamicQuery class with the specified DatabaseTypeData and DynamicQueryConfigurationView. |
| Insert (inherited from DynamicQuery) | Overloaded. Execute the INSERT query. The default conjunction between the WHERE parameters is "AND". |
| InsertValuesClear (inherited from DynamicQuery) | Calling this will clear all values from the UPDATE statement. |
| Load (inherited from DynamicQuery) | Overloaded. Execute the Query and loads your BusinessEntity. The default conjunction between the WHERE parameters is "AND" |
| OpenParenthesis (inherited from DynamicQuery) | Used for advanced queries |
| ResultColumnsClear (inherited from DynamicQuery) | Calling this will set the result columns back to "all". |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
| Update (inherited from DynamicQuery) | Overloaded. Execute the Update query. The default conjunction between the WHERE parameters is "AND". |
| UpdateValuesClear (inherited from DynamicQuery) | Calling this will clear all values from the UPDATE statement. |
Protected Instance Methods
 BuildDeleteQuery (inherited from SqlServerDynamicQuery) | Builds a provider-specific DELETE query against the TableName. |
| BuildInsertQuery (inherited from SqlServerDynamicQuery) | Builds a provider-specific INSERT query against the TableName. |
| BuildSelectQuery (inherited from SqlServerDynamicQuery) | Builds a provider-specific SELECT query against the QuerySource. |
| BuildUpdateQuery (inherited from SqlServerDynamicQuery) | Builds a provider-specific UPDATE query against the TableName. |
| BuildWhereClause | Construct the correct WHERE clause using the Transact-SQL syntax (SQL Server 2005) |
| 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. |
| GetAggregate (inherited from SqlServerDynamicQuery) | Builds the provider-specific aggregate portion of the query |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |
See Also
Sql2005DynamicQuery Class | NCI.EasyObjects.DynamicQueryProvider Namespace