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 DbExpression s that invoke canonical EDM functions, and allows that API to be accessed as extension methods on the expression type itself.
public ref class EdmFunctions abstract sealed
public static class EdmFunctions
type EdmFunctions = class
Public 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
CreateDateTimeOffset(DbExpression, DbExpression, DbExpression, DbExpression, DbExpression, DbExpression, DbExpression) |
Creates a DbFunctionExpression that invokes the canonical 'CreateDateTimeOffset' function with the specified arguments. |
CreateTime(DbExpression, DbExpression, DbExpression) |
Creates a DbFunctionExpression that invokes the canonical 'CreateTime' function with the specified arguments. |
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 |
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 |
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 |
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 |
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 |
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 |
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. |