EasyObjects.NET Programmers Reference

DynamicQuery Members

DynamicQuery overview

Public Instance Constructors

DynamicQuery Overloaded. Initializes a new instance of the DynamicQuery class.

Public Instance Properties

ConfigurationName (inherited from Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationProvider) 
CountAll If true, add a COUNT(*) Aggregate to the selected columns list.
Note   This may not be support for all database providers
CountAllAlias If CountAll is set to true, use this to add a user-friendly column name.
Note   This may not be support for all database providers
Distinct Adds the DISTINCT modifier to the SELECT clause
Note   This may not be support for all database providers
Entity An internal callback reference to the EasyObject. There is no need to use this externally.
LastQuery Contains the Query string from your last call to Query.Load(), this is useful for debugging purposes.
TopN Adds the TOPN modifier to the SELECT clause
Note   This may not be support for all database providers
WithRollup If true, add WITH ROLLUP to the GROUP BY clause.
Note   This may not be support for all database providers

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.
AddGroupByOverloaded. 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.
AddInsertColumnOverloaded. 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.
AddOrderByOverloaded. 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.
AddOrderByFormatOverloaded. Adds an ORDER BY clause to the query. The field is formatted using the FieldFormat.
AddResultColumnOverloaded. 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
GetDeleteCommandWrapperOverloaded. 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.
GetInsertCommandWrapperOverloaded. Builds the inline SQL command for an INSERT
GetType (inherited from Object) Gets the Type of the current instance.
GetUpdateCommandWrapperOverloaded. Builds the inline SQL command for a UPDATE
Initialize Initializes a new instance of the DynamicQuery class with the specified DatabaseTypeData and DynamicQueryConfigurationView.
InsertOverloaded. Execute the INSERT query. The default conjunction between the WHERE parameters is "AND".
InsertValuesClear Calling this will clear all values from the UPDATE statement.
LoadOverloaded. 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.
UpdateOverloaded. 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 Fields

_aggregateParameters Used by derived classes
_countAll Used by derived classes
_countAllAlias Used by derived classes
_distinct Used by derived classes
_entity Used by derived classes
_groupBy Used by derived classes
_insertColumns Used by derived classes
_insertColumnValues Used by derived classes
_insertParameters Used by derived classes
_orderBy Used by derived classes
_parameterValues Used by derived classes
_resultColumns Used by derived classes
_topN Used by derived classes
_updateColumns Used by derived classes
_whereParameters Used by derived classes
_withRollup Used by derived classes

Protected Instance Properties

AliasFormat When implemented by a class, gets the string format used to delimit aliases for the database.
DynamicQueryProviderData Gets the DatabaseTypeData from which this object was initialized.
FieldFormat When implemented by a class, gets the string format used to delimit fieldnames for the database.
InsertColumns Returns the current database columns in the INSERT clause
InsertColumnValues Returns the current database columns in the INSERT clause
OrderBy Returns the current database columns in the ORDER BY clause
ParameterToken When implemented by a class, gets the parameter token used to delimit parameters for the database.
ParameterValues Returns the current values for the WHERE clause
QuerySourceWithSchema Gets the complete querysource name (including schema) properly formatted for the current SQL dialect.
ResultColumns Returns the current database columns in the SELECT clause
SchemaSeparator When implemented by a class, gets the string used to separate schemas from objects for the database.
TableNameWithSchema Gets the complete table name (including schema) properly formatted for the current SQL dialect.
UpdateColumns Returns the current database columns in the UPDATE clause

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