DomainObjects Class Library

Case Methods

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

Public Instance Methods

Accept (inherited from Field) Accepts the specified visitor.
AddCaseOverloaded. Add a condition that will be evaluated in the case statement.
AddDate (inherited from Field)Overloaded. Returns a new DateTime based upon adding the specified interval to this date.
AddElseOverloaded. Add a field value to return if all conditions evaluate to false.
AppendSql (inherited from DomainObjects.DbAccess.Command.SqlStatement.Function.ScalarFunction) 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.
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.
EqualsOverloaded.  
Equals (inherited from DomainObjects.DbAccess.Command.SqlStatement.Function.ScalarFunction)Overloaded.  
GetHashCode 
GetImmediateChildExpressions Gets the child object model expressions that are directly contained by this expression.
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 (inherited from DomainObjects.DbAccess.Command.SqlStatement.Function.ScalarFunction) 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.
GetType (inherited from Object)Gets the Type of the current instance.
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.
Upper (inherited from Field) Returns the upper case string of this field's values. Translates to a UPPER(field) SQL function.

See Also

Case Class | DomainObjects.Facade.Command.Function Namespace