DbFunctions Class

Reference

Definition

Namespace:: Microsoft.EntityFrameworkCore

Assembly:: Microsoft.EntityFrameworkCore.dll

Package:: Microsoft.EntityFrameworkCore v2.0.3

Package:: Microsoft.EntityFrameworkCore v2.1.11

Package:: Microsoft.EntityFrameworkCore v2.2.6

Package:: Microsoft.EntityFrameworkCore v3.0.0

Package:: Microsoft.EntityFrameworkCore v3.1.0

Package:: Microsoft.EntityFrameworkCore v5.0.0

Package:: Microsoft.EntityFrameworkCore v6.0.0

Package:: Microsoft.EntityFrameworkCore v7.0.0

Package:: Microsoft.EntityFrameworkCore v8.0.0

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 CLR methods that get translated to database functions when used in LINQ to Entities queries. The methods on this class are accessed via Functions.

public class DbFunctions

public sealed class DbFunctions

type DbFunctions = class

Public Class DbFunctions

Public NotInheritable Class DbFunctions

Inheritance: Object
DbFunctions

Remarks

See Database functions for more information and examples.

Extension Methods

Like(DbFunctions, String, String)	An implementation of the SQL `LIKE` operation. On relational databases this is usually directly translated to SQL.
Like(DbFunctions, String, String, String)	An implementation of the SQL LIKE operation. On relational databases this is usually directly translated to SQL.
Random(DbFunctions)	A random double number generator which generates a number between 0 and 1, exclusive.
Collate<TProperty>(DbFunctions, TProperty, String)	Explicitly specifies a collation to be used in a LINQ query. Can be used to generate fragments such as `WHERE customer.name COLLATE 'de_DE' = 'John Doe'`.
Glob(DbFunctions, String, String)	Maps to the SQLite `glob` function which is similar to Like(DbFunctions, String, String) but uses the file system globbing syntax instead.
Hex(DbFunctions, Byte[])	Maps to the SQLite `hex` function which returns a hexadecimal string representing the specified value.
Substr(DbFunctions, Byte[], Int32)	Maps to the SQLite `substr` function which returns a subarray of the specified value. The subarray starts at `startIndex` and continues to the end of the value.
Substr(DbFunctions, Byte[], Int32, Int32)	Maps to the SQLite substr function which returns a subarray of the specified value. The subarray starts at `startIndex` and has the specified `length`.
Unhex(DbFunctions, String)	Maps to the SQLite `unhex` function which returns a BLOB representing decoding of the hexadecimal string.
Unhex(DbFunctions, String, String)	Maps to the SQLite `unhex` function which returns a BLOB representing decoding of the hexadecimal string.
AtTimeZone(DbFunctions, DateTime, String)	Converts `dateTime` to the corresponding `datetimeoffset` in the target `timeZone`. Corresponds to the SQL Server `AT TIME ZONE` construct.
AtTimeZone(DbFunctions, DateTimeOffset, String)	Converts `dateTimeOffset` to the time zone specified by `timeZone`. Corresponds to the SQL Server `AT TIME ZONE` construct.
Contains(DbFunctions, Object, String)	A DbFunction method stub that can be used in LINQ queries to target the SQL Server `CONTAINS` store function.
Contains(DbFunctions, Object, String, Int32)	A DbFunction method stub that can be used in LINQ queries to target the SQL Server `CONTAINS` store function.
Contains(DbFunctions, String, String)	A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.
Contains(DbFunctions, String, String, Int32)	A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.
DataLength(DbFunctions, Byte[])	Returns the number of bytes used to represent any expression.
DataLength(DbFunctions, Nullable<Boolean>)	Returns the number of bytes used to represent any expression.
DataLength(DbFunctions, Nullable<DateTime>)	Returns the number of bytes used to represent any expression.
DataLength(DbFunctions, Nullable<DateTimeOffset>)	Returns the number of bytes used to represent any expression.
DataLength(DbFunctions, Nullable<Decimal>)	Returns the number of bytes used to represent any expression.
DataLength(DbFunctions, Nullable<Double>)	Returns the number of bytes used to represent any expression.
DataLength(DbFunctions, Nullable<Guid>)	Returns the number of bytes used to represent any expression.
DataLength(DbFunctions, Nullable<TimeSpan>)	Returns the number of bytes used to represent any expression.
DataLength(DbFunctions, String)	Returns the number of bytes used to represent any expression.
DateDiffDay(DbFunctions, DateOnly, DateOnly)	Counts the number of day boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(day, @startDate, @endDate)`.
DateDiffDay(DbFunctions, DateTime, DateTime)	Counts the number of day boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(day, @startDate, @endDate)`.
DateDiffDay(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of day boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(day, @startDate, @endDate)`.
DateDiffDay(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of day boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(day, @startDate, @endDate)`.
DateDiffDay(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of day boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(day, @startDate, @endDate)`.
DateDiffDay(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of day boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(day, @startDate, @endDate)`.
DateDiffHour(DbFunctions, DateOnly, DateOnly)	Counts the number of hour boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(hour, @startDate, @endDate)`.
DateDiffHour(DbFunctions, DateTime, DateTime)	Counts the number of hour boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(hour, @startDate, @endDate)`.
DateDiffHour(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of hour boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(hour, @startDate, @endDate)`.
DateDiffHour(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of hour boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(hour, @startDate, @endDate)`.
DateDiffHour(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of hour boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(hour, @startDate, @endDate)`.
DateDiffHour(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of hour boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(hour, @startDate, @endDate)`.
DateDiffHour(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)	Counts the number of hour boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(hour, @startTime, @endTime)`.
DateDiffHour(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)	Counts the number of hour boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(hour, @startTimeSpan, @endTimeSpan)`.
DateDiffHour(DbFunctions, TimeOnly, TimeOnly)	Counts the number of hour boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(hour, @startTime, @endTime)`.
DateDiffHour(DbFunctions, TimeSpan, TimeSpan)	Counts the number of hour boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(hour, @startTimeSpan, @endTimeSpan)`.
DateDiffMicrosecond(DbFunctions, DateOnly, DateOnly)	Counts the number of microsecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startDate, @endDate)`.
DateDiffMicrosecond(DbFunctions, DateTime, DateTime)	Counts the number of microsecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startDate, @endDate)`.
DateDiffMicrosecond(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of microsecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startDate, @endDate)`.
DateDiffMicrosecond(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of microsecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startDate, @endDate)`.
DateDiffMicrosecond(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of microsecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startDate, @endDate)`.
DateDiffMicrosecond(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of microsecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startDate, @endDate)`.
DateDiffMicrosecond(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)	Counts the number of microsecond boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startTime, @endTime)`.
DateDiffMicrosecond(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)	Counts the number of microsecond boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startTimeSpan, @endTimeSpan)`.
DateDiffMicrosecond(DbFunctions, TimeOnly, TimeOnly)	Counts the number of microsecond boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startTime, @endTime)`.
DateDiffMicrosecond(DbFunctions, TimeSpan, TimeSpan)	Counts the number of microsecond boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(microsecond, @startTimeSpan, @endTimeSpan)`.
DateDiffMillisecond(DbFunctions, DateOnly, DateOnly)	Counts the number of millisecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startDate, @endDate)`.
DateDiffMillisecond(DbFunctions, DateTime, DateTime)	Counts the number of millisecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startDate, @endDate)`.
DateDiffMillisecond(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of millisecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startDate, @endDate)`.
DateDiffMillisecond(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of millisecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startDate, @endDate)`.
DateDiffMillisecond(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of millisecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startDate, @endDate)`.
DateDiffMillisecond(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of millisecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startDate, @endDate)`.
DateDiffMillisecond(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)	Counts the number of millisecond boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startTime, @endTime)`.
DateDiffMillisecond(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)	Counts the number of millisecond boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startTimeSpan, @endTimeSpan)`.
DateDiffMillisecond(DbFunctions, TimeOnly, TimeOnly)	Counts the number of millisecond boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startTime, @endTime)`.
DateDiffMillisecond(DbFunctions, TimeSpan, TimeSpan)	Counts the number of millisecond boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(millisecond, @startTimeSpan, @endTimeSpan)`.
DateDiffMinute(DbFunctions, DateOnly, DateOnly)	Counts the number of minute boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(minute, @startDate, @endDate)`.
DateDiffMinute(DbFunctions, DateTime, DateTime)	Counts the number of minute boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(minute, @startDate, @endDate)`.
DateDiffMinute(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of minute boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(minute, @startDate, @endDate)`.
DateDiffMinute(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of minute boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(minute, @startDate, @endDate)`.
DateDiffMinute(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of minute boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(minute, @startDate, @endDate)`.
DateDiffMinute(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of minute boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(minute, @startDate, @endDate)`.
DateDiffMinute(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)	Counts the number of minute boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(minute, @startTime, @endTime)`.
DateDiffMinute(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)	Counts the number of minute boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(minute, @startTimeSpan, @endTimeSpan)`.
DateDiffMinute(DbFunctions, TimeOnly, TimeOnly)	Counts the number of minute boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(minute, @startTime, @endTime)`.
DateDiffMinute(DbFunctions, TimeSpan, TimeSpan)	Counts the number of minute boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(minute, @startTimeSpan, @endTimeSpan)`.
DateDiffMonth(DbFunctions, DateOnly, DateOnly)	Counts the number of month boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(month, @startDate, @endDate)`.
DateDiffMonth(DbFunctions, DateTime, DateTime)	Counts the number of month boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(month, @startDate, @endDate)`.
DateDiffMonth(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of month boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(month, @startDate, @endDate)`.
DateDiffMonth(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of month boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(month, @startDate, @endDate)`.
DateDiffMonth(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of month boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(month, @startDate, @endDate)`.
DateDiffMonth(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of month boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(month, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, DateOnly, DateOnly)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, DateTime, DateTime)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of nanosecond boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startDate, @endDate)`.
DateDiffNanosecond(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)	Counts the number of nanosecond boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startTime, @endTime)`.
DateDiffNanosecond(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)	Counts the number of nanosecond boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startTimeSpan, @endTimeSpan)`.
DateDiffNanosecond(DbFunctions, TimeOnly, TimeOnly)	Counts the number of nanosecond boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startTime, @endTime)`.
DateDiffNanosecond(DbFunctions, TimeSpan, TimeSpan)	Counts the number of nanosecond boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(nanosecond, @startTimeSpan, @endTimeSpan)`.
DateDiffSecond(DbFunctions, DateOnly, DateOnly)	Counts the number of second boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(second, @startDate, @endDate)`.
DateDiffSecond(DbFunctions, DateTime, DateTime)	Counts the number of second boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(second, @startDate, @endDate)`.
DateDiffSecond(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of second boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(second, @startDate, @endDate)`.
DateDiffSecond(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of second boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(second, @startDate, @endDate)`.
DateDiffSecond(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of second boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(second, @startDate, @endDate)`.
DateDiffSecond(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of second boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(second, @startDate, @endDate)`.
DateDiffSecond(DbFunctions, Nullable<TimeOnly>, Nullable<TimeOnly>)	Counts the number of second boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(second, @startTime, @endTime)`.
DateDiffSecond(DbFunctions, Nullable<TimeSpan>, Nullable<TimeSpan>)	Counts the number of second boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(second, @startTimeSpan, @endTimeSpan)`.
DateDiffSecond(DbFunctions, TimeOnly, TimeOnly)	Counts the number of second boundaries crossed between the `startTime` and `endTime`. Corresponds to SQL Server's `DATEDIFF(second, @startTime, @endTime)`.
DateDiffSecond(DbFunctions, TimeSpan, TimeSpan)	Counts the number of second boundaries crossed between the `startTimeSpan` and `endTimeSpan`. Corresponds to SQL Server's `DATEDIFF(second, @startTimeSpan, @endTimeSpan)`.
DateDiffWeek(DbFunctions, DateOnly, DateOnly)	Counts the number of week boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(week, @startDate, @endDate)`.
DateDiffWeek(DbFunctions, DateTime, DateTime)	Counts the number of week boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(week, @startDate, @endDate)`.
DateDiffWeek(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of week boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(week, @startDate, @endDate)`.
DateDiffWeek(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of week boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(week, @startDate, @endDate)`.
DateDiffWeek(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of week boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(week, @startDate, @endDate)`.
DateDiffWeek(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of week boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(week, @startDate, @endDate)`.
DateDiffYear(DbFunctions, DateOnly, DateOnly)	Counts the number of year boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(year, @startDate, @endDate)`.
DateDiffYear(DbFunctions, DateTime, DateTime)	Counts the number of year boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(year, @startDate, @endDate)`.
DateDiffYear(DbFunctions, DateTimeOffset, DateTimeOffset)	Counts the number of year boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(year, @startDate, @endDate)`.
DateDiffYear(DbFunctions, Nullable<DateOnly>, Nullable<DateOnly>)	Counts the number of year boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(year, @startDate, @endDate)`.
DateDiffYear(DbFunctions, Nullable<DateTime>, Nullable<DateTime>)	Counts the number of year boundaries crossed between `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(year, @startDate, @endDate)`.
DateDiffYear(DbFunctions, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)	Counts the number of year boundaries crossed between the `startDate` and `endDate`. Corresponds to SQL Server's `DATEDIFF(year, @startDate, @endDate)`.
DateFromParts(DbFunctions, Int32, Int32, Int32)	Initializes a new instance of the DateTime structure to the specified year, month, day. Corresponds to SQL Server's `DATEFROMPARTS(year, month, day)`.
DateTime2FromParts(DbFunctions, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32)	Initializes a new instance of the DateTime structure to the specified year, month, day, hour, minute, second, fractions, and precision. Corresponds to SQL Server's `DATETIME2FROMPARTS(year, month, day, hour, minute, seconds, fractions, precision)`.
DateTimeFromParts(DbFunctions, Int32, Int32, Int32, Int32, Int32, Int32, Int32)	Initializes a new instance of the DateTime structure to the specified year, month, day, hour, minute, second, and millisecond. Corresponds to SQL Server's `DATETIMEFROMPARTS(year, month, day, hour, minute, second, millisecond)`.
DateTimeOffsetFromParts(DbFunctions, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32, Int32)	Initializes a new instance of the DateTimeOffset structure to the specified year, month, day, hour, minute, second, fractions, hourOffset, minuteOffset and precision. Corresponds to SQL Server's `DATETIMEOFFSETFROMPARTS(year, month, day, hour, minute, seconds, fractions, hour_offset, minute_offset, precision)` .
FreeText(DbFunctions, Object, String)	A DbFunction method stub that can be used in LINQ queries to target the SQL Server `FREETEXT` store function.
FreeText(DbFunctions, Object, String, Int32)	A DbFunction method stub that can be used in LINQ queries to target the SQL Server `FREETEXT` store function.
FreeText(DbFunctions, String, String)	A DbFunction method stub that can be used in LINQ queries to target the SQL Server FREETEXT store function.
FreeText(DbFunctions, String, String, Int32)	A DbFunction method stub that can be used in LINQ queries to target the SQL Server FREETEXT store function.
IsDate(DbFunctions, String)	Validate if the given string is a valid date. Corresponds to SQL Server's `ISDATE('date')`.
IsNumeric(DbFunctions, String)	Validate if the given string is a valid numeric. Corresponds to the SQL Server `ISNUMERIC(expression)`.
SmallDateTimeFromParts(DbFunctions, Int32, Int32, Int32, Int32, Int32)	Initializes a new instance of the DateTime structure to the specified year, month, day, hour and minute. Corresponds to SQL Server's `SMALLDATETIMEFROMPARTS(year, month, day, hour, minute)`.
StandardDeviationPopulation(DbFunctions, IEnumerable<Byte>)	Returns the population standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEVP`.
StandardDeviationPopulation(DbFunctions, IEnumerable<Decimal>)	Returns the population standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEVP`.
StandardDeviationPopulation(DbFunctions, IEnumerable<Double>)	Returns the population standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEVP`.
StandardDeviationPopulation(DbFunctions, IEnumerable<Int16>)	Returns the population standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEVP`.
StandardDeviationPopulation(DbFunctions, IEnumerable<Int32>)	Returns the population standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEVP`.
StandardDeviationPopulation(DbFunctions, IEnumerable<Int64>)	Returns the population standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEVP`.
StandardDeviationPopulation(DbFunctions, IEnumerable<Single>)	Returns the population standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEVP`.
StandardDeviationSample(DbFunctions, IEnumerable<Byte>)	Returns the sample standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEV`.
StandardDeviationSample(DbFunctions, IEnumerable<Decimal>)	Returns the sample standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEV`.
StandardDeviationSample(DbFunctions, IEnumerable<Double>)	Returns the sample standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEV`.
StandardDeviationSample(DbFunctions, IEnumerable<Int16>)	Returns the sample standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEV`.
StandardDeviationSample(DbFunctions, IEnumerable<Int32>)	Returns the sample standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEV`.
StandardDeviationSample(DbFunctions, IEnumerable<Int64>)	Returns the sample standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEV`.
StandardDeviationSample(DbFunctions, IEnumerable<Single>)	Returns the sample standard deviation of all values in the specified expression. Corresponds to SQL Server's `STDEV`.
TimeFromParts(DbFunctions, Int32, Int32, Int32, Int32, Int32)	Initializes a new instance of the TimeSpan structure to the specified hour, minute, second, fractions, and precision. Corresponds to SQL Server's `TIMEFROMPARTS(hour, minute, seconds, fractions, precision)`.
VariancePopulation(DbFunctions, IEnumerable<Byte>)	Returns the population variance of all values in the specified expression. Corresponds to SQL Server's `VARP`.
VariancePopulation(DbFunctions, IEnumerable<Decimal>)	Returns the population variance of all values in the specified expression. Corresponds to SQL Server's `VARP`.
VariancePopulation(DbFunctions, IEnumerable<Double>)	Returns the population variance of all values in the specified expression. Corresponds to SQL Server's `VARP`.
VariancePopulation(DbFunctions, IEnumerable<Int16>)	Returns the population variance of all values in the specified expression. Corresponds to SQL Server's `VARP`.
VariancePopulation(DbFunctions, IEnumerable<Int32>)	Returns the population variance of all values in the specified expression. Corresponds to SQL Server's `VARP`.
VariancePopulation(DbFunctions, IEnumerable<Int64>)	Returns the population variance of all values in the specified expression. Corresponds to SQL Server's `VARP`.
VariancePopulation(DbFunctions, IEnumerable<Single>)	Returns the population variance of all values in the specified expression. Corresponds to SQL Server's `VARP`.
VarianceSample(DbFunctions, IEnumerable<Byte>)	Returns the sample variance of all values in the specified expression. Corresponds to SQL Server's `VAR`.
VarianceSample(DbFunctions, IEnumerable<Decimal>)	Returns the sample variance of all values in the specified expression. Corresponds to SQL Server's `VAR`.
VarianceSample(DbFunctions, IEnumerable<Double>)	Returns the sample variance of all values in the specified expression. Corresponds to SQL Server's `VAR`.
VarianceSample(DbFunctions, IEnumerable<Int16>)	Returns the sample variance of all values in the specified expression. Corresponds to SQL Server's `VAR`.
VarianceSample(DbFunctions, IEnumerable<Int32>)	Returns the sample variance of all values in the specified expression. Corresponds to SQL Server's `VAR`.
VarianceSample(DbFunctions, IEnumerable<Int64>)	Returns the sample variance of all values in the specified expression. Corresponds to SQL Server's `VAR`.
VarianceSample(DbFunctions, IEnumerable<Single>)	Returns the sample variance of all values in the specified expression. Corresponds to SQL Server's `VAR`.

Applies to

DbFunctions Class

Definition

Remarks

Extension Methods

Applies to

Feedback

Additional resources