The methods of the SqlServerDynamicQuery class are listed below. For a complete list of SqlServerDynamicQuery class members, see the SqlServerDynamicQuery 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 | 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 | 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 | 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 | Builds a provider-specific DELETE query against the TableName. |
| BuildInsertQuery | Builds a provider-specific INSERT query against the TableName. |
| BuildSelectQuery | Builds a provider-specific SELECT query against the QuerySource. |
| BuildUpdateQuery | Builds a provider-specific UPDATE query against the TableName. |
| BuildWhereClause | Construct the correct WHERE clause using the Transact-SQL syntax (generic SQL Server) |
| 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 | Builds the provider-specific aggregate portion of the query |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |
See Also
SqlServerDynamicQuery Class | NCI.EasyObjects.DynamicQueryProvider Namespace