EdmFunctions Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.
public static class EdmFunctionstype EdmFunctions = classPublic Module EdmFunctions- Inheritance
-
EdmFunctions
Methods
| Abs(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. |
| AddDays(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. |
| AddHours(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. |
| AddMicroseconds(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. |
| AddMilliseconds(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. |
| AddMinutes(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. |
| AddMonths(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. |
| AddNanoseconds(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. |
| AddSeconds(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. |
| AddYears(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. |
| Average(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. |
| BitwiseAnd(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. |
| BitwiseNot(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. |
| BitwiseOr(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. |
| BitwiseXor(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. |
| Ceiling(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. |
| Concat(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. |
| Contains(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. |
| Count(DbExpression) |
Creates a DbFunctionExpression that invokes the canonical 'Count' function over the specified collection. The result type of the expression is Edm.Int32. |
| CreateDateTime(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. |
| CreateDateTimeOffset(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. |
| CreateTime(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. |
| CurrentDateTime() |
Creates a DbFunctionExpression that invokes the canonical 'CurrentDateTime' function. |
| CurrentDateTimeOffset() |
Creates a DbFunctionExpression that invokes the canonical 'CurrentDateTimeOffset' function. |
| CurrentUtcDateTime() |
Creates a DbFunctionExpression that invokes the canonical 'CurrentUtcDateTime' function. |
| Day(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. |
| DayOfYear(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. |
| DiffDays(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. |
| DiffHours(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. |
| DiffMicroseconds(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. |
| DiffMilliseconds(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. |
| DiffMinutes(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. |
| DiffMonths(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. |
| DiffNanoseconds(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. |
| DiffSeconds(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. |
| DiffYears(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. |
| EndsWith(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. |
| Floor(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. |
| GetTotalOffsetMinutes(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. |
| Hour(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. |
| IndexOf(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. |
| Left(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. |
| Length(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. |
| LongCount(DbExpression) |
Creates a DbFunctionExpression that invokes the canonical 'BigCount' function over the specified collection. The result type of the expression is Edm.Int64. |
| Max(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. |
| Millisecond(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. |
| Min(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. |
| Minute(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. |
| Month(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. |
| NewGuid() |
Creates a DbFunctionExpression that invokes the canonical 'NewGuid' function. |
| Power(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. |
| Replace(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. |
| Reverse(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. |
| Right(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. |
| Round(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. |
| Round(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. |
| Second(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. |
| StartsWith(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. |
| StDev(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. |
| StDevP(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. |
| Substring(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. |
| Sum(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. |
| ToLower(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. |
| ToUpper(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. |
| Trim(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. |
| TrimEnd(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. |
| TrimStart(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. |
| Truncate(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. |
| TruncateTime(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. |
| Var(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. |
| VarP(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. |
| Year(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. |
Applies to
Entity Framework
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for