Export (0) Print
Expand All

EntityFunctions Class

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.

System.Object
  System.Data.Objects.EntityFunctions

Namespace:  System.Data.Objects
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

public static class EntityFunctions

The EntityFunctions type exposes the following members.

  NameDescription
Public methodStatic memberAddDays(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddDays function. For information about the canonical AddDays function, see Date and Time Canonical Functions.
Public methodStatic memberAddDays(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddDays function. For information about the canonical AddDays function, see Date and Time Canonical Functions.
Public methodStatic memberAddHours(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions.
Public methodStatic memberAddHours(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions.
Public methodStatic memberAddHours(Nullable<TimeSpan>, Nullable<Int32>)Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions.
Public methodStatic memberAddMicroseconds(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddMicroseconds(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddMicroseconds(Nullable<TimeSpan>, Nullable<Int32>)Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddMilliseconds(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddMilliseconds(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddMilliseconds(Nullable<TimeSpan>, Nullable<Int32>)Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddMinutes(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions.
Public methodStatic memberAddMinutes(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions.
Public methodStatic memberAddMinutes(Nullable<TimeSpan>, Nullable<Int32>)Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions.
Public methodStatic memberAddMonths(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddMonths function. For information about the canonical AddMonths function, see Date and Time Canonical Functions.
Public methodStatic memberAddMonths(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddMonths function. For information about the canonical AddMonths function, see Date and Time Canonical Functions.
Public methodStatic memberAddNanoseconds(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddNanoseconds(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddNanoseconds(Nullable<TimeSpan>, Nullable<Int32>)Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddSeconds(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddSeconds(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddSeconds(Nullable<TimeSpan>, Nullable<Int32>)Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions.
Public methodStatic memberAddYears(Nullable<DateTime>, Nullable<Int32>)Invokes the canonical AddYears function. For information about the canonical AddYears function, see Date and Time Canonical Functions.
Public methodStatic memberAddYears(Nullable<DateTimeOffset>, Nullable<Int32>)Invokes the canonical AddYears function. For information about the canonical AddYears function, see Date and Time Canonical Functions.
Public methodStatic memberAsNonUnicodeA LINQ to Entities operator that treats the input string as a non-unicode string. This method only applies to LINQ to Entities queries.
Public methodStatic memberAsUnicodeA LINQ to Entities operator that ensures the input string is treated as a unicode string. This method only applies to LINQ to Entities queries.
Public methodStatic memberCreateDateTimeInvokes the canonical CreateDateTime function. For information about the canonical CreateDateTime function, see Date and Time Canonical Functions.
Public methodStatic memberCreateDateTimeOffsetInvokes the canonical CreateDateTimeOffset function. For information about the canonical CreateDateTimeOffset function, see Date and Time Canonical Functions.
Public methodStatic memberCreateTimeInvokes the canonical CreateTime function. For information about the canonical CreateTime function, see Date and Time Canonical Functions.
Public methodStatic memberDiffDays(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffDays function. For information about the canonical DiffDays function, see Date and Time Canonical Functions.
Public methodStatic memberDiffDays(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffDays function. For information about the canonical DiffDays function, see Date and Time Canonical Functions.
Public methodStatic memberDiffHours(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions.
Public methodStatic memberDiffHours(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions.
Public methodStatic memberDiffHours(Nullable<TimeSpan>, Nullable<TimeSpan>)Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMicroseconds(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMicroseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMicroseconds(Nullable<TimeSpan>, Nullable<TimeSpan>)Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMilliseconds(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMilliseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMilliseconds(Nullable<TimeSpan>, Nullable<TimeSpan>)Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMinutes(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMinutes(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMinutes(Nullable<TimeSpan>, Nullable<TimeSpan>)Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMonths(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffMonths function. For information about the canonical DiffMonths function, see Date and Time Canonical Functions.
Public methodStatic memberDiffMonths(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffMonths function. For information about the canonical DiffMonths function, see Date and Time Canonical Functions.
Public methodStatic memberDiffNanoseconds(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffNanoseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffNanoseconds(Nullable<TimeSpan>, Nullable<TimeSpan>)Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffSeconds(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffSeconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffSeconds(Nullable<TimeSpan>, Nullable<TimeSpan>)Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions.
Public methodStatic memberDiffYears(Nullable<DateTime>, Nullable<DateTime>)Invokes the canonical DiffYears function. For information about the canonical DiffYears function, see Date and Time Canonical Functions.
Public methodStatic memberDiffYears(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Invokes the canonical DiffYears function. For information about the canonical DiffYears function, see Date and Time Canonical Functions.
Public methodStatic memberGetTotalOffsetMinutesInvokes the canonical GetTotalOffsetMinutes function. For information about the canonical GetTotalOffsetMinutes function, see Date and Time Canonical Functions.
Public methodStatic memberLeftInvokes the canonical Left function. For information about the canonical Left function, see String Canonical Functions.
Public methodStatic memberReverseInvokes the canonical Reverse function. For information about the canonical Reverse function, see String Canonical Functions.
Public methodStatic memberRightInvokes the canonical Right function. For information about the canonical Right function, see String Canonical Functions.
Public methodStatic memberStandardDeviation(IEnumerable<Decimal>)Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.
Public methodStatic memberStandardDeviation(IEnumerable<Nullable<Decimal>>)Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.
Public methodStatic memberStandardDeviation(IEnumerable<Double>)Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.
Public methodStatic memberStandardDeviation(IEnumerable<Nullable<Double>>)Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.
Public methodStatic memberStandardDeviation(IEnumerable<Int32>)Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.
Public methodStatic memberStandardDeviation(IEnumerable<Nullable<Int32>>)Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.
Public methodStatic memberStandardDeviation(IEnumerable<Int64>)Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.
Public methodStatic memberStandardDeviation(IEnumerable<Nullable<Int64>>)Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.
Public methodStatic memberStandardDeviationP(IEnumerable<Decimal>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.
Public methodStatic memberStandardDeviationP(IEnumerable<Nullable<Decimal>>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.
Public methodStatic memberStandardDeviationP(IEnumerable<Double>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.
Public methodStatic memberStandardDeviationP(IEnumerable<Nullable<Double>>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.
Public methodStatic memberStandardDeviationP(IEnumerable<Int32>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.
Public methodStatic memberStandardDeviationP(IEnumerable<Nullable<Int32>>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.
Public methodStatic memberStandardDeviationP(IEnumerable<Int64>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.
Public methodStatic memberStandardDeviationP(IEnumerable<Nullable<Int64>>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.
Public methodStatic memberTruncate(Nullable<Decimal>, Nullable<Int32>)Invokes the canonical Truncate function. For information about the canonical Truncate function, seeMath Canonical Functions.
Public methodStatic memberTruncate(Nullable<Double>, Nullable<Int32>)Invokes the canonical Truncate function. For information about the canonical Truncate function, seeMath Canonical Functions.
Public methodStatic memberTruncateTime(Nullable<DateTime>)Invokes the canonical TruncateTime function. For information about the canonical TruncateTime function, see Date and Time Canonical Functions.
Public methodStatic memberTruncateTime(Nullable<DateTimeOffset>)Invokes the canonical TruncateTime function. For information about the canonical TruncateTime function, see Date and Time Canonical Functions.
Public methodStatic memberVar(IEnumerable<Decimal>)Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.
Public methodStatic memberVar(IEnumerable<Nullable<Decimal>>)Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.
Public methodStatic memberVar(IEnumerable<Double>)Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.
Public methodStatic memberVar(IEnumerable<Nullable<Double>>)Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.
Public methodStatic memberVar(IEnumerable<Int32>)Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.
Public methodStatic memberVar(IEnumerable<Nullable<Int32>>)Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.
Public methodStatic memberVar(IEnumerable<Int64>)Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.
Public methodStatic memberVar(IEnumerable<Nullable<Int64>>)Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.
Public methodStatic memberVarP(IEnumerable<Decimal>)Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.
Public methodStatic memberVarP(IEnumerable<Nullable<Decimal>>)Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.
Public methodStatic memberVarP(IEnumerable<Double>)Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.
Public methodStatic memberVarP(IEnumerable<Nullable<Double>>)Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.
Public methodStatic memberVarP(IEnumerable<Int32>)Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.
Public methodStatic memberVarP(IEnumerable<Nullable<Int32>>)Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.
Public methodStatic memberVarP(IEnumerable<Int64>)Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.
Public methodStatic memberVarP(IEnumerable<Nullable<Int64>>)Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.
Top

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4

.NET Framework Client Profile

Supported in: 4

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