DomainObjects Class Library

ScalarQuery Members

ScalarQuery overview

Public Instance Properties

CommandTimeout Gets or sets the wait time before terminating the attempt to execute a SQL statement and generating an error.
Distinct Gets or sets a value indicating whether only unique rows can appear in the result set. Null values are considered equal for the purposes of the DISTINCT keyword.
ExplicitSelectFields Gets the select fields.
FieldDescriptor (inherited from Field) Gets or sets the field descriptor.
Having The criteria that will be converted to the HAVING clause of the SQL select statement.
IsTopSpecified Gets a value indicating whether top is specified.
SelectDistinct Determine if duplicate rows will be removed when this object is queried from the database.
TargetClassOverloaded. Gets the class being targeted by this query.
TargetTableMappedObject Gets the target table mapped object.
Top Gets or sets the number of rows that will be returned from the query result set.
UnionedQueries 
Value (inherited from Field) Get an object that represents the run time value. Useful for building Criteria.
Where Gets or sets the criteria that will be converted to the WHERE clause of the SQL select statement. The getter will always return a non-null value.

Public Instance Methods

Accept Accepts a visitation.
AddDate (inherited from Field)Overloaded. Returns a new DateTime based upon adding the specified interval to this date.
AppendSql Appends the SQL.
As (inherited from Field)Overloaded. Sets the alias to be used as the expression name.
Average (inherited from Field)Overloaded. Returns the average of all values in a group including duplicate values. Translates to a AVG(field) SQL function.
BuildObjectGraphQuery Builds the object graph query.
Count (inherited from Field)Overloaded. Returns the total number of rows from a table, including duplicates, where this field evaluates to a non-null value. Translates to a COUNT(field) SQL function.
DatePart (inherited from Field) Returns a string representing a datepart of a date.
Equals (inherited from Object)Determines whether the specified Object is equal to the current Object.
GetClassesToRetrieve Builds the classes to retrieve.
GetFullTableName Get the fully qualified name of the table to which this object maps.
GetHashCode (inherited from Object)Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table.
GetImmediateChildExpressions Gets the child object model expressions that are directly contained by this expression.
GetInsertableFields Get the set of insertable Fields to which this object, and any of its sub-types, maps. This is the set of ColumnFields that are populated by the middle tier when a row is inserted into the database.
GetKey (inherited from Field) Get a string representation of the hashcode that uniquely identifies this field instance. This field becomes cached in one of two caches when GetKey is called: 1. If the current thread is executing within an HTTP context, i.e., a web application, then the field is stored in the current HttpSessionState. 2. If the current thread is not executing within an HTTP context, then the field is stored in DomainObject's AppDomain cache. This field can then be retrieved later via a call to GetField. You might want to use the field key as the value of a drop down list in a web page and then retrieve the actual field from the cache when the page is posted back to the server. See a usage example at FieldCaching().
GetNaturalIdentifier Get a string that identifies this field to a person familiar with the object model. Used when an instance of this field is part of a logging or assertion statement.
GetParentTableMappedObject (inherited from Field) The object that contains this field. For example, the class that contains this member field.
GetRootTableMappedObject Returns the root table mapped object in this query path; i.e., the starting point of this join path.
GetSelectableFields Get the set of selectable Fields to which this object, and any of its sub-types, maps.
GetType (inherited from Object)Gets the Type of the current instance.
GetUpdatableFields Get the set of updatable ColumnFields to which this object, and any of its sub-types, maps. This list would exclude, for example, any primary key columns.
HasAnyComputedPrimaryKeyColumns Determines whether this table mapped object has any computed primary key columns.
IsCount Determines whether this instance represents a SQL COUNT statement.
Lower (inherited from Field) Returns the lower case string of this field's values. Translates to a LOWER(field) SQL function.
Max (inherited from Field) Returns the maximum value of the field. Null values are ignored. Translates to a MAX(field) SQL function.
Min (inherited from Field) Returns the minimum value of the field. Null values are ignored. Translates to a MIN(field) SQL function.
Replace (inherited from Field) Replaces all occurrences of substringToFind in the string value of this field with replacementString. Translates to a REPLACE(fieldToSearch, substringToFind, replacementString) SQL function.
ReplaceNull (inherited from Field) Replaces a NULL value for this field with the specified replacement value.
Sum (inherited from Field)Overloaded. Returns the sum of this field's values. Null values are ignored. Translates to a SUM(field) SQL function.
ToString (inherited from Object)Returns a String that represents the current Object.
Upper (inherited from Field) Returns the upper case string of this field's values. Translates to a UPPER(field) SQL function.

See Also

ScalarQuery Class | DomainObjects.Facade.Command Namespace