This documentation is archived and is not being maintained.
EntityFunctions Class
Visual Studio 2010
Provides common language runtime (CLR) methods that expose conceptual model canonical functions in LINQ to Entities queries. For information about canonical functions, see Canonical Functions (Entity SQL).
Assembly: System.Data.Entity (in System.Data.Entity.dll)
The EntityFunctions type exposes the following members.
| Name | Description | |
|---|---|---|
![]() ![]() | AddDays(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddDays function. For information about the canonical AddDays function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddDays(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddDays function. For information about the canonical AddDays function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddHours(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddHours(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddHours(Nullable<TimeSpan>, Nullable<Int32>) | Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMicroseconds(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMicroseconds(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMicroseconds(Nullable<TimeSpan>, Nullable<Int32>) | Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMilliseconds(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMilliseconds(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMilliseconds(Nullable<TimeSpan>, Nullable<Int32>) | Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMinutes(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMinutes(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMinutes(Nullable<TimeSpan>, Nullable<Int32>) | Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMonths(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddMonths function. For information about the canonical AddMonths function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddMonths(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddMonths function. For information about the canonical AddMonths function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddNanoseconds(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddNanoseconds(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddNanoseconds(Nullable<TimeSpan>, Nullable<Int32>) | Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddSeconds(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddSeconds(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddSeconds(Nullable<TimeSpan>, Nullable<Int32>) | Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddYears(Nullable<DateTime>, Nullable<Int32>) | Invokes the canonical AddYears function. For information about the canonical AddYears function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AddYears(Nullable<DateTimeOffset>, Nullable<Int32>) | Invokes the canonical AddYears function. For information about the canonical AddYears function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | AsNonUnicode | A LINQ to Entities operator that treats the input string as a non-unicode string. This method only applies to LINQ to Entities queries. |
![]() ![]() | AsUnicode | A LINQ to Entities operator that ensures the input string is treated as a unicode string. This method only applies to LINQ to Entities queries. |
![]() ![]() | CreateDateTime | Invokes the canonical CreateDateTime function. For information about the canonical CreateDateTime function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | CreateDateTimeOffset | Invokes the canonical CreateDateTimeOffset function. For information about the canonical CreateDateTimeOffset function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | CreateTime | Invokes the canonical CreateTime function. For information about the canonical CreateTime function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffDays(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffDays function. For information about the canonical DiffDays function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffDays(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffDays function. For information about the canonical DiffDays function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffHours(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffHours(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffHours(Nullable<TimeSpan>, Nullable<TimeSpan>) | Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMicroseconds(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMicroseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMicroseconds(Nullable<TimeSpan>, Nullable<TimeSpan>) | Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMilliseconds(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMilliseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMilliseconds(Nullable<TimeSpan>, Nullable<TimeSpan>) | Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMinutes(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMinutes(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMinutes(Nullable<TimeSpan>, Nullable<TimeSpan>) | Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMonths(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffMonths function. For information about the canonical DiffMonths function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffMonths(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffMonths function. For information about the canonical DiffMonths function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffNanoseconds(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffNanoseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffNanoseconds(Nullable<TimeSpan>, Nullable<TimeSpan>) | Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffSeconds(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffSeconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffSeconds(Nullable<TimeSpan>, Nullable<TimeSpan>) | Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffYears(Nullable<DateTime>, Nullable<DateTime>) | Invokes the canonical DiffYears function. For information about the canonical DiffYears function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | DiffYears(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Invokes the canonical DiffYears function. For information about the canonical DiffYears function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | GetTotalOffsetMinutes | Invokes the canonical GetTotalOffsetMinutes function. For information about the canonical GetTotalOffsetMinutes function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | Left | Invokes the canonical Left function. For information about the canonical Left function, see String Canonical Functions (Entity SQL). |
![]() ![]() | Reverse | Invokes the canonical Reverse function. For information about the canonical Reverse function, see String Canonical Functions (Entity SQL). |
![]() ![]() | Right | Invokes the canonical Right function. For information about the canonical Right function, see String Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviation(IEnumerable<Decimal>) | Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviation(IEnumerable<Nullable<Decimal>>) | Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviation(IEnumerable<Double>) | Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviation(IEnumerable<Nullable<Double>>) | Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviation(IEnumerable<Int32>) | Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviation(IEnumerable<Nullable<Int32>>) | Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviation(IEnumerable<Int64>) | Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviation(IEnumerable<Nullable<Int64>>) | Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviationP(IEnumerable<Decimal>) | Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviationP(IEnumerable<Nullable<Decimal>>) | Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviationP(IEnumerable<Double>) | Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviationP(IEnumerable<Nullable<Double>>) | Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviationP(IEnumerable<Int32>) | Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviationP(IEnumerable<Nullable<Int32>>) | Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviationP(IEnumerable<Int64>) | Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | StandardDeviationP(IEnumerable<Nullable<Int64>>) | Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | Truncate(Nullable<Decimal>, Nullable<Int32>) | Invokes the canonical Truncate function. For information about the canonical Truncate function, see Math Canonical Functions (Entity SQL). |
![]() ![]() | Truncate(Nullable<Double>, Nullable<Int32>) | Invokes the canonical Truncate function. For information about the canonical Truncate function, see Math Canonical Functions (Entity SQL). |
![]() ![]() | TruncateTime(Nullable<DateTime>) | Invokes the canonical TruncateTime function. For information about the canonical TruncateTime function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | TruncateTime(Nullable<DateTimeOffset>) | Invokes the canonical TruncateTime function. For information about the canonical TruncateTime function, see Date and Time Canonical Functions (Entity SQL). |
![]() ![]() | Var(IEnumerable<Decimal>) | Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | Var(IEnumerable<Nullable<Decimal>>) | Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | Var(IEnumerable<Double>) | Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | Var(IEnumerable<Nullable<Double>>) | Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | Var(IEnumerable<Int32>) | Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | Var(IEnumerable<Nullable<Int32>>) | Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | Var(IEnumerable<Int64>) | Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | Var(IEnumerable<Nullable<Int64>>) | Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | VarP(IEnumerable<Decimal>) | Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | VarP(IEnumerable<Nullable<Decimal>>) | Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | VarP(IEnumerable<Double>) | Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | VarP(IEnumerable<Nullable<Double>>) | Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | VarP(IEnumerable<Int32>) | Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | VarP(IEnumerable<Nullable<Int32>>) | Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | VarP(IEnumerable<Int64>) | Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL). |
![]() ![]() | VarP(IEnumerable<Nullable<Int64>>) | Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL). |
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Show:
