EasyObjects.NET Programmers Reference

SqlServerDynamicQuery Properties

The properties of the SqlServerDynamicQuery class are listed below. For a complete list of SqlServerDynamicQuery class members, see the SqlServerDynamicQuery Members topic.

Public Instance Properties

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

Protected Instance Properties

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

See Also

SqlServerDynamicQuery Class | NCI.EasyObjects.DynamicQueryProvider Namespace