Export (0) Print
Expand All

EdmFunctions Class

.NET Framework 4.5

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.

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

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

public static class EdmFunctions

The EdmFunctions type exposes the following members.

  NameDescription
Public methodStatic memberAbs 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.
Public methodStatic memberAddDays 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.
Public methodStatic memberAddHours 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.
Public methodStatic memberAddMicroseconds 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.
Public methodStatic memberAddMilliseconds 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.
Public methodStatic memberAddMinutes 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.
Public methodStatic memberAddMonths 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.
Public methodStatic memberAddNanoseconds 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.
Public methodStatic memberAddSeconds 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.
Public methodStatic memberAddYears 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.
Public methodStatic memberAverage 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.
Public methodStatic memberBitwiseAnd 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.
Public methodStatic memberBitwiseNot 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.
Public methodStatic memberBitwiseOr 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.
Public methodStatic memberBitwiseXor 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.
Public methodStatic memberCeiling 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.
Public methodStatic memberConcat 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.
Public methodStatic memberContains 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.
Public methodStatic memberCount Creates a DbFunctionExpression that invokes the canonical 'Count' function over the specified collection. The result type of the expression is Edm.Int32.
Public methodStatic memberCreateDateTime 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.
Public methodStatic memberCreateDateTimeOffset 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.
Public methodStatic memberCreateTime 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.
Public methodStatic memberCurrentDateTime Creates a DbFunctionExpression that invokes the canonical 'CurrentDateTime' function.
Public methodStatic memberCurrentDateTimeOffset Creates a DbFunctionExpression that invokes the canonical 'CurrentDateTimeOffset' function.
Public methodStatic memberCurrentUtcDateTime Creates a DbFunctionExpression that invokes the canonical 'CurrentUtcDateTime' function.
Public methodStatic memberDay 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.
Public methodStatic memberDayOfYear 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.
Public methodStatic memberDiffDays 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.
Public methodStatic memberDiffHours 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.
Public methodStatic memberDiffMicroseconds 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.
Public methodStatic memberDiffMilliseconds 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.
Public methodStatic memberDiffMinutes 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.
Public methodStatic memberDiffMonths 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.
Public methodStatic memberDiffNanoseconds 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.
Public methodStatic memberDiffSeconds 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.
Public methodStatic memberDiffYears 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.
Public methodStatic memberEndsWith 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.
Public methodStatic memberFloor 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.
Public methodStatic memberGetTotalOffsetMinutes 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.
Public methodStatic memberHour 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.
Public methodStatic memberIndexOf 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.
Public methodStatic memberLeft 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.
Public methodStatic memberLength 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.
Public methodStatic memberLongCount Creates a DbFunctionExpression that invokes the canonical 'BigCount' function over the specified collection. The result type of the expression is Edm.Int64.
Public methodStatic memberMax 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.
Public methodStatic memberMillisecond 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.
Public methodStatic memberMin 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.
Public methodStatic memberMinute 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.
Public methodStatic memberMonth 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.
Public methodStatic memberNewGuid Creates a DbFunctionExpression that invokes the canonical 'NewGuid' function.
Public methodStatic memberPower 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.
Public methodStatic memberReplace 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.
Public methodStatic memberReverse 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.
Public methodStatic memberRight 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.
Public methodStatic memberRound(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.
Public methodStatic memberRound(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.
Public methodStatic memberSecond 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.
Public methodStatic memberStartsWith 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.
Public methodStatic memberStDev 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.
Public methodStatic memberStDevP 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.
Public methodStatic memberSubstring 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.
Public methodStatic memberSum 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.
Public methodStatic memberToLower 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.
Public methodStatic memberToUpper 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.
Public methodStatic memberTrim 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.
Public methodStatic memberTrimEnd 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.
Public methodStatic memberTrimStart 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.
Public methodStatic memberTruncate 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.
Public methodStatic memberTruncateTime 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.
Public methodStatic memberVar 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.
Public methodStatic memberVarP Creates a DbFunctionExpression that invokes the canonical 'VarP' function over the population of the specified collection. The result type of the expression Edm.Double.
Public methodStatic memberYear 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.
Top

.NET Framework

Supported in: 4.5

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

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