EntityFunctions Class

Definition

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.

C#
public static class EntityFunctions
Inheritance
EntityFunctions

Methods

AddDays(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddDays function. For information about the canonical AddDays function, see Date and Time Canonical Functions.

AddDays(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddDays function. For information about the canonical AddDays function, see Date and Time Canonical Functions.

AddHours(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions.

AddHours(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions.

AddHours(Nullable<TimeSpan>, Nullable<Int32>)

Invokes the canonical AddHours function. For information about the canonical AddHours function, see Date and Time Canonical Functions.

AddMicroseconds(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions.

AddMicroseconds(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions.

AddMicroseconds(Nullable<TimeSpan>, Nullable<Int32>)

Invokes the canonical AddMicroseconds function. For information about the canonical AddMicroseconds function, see Date and Time Canonical Functions.

AddMilliseconds(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions.

AddMilliseconds(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions.

AddMilliseconds(Nullable<TimeSpan>, Nullable<Int32>)

Invokes the canonical AddMilliseconds function. For information about the canonical AddMilliseconds function, see Date and Time Canonical Functions.

AddMinutes(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions.

AddMinutes(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions.

AddMinutes(Nullable<TimeSpan>, Nullable<Int32>)

Invokes the canonical AddMinutes function. For information about the canonical AddMinutes function, see Date and Time Canonical Functions.

AddMonths(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddMonths function. For information about the canonical AddMonths function, see Date and Time Canonical Functions.

AddMonths(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddMonths function. For information about the canonical AddMonths function, see Date and Time Canonical Functions.

AddNanoseconds(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions.

AddNanoseconds(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions.

AddNanoseconds(Nullable<TimeSpan>, Nullable<Int32>)

Invokes the canonical AddNanoseconds function. For information about the canonical AddNanoseconds function, see Date and Time Canonical Functions.

AddSeconds(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions.

AddSeconds(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions.

AddSeconds(Nullable<TimeSpan>, Nullable<Int32>)

Invokes the canonical AddSeconds function. For information about the canonical AddSeconds function, see Date and Time Canonical Functions.

AddYears(Nullable<DateTime>, Nullable<Int32>)

Invokes the canonical AddYears function. For information about the canonical AddYears function, see Date and Time Canonical Functions.

AddYears(Nullable<DateTimeOffset>, Nullable<Int32>)

Invokes the canonical AddYears function. For information about the canonical AddYears function, see Date and Time Canonical Functions.

AsNonUnicode(String)

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(String)

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(Nullable<Int32>, Nullable<Int32>, Nullable<Int32>, Nullable<Int32>, Nullable<Int32>, Nullable<Double>)

Invokes the canonical CreateDateTime function. For information about the canonical CreateDateTime function, see Date and Time Canonical Functions.

CreateDateTimeOffset(Nullable<Int32>, Nullable<Int32>, Nullable<Int32>, Nullable<Int32>, Nullable<Int32>, Nullable<Double>, Nullable<Int32>)

Invokes the canonical CreateDateTimeOffset function. For information about the canonical CreateDateTimeOffset function, see Date and Time Canonical Functions.

CreateTime(Nullable<Int32>, Nullable<Int32>, Nullable<Double>)

Invokes the canonical CreateTime function. For information about the canonical CreateTime function, see Date and Time Canonical Functions.

DiffDays(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffDays function. For information about the canonical DiffDays function, see Date and Time Canonical Functions.

DiffDays(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffDays function. For information about the canonical DiffDays function, see Date and Time Canonical Functions.

DiffHours(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions.

DiffHours(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions.

DiffHours(Nullable<TimeSpan>, Nullable<TimeSpan>)

Invokes the canonical DiffHours function. For information about the canonical DiffHours function, see Date and Time Canonical Functions.

DiffMicroseconds(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions.

DiffMicroseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions.

DiffMicroseconds(Nullable<TimeSpan>, Nullable<TimeSpan>)

Invokes the canonical DiffMicroseconds function. For information about the canonical DiffMicroseconds function, see Date and Time Canonical Functions.

DiffMilliseconds(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions.

DiffMilliseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions.

DiffMilliseconds(Nullable<TimeSpan>, Nullable<TimeSpan>)

Invokes the canonical DiffMilliseconds function. For information about the canonical DiffMilliseconds function, see Date and Time Canonical Functions.

DiffMinutes(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions.

DiffMinutes(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions.

DiffMinutes(Nullable<TimeSpan>, Nullable<TimeSpan>)

Invokes the canonical DiffMinutes function. For information about the canonical DiffMinutes function, see Date and Time Canonical Functions.

DiffMonths(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffMonths function. For information about the canonical DiffMonths function, see Date and Time Canonical Functions.

DiffMonths(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffMonths function. For information about the canonical DiffMonths function, see Date and Time Canonical Functions.

DiffNanoseconds(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions.

DiffNanoseconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions.

DiffNanoseconds(Nullable<TimeSpan>, Nullable<TimeSpan>)

Invokes the canonical DiffNanoseconds function. For information about the canonical DiffNanoseconds function, see Date and Time Canonical Functions.

DiffSeconds(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions.

DiffSeconds(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions.

DiffSeconds(Nullable<TimeSpan>, Nullable<TimeSpan>)

Invokes the canonical DiffSeconds function. For information about the canonical DiffSeconds function, see Date and Time Canonical Functions.

DiffYears(Nullable<DateTime>, Nullable<DateTime>)

Invokes the canonical DiffYears function. For information about the canonical DiffYears function, see Date and Time Canonical Functions.

DiffYears(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Invokes the canonical DiffYears function. For information about the canonical DiffYears function, see Date and Time Canonical Functions.

GetTotalOffsetMinutes(Nullable<DateTimeOffset>)

Invokes the canonical GetTotalOffsetMinutes function. For information about the canonical GetTotalOffsetMinutes function, see Date and Time Canonical Functions.

Left(String, Nullable<Int64>)

Invokes the canonical Left function. For information about the canonical Left function, see String Canonical Functions.

Reverse(String)

Invokes the canonical Reverse function. For information about the canonical Reverse function, see String Canonical Functions.

Right(String, Nullable<Int64>)

Invokes the canonical Right function. For information about the canonical Right function, see String Canonical Functions.

StandardDeviation(IEnumerable<Decimal>)

Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.

StandardDeviation(IEnumerable<Double>)

Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.

StandardDeviation(IEnumerable<Int32>)

Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.

StandardDeviation(IEnumerable<Int64>)

Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.

StandardDeviation(IEnumerable<Nullable<Decimal>>)

Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.

StandardDeviation(IEnumerable<Nullable<Double>>)

Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.

StandardDeviation(IEnumerable<Nullable<Int32>>)

Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.

StandardDeviation(IEnumerable<Nullable<Int64>>)

Invokes the canonical StDev function. For information about the canonical StDev function, see Canonical Functions.

StandardDeviationP(IEnumerable<Decimal>)

Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.

StandardDeviationP(IEnumerable<Double>)

Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.

StandardDeviationP(IEnumerable<Int32>)

Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.

StandardDeviationP(IEnumerable<Int64>)

Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.

StandardDeviationP(IEnumerable<Nullable<Decimal>>)

Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.

StandardDeviationP(IEnumerable<Nullable<Double>>)

Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.

StandardDeviationP(IEnumerable<Nullable<Int32>>)

Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.

StandardDeviationP(IEnumerable<Nullable<Int64>>)

Invokes the canonical StDevP function. For information about the canonical StDevP function, see Canonical Functions.

Truncate(Nullable<Decimal>, Nullable<Int32>)

Invokes the canonical Truncate function. For information about the canonical Truncate function, see Math Canonical Functions.

Truncate(Nullable<Double>, Nullable<Int32>)

Invokes the canonical Truncate function. For information about the canonical Truncate function, see Math Canonical Functions.

TruncateTime(Nullable<DateTime>)

Invokes the canonical TruncateTime function. For information about the canonical TruncateTime function, see Date and Time Canonical Functions.

TruncateTime(Nullable<DateTimeOffset>)

Invokes the canonical TruncateTime function. For information about the canonical TruncateTime function, see Date and Time Canonical Functions.

Var(IEnumerable<Decimal>)

Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.

Var(IEnumerable<Double>)

Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.

Var(IEnumerable<Int32>)

Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.

Var(IEnumerable<Int64>)

Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.

Var(IEnumerable<Nullable<Decimal>>)

Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.

Var(IEnumerable<Nullable<Double>>)

Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.

Var(IEnumerable<Nullable<Int32>>)

Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.

Var(IEnumerable<Nullable<Int64>>)

Invokes the canonical Var function. For information about the canonical Var function, see Canonical Functions.

VarP(IEnumerable<Decimal>)

Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.

VarP(IEnumerable<Double>)

Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.

VarP(IEnumerable<Int32>)

Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.

VarP(IEnumerable<Int64>)

Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.

VarP(IEnumerable<Nullable<Decimal>>)

Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.

VarP(IEnumerable<Nullable<Double>>)

Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.

VarP(IEnumerable<Nullable<Int32>>)

Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.

VarP(IEnumerable<Nullable<Int64>>)

Invokes the canonical VarP function. For information about the canonical VarP function, see Canonical Functions.

Applies to

Product Versions
.NET Framework 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1