EntityFunctions Class

Reference

Definition

Namespace:: System.Data.Objects

Assembly:: System.Data.Entity.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public ref class EntityFunctions abstract sealed

public static class EntityFunctions

type EntityFunctions = class

Public Class EntityFunctions

Inheritance: Object
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

แชร์ผ่าน

EntityFunctions Class

Definition

Methods

Applies to

แหล่งทรัพยากรเพิ่มเติม