EdmFunctions Methods

.NET Framework (current version)
 

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

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.

Return to top
Show: