DomainObjects Class Library

ScalarQuery Methods

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

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