DomainObjects Class Library

DomainObjects.Facade.Command.Function Namespace

The DomainObjects.Command.Function namespace provides classes that enable you to define SQL functions in terms of the domain model.

Namespace hierarchy

Classes

Class Description
Average Returns the average of the values in a group. Null values are ignored.
Case Builds a searched SQL CASE function.
Case.WhenThenCase Defines a result to be returned when a search condition is met.
ConvertTo Converts the return value of a field from one data type to another and formats the output according to the specified Style. Only supported for SQL Server.
Count Returns the number of rows in a table as an integer value.
DateAdd Returns a new DateTime based upon adding a specified interval to a date.
DateDiff Returns an integer representing the number of DateTime boundaries crossed between the start DateTime and the end DateTime.
DatePart Returns a string representing a datepart of a date.
GetDate Returns the current system datetime.
Lower Returns the lower case string of the field.
Max Returns the maximum value of a field. Null values are ignored.
Min Returns the minimum value of a field.
Minus Generates a SQL expression that applies the plus operator to two values. The resulting expression has the form 'value1 + value2'.
NewId Creates a unique database-generated value. Translates into the SQL string NEWID().
Plus Generates a SQL expression that applies the plus operator to two values. The resulting expression has the form 'value1 + value2'.
Replace Replaces all occurrences of a specified string value with another string value.
ReplaceNull Replaces NULL with the specified replacement value.
RowNumber Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
Sum Returns the sum of all the values, or only the DISTINCT values, of the field. SUM can be used with numeric columns only. Null values are ignored.
Upper Returns the upper case string of the field.

Enumerations

Enumeration Description
PartOfDateTime Specifies a part of a DateTime.
Style The date format to use when converting a date to a string, or the string format to use when converting float, real, money, or smallmoney data to a string.