EdmFunctions Class
Collapse the table of content
Expand the table of content

EdmFunctions Class

.NET Framework (current version)
 

Provides an API to construct DbExpressions that invoke canonical EDM functions, and allows that API to be accessed as extension methods on the expression type itself.

Namespace:   System.Data.Common.CommandTrees.ExpressionBuilder
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

System.Object
  System.Data.Common.CommandTrees.ExpressionBuilder.EdmFunctions

public static class EdmFunctions

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticAbs(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Abs' function with the specified argument, which must each have a numeric result type. The result type of the expression is the same as the result type of value.

System_CAPS_pubmethodSystem_CAPS_staticAddDays(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddDays' function with the specified arguments, which must have DateTime or DateTimeOffset and integer result types. The result type of the expression is the same as the result type of dateValue.

System_CAPS_pubmethodSystem_CAPS_staticAddHours(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddHours' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

System_CAPS_pubmethodSystem_CAPS_staticAddMicroseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddMicroseconds' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

System_CAPS_pubmethodSystem_CAPS_staticAddMilliseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddMilliseconds' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

System_CAPS_pubmethodSystem_CAPS_staticAddMinutes(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddMinutes' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

System_CAPS_pubmethodSystem_CAPS_staticAddMonths(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddMonths' function with the specified arguments, which must have DateTime or DateTimeOffset and integer result types. The result type of the expression is the same as the result type of dateValue.

System_CAPS_pubmethodSystem_CAPS_staticAddNanoseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddNanoseconds' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

System_CAPS_pubmethodSystem_CAPS_staticAddSeconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddSeconds' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

System_CAPS_pubmethodSystem_CAPS_staticAddYears(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddYears' function with the specified arguments, which must have DateTime or DateTimeOffset and integer result types. The result type of the expression is the same as the result type of dateValue.

System_CAPS_pubmethodSystem_CAPS_staticAverage(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Avg' function over the specified collection. The result type of the expression is the same as the element type of the collection.

System_CAPS_pubmethodSystem_CAPS_staticBitwiseAnd(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BitwiseAnd' function with the specified arguments, which must have the same integer numeric result type. The result type of the expression is the same as the type of the arguments.

System_CAPS_pubmethodSystem_CAPS_staticBitwiseNot(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BitwiseNot' function with the specified argument, which must have an integer numeric result type. The result type of the expression is the same as the type of the arguments.

System_CAPS_pubmethodSystem_CAPS_staticBitwiseOr(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BitwiseOr' function with the specified arguments, which must have the same integer numeric result type. The result type of the expression is the same as the type of the arguments.

System_CAPS_pubmethodSystem_CAPS_staticBitwiseXor(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BitwiseXor' function with the specified arguments, which must have the same integer numeric result type. The result type of the expression is the same as the type of the arguments.

System_CAPS_pubmethodSystem_CAPS_staticCeiling(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Ceiling' function with the specified argument, which must each have a single, double or decimal result type. The result type of the expression is the same as the result type of value.

System_CAPS_pubmethodSystem_CAPS_staticConcat(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Concat' function with the specified arguments, which must each have a string result type. The result type of the expression is string.

System_CAPS_pubmethodSystem_CAPS_staticContains(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Contains' function with the specified arguments, which must each have a string result type. The result type of the expression is Boolean.

System_CAPS_pubmethodSystem_CAPS_staticCount(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Count' function over the specified collection. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticCreateDateTime(DbExpression, DbExpression, DbExpression, DbExpression, DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'CreateDateTime' function with the specified arguments. second must have a result type of Edm.Double, while all other arguments must have a result type of Edm.Int32. The result type of the expression is Edm.DateTime.

System_CAPS_pubmethodSystem_CAPS_staticCreateDateTimeOffset(DbExpression, DbExpression, DbExpression, DbExpression, DbExpression, DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'CreateDateTimeOffset' function with the specified arguments. second must have a result type of Edm.Double, while all other arguments must have a result type of Edm.Int32. The result type of the expression is Edm.DateTimeOffset.

System_CAPS_pubmethodSystem_CAPS_staticCreateTime(DbExpression, DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'CreateTime' function with the specified arguments. second must have a result type of Edm.Double, while all other arguments must have a result type of Edm.Int32. The result type of the expression is Edm.Time.

System_CAPS_pubmethodSystem_CAPS_staticCurrentDateTime()

Creates a DbFunctionExpression that invokes the canonical 'CurrentDateTime' function.

System_CAPS_pubmethodSystem_CAPS_staticCurrentDateTimeOffset()

Creates a DbFunctionExpression that invokes the canonical 'CurrentDateTimeOffset' function.

System_CAPS_pubmethodSystem_CAPS_staticCurrentUtcDateTime()

Creates a DbFunctionExpression that invokes the canonical 'CurrentUtcDateTime' function.

System_CAPS_pubmethodSystem_CAPS_staticDay(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Day' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDayOfYear(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DayOfYear' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffDays(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffDays' function with the specified arguments, which must each have DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffHours(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffHours' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffMicroseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffMicroseconds' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffMilliseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffMilliseconds' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffMinutes(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffMinutes' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffMonths(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffMonths' function with the specified arguments, which must each have DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffNanoseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffNanoseconds' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffSeconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffSeconds' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticDiffYears(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffYears' function with the specified arguments, which must each have DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticEndsWith(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'EndsWith' function with the specified arguments, which must each have a string result type. The result type of the expression is Boolean.

System_CAPS_pubmethodSystem_CAPS_staticFloor(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Floor' function with the specified argument, which must each have a single, double or decimal result type. The result type of the expression is the same as the result type of value.

System_CAPS_pubmethodSystem_CAPS_staticGetTotalOffsetMinutes(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'GetTotalOffsetMinutes' function with the specified argument, which must have a DateTimeOffset result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticHour(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Hour' function with the specified argument, which must have a DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticIndexOf(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'IndexOf' function with the specified arguments, which must each have a string result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticLeft(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Left' function with the specified arguments, which must have a string and integer numeric result type. The result type of the expression is string.

System_CAPS_pubmethodSystem_CAPS_staticLength(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Length' function with the specified argument, which must have a string result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticLongCount(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BigCount' function over the specified collection. The result type of the expression is Edm.Int64.

System_CAPS_pubmethodSystem_CAPS_staticMax(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Max' function over the specified collection. The result type of the expression is the same as the element type of the collection.

System_CAPS_pubmethodSystem_CAPS_staticMillisecond(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Millisecond' function with the specified argument, which must have a DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticMin(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Min' function over the specified collection. The result type of the expression is the same as the element type of the collection.

System_CAPS_pubmethodSystem_CAPS_staticMinute(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Minute' function with the specified argument, which must have a DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticMonth(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Month' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticNewGuid()

Creates a DbFunctionExpression that invokes the canonical 'NewGuid' function.

System_CAPS_pubmethodSystem_CAPS_staticPower(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Power' function with the specified arguments, which must have numeric result types. The result type of the expression is the same as the result type of baseArgument.

System_CAPS_pubmethodSystem_CAPS_staticReplace(DbExpression, DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Replace' function with the specified arguments, which must each have a string result type. The result type of the expression is also string.

System_CAPS_pubmethodSystem_CAPS_staticReverse(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Reverse' function with the specified argument, which must have a string result type. The result type of the expression is also string.

System_CAPS_pubmethodSystem_CAPS_staticRight(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Right' function with the specified arguments, which must have a string and integer numeric result type. The result type of the expression is string.

System_CAPS_pubmethodSystem_CAPS_staticRound(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Round' function with the specified argument, which must each have a single, double or decimal result type. The result type of the expression is the same as the result type of value.

System_CAPS_pubmethodSystem_CAPS_staticRound(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Round' function with the specified arguments, which must have a single, double or decimal, and integer result types. The result type of the expression is the same as the result type of value.

System_CAPS_pubmethodSystem_CAPS_staticSecond(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Second' function with the specified argument, which must have a DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

System_CAPS_pubmethodSystem_CAPS_staticStartsWith(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'StartsWith' function with the specified arguments, which must each have a string result type. The result type of the expression is Boolean.

System_CAPS_pubmethodSystem_CAPS_staticStDev(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'StDev' function over the non-null members of the specified collection. The result type of the expression is Edm.Double.

System_CAPS_pubmethodSystem_CAPS_staticStDevP(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'StDevP' function over the population of the specified collection. The result type of the expression is Edm.Double.

System_CAPS_pubmethodSystem_CAPS_staticSubstring(DbExpression, DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Substring' function with the specified arguments, which must have a string and integer numeric result types. The result type of the expression is string.

System_CAPS_pubmethodSystem_CAPS_staticSum(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Sum' function over the specified collection. The result type of the expression is the same as the element type of the collection.

System_CAPS_pubmethodSystem_CAPS_staticToLower(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'ToLower' function with the specified argument, which must have a string result type. The result type of the expression is also string.

System_CAPS_pubmethodSystem_CAPS_staticToUpper(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'ToUpper' function with the specified argument, which must have a string result type. The result type of the expression is also string.

System_CAPS_pubmethodSystem_CAPS_staticTrim(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Trim' function with the specified argument, which must have a string result type. The result type of the expression is also string.

System_CAPS_pubmethodSystem_CAPS_staticTrimEnd(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'RTrim' function with the specified argument, which must have a string result type. The result type of the expression is also string.

System_CAPS_pubmethodSystem_CAPS_staticTrimStart(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'LTrim' function with the specified argument, which must have a string result type. The result type of the expression is also string.

System_CAPS_pubmethodSystem_CAPS_staticTruncate(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Truncate' function with the specified arguments, which must have a single, double or decimal, and integer result types. The result type of the expression is the same as the result type of value.

System_CAPS_pubmethodSystem_CAPS_staticTruncateTime(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'TruncateTime' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is the same as the result type of dateValue.

System_CAPS_pubmethodSystem_CAPS_staticVar(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Var' function over the non-null members of the specified collection. The result type of the expression is Edm.Double.

System_CAPS_pubmethodSystem_CAPS_staticVarP(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'VarP' function over the population of the specified collection. The result type of the expression Edm.Double.

System_CAPS_pubmethodSystem_CAPS_staticYear(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Year' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

.NET Framework
Available since 4.5

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft