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 (Entity SQL).

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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
Public methodStatic memberCreateDateTimeOffsetInvokes the canonical CreateDateTimeOffset function. For information about the canonical CreateDateTimeOffset function, see Date and Time Canonical Functions (Entity SQL).
Public methodStatic memberCreateTimeInvokes the canonical CreateTime function. For information about the canonical CreateTime function, see Date and Time Canonical Functions (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
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 (Entity SQL).
Public methodStatic memberGetTotalOffsetMinutesInvokes the canonical GetTotalOffsetMinutes function. For information about the canonical GetTotalOffsetMinutes function, see Date and Time Canonical Functions (Entity SQL).
Public methodStatic memberLeftInvokes the canonical Left function. For information about the canonical Left function, see String Canonical Functions (Entity SQL).
Public methodStatic memberReverseInvokes the canonical Reverse function. For information about the canonical Reverse function, see String Canonical Functions (Entity SQL).
Public methodStatic memberRightInvokes the canonical Right function. For information about the canonical Right function, see String Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviation(IEnumerable<Decimal>)Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviation(IEnumerable<Nullable<Decimal>>)Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviation(IEnumerable<Double>)Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviation(IEnumerable<Nullable<Double>>)Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviation(IEnumerable<Int32>)Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviation(IEnumerable<Nullable<Int32>>)Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviation(IEnumerable<Int64>)Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviation(IEnumerable<Nullable<Int64>>)Invokes the canonical StDev function. For information about the canonical StDev function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviationP(IEnumerable<Decimal>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviationP(IEnumerable<Nullable<Decimal>>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviationP(IEnumerable<Double>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviationP(IEnumerable<Nullable<Double>>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviationP(IEnumerable<Int32>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviationP(IEnumerable<Nullable<Int32>>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviationP(IEnumerable<Int64>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberStandardDeviationP(IEnumerable<Nullable<Int64>>)Invokes the canonical StDevP function. For information about the canonical StDevP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberTruncate(Nullable<Decimal>, Nullable<Int32>)Invokes the canonical Truncate function. For information about the canonical Truncate function, see Math Canonical Functions (Entity SQL).
Public methodStatic memberTruncate(Nullable<Double>, Nullable<Int32>)Invokes the canonical Truncate function. For information about the canonical Truncate function, see Math Canonical Functions (Entity SQL).
Public methodStatic memberTruncateTime(Nullable<DateTime>)Invokes the canonical TruncateTime function. For information about the canonical TruncateTime function, see Date and Time Canonical Functions (Entity SQL).
Public methodStatic memberTruncateTime(Nullable<DateTimeOffset>)Invokes the canonical TruncateTime function. For information about the canonical TruncateTime function, see Date and Time Canonical Functions (Entity SQL).
Public methodStatic memberVar(IEnumerable<Decimal>)Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVar(IEnumerable<Nullable<Decimal>>)Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVar(IEnumerable<Double>)Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVar(IEnumerable<Nullable<Double>>)Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVar(IEnumerable<Int32>)Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVar(IEnumerable<Nullable<Int32>>)Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVar(IEnumerable<Int64>)Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVar(IEnumerable<Nullable<Int64>>)Invokes the canonical Var function. For information about the canonical Var function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVarP(IEnumerable<Decimal>)Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVarP(IEnumerable<Nullable<Decimal>>)Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVarP(IEnumerable<Double>)Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVarP(IEnumerable<Nullable<Double>>)Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVarP(IEnumerable<Int32>)Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVarP(IEnumerable<Nullable<Int32>>)Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVarP(IEnumerable<Int64>)Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL).
Public methodStatic memberVarP(IEnumerable<Nullable<Int64>>)Invokes the canonical VarP function. For information about the canonical VarP function, see Aggregate Canonical Functions (Entity SQL).
Top

.NET Framework

Supported in: 4

.NET Framework Client Profile

Supported in: 4

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft