DbFunctions Class

Definition

Namespace:
Microsoft.EntityFrameworkCore
Assembly:
Microsoft.EntityFrameworkCore.dll
Package:
Microsoft.EntityFrameworkCore v10.0.0
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
Package:
Microsoft.EntityFrameworkCore v9.0.0
Source:
DbFunctions.cs
Source:
DbFunctions.cs
Source:
DbFunctions.cs
Source:
DbFunctions.cs
Source:
DbFunctions.cs
Source:
DbFunctions.cs
Source:
DbFunctions.cs
Source:
DbFunctions.cs
Source:
DbFunctions.cs
Source:
DbFunctions.cs

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.

[System.Runtime.CompilerServices.Nullable(0)]
public sealed class DbFunctions
public class DbFunctions
public sealed class DbFunctions
[<System.Runtime.CompilerServices.Nullable(0)>]
type DbFunctions = class
type DbFunctions = class
Public NotInheritable Class DbFunctions
Public Class DbFunctions
Inheritance
Object
DbFunctions
Attributes
NullableAttribute

Remarks

See Database functions for more information and examples.

Extension Methods

Name Description
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.
CoalesceUndefined<T>(DbFunctions, T, T)

Coalesces a Cosmos undefined value via the ?? operator.
CoalesceUndefined<T>(DbFunctions, T, T)

Coalesces a Cosmos undefined value via the ?? operator.
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'.
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, Object, 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.

Contains(DbFunctions, String, String)

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, Int32)

A DbFunction method stub that can be used in LINQ queries to target the SQL Server FREETEXT store function.
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, String, 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.

FullTextContains(DbFunctions, String, String)

Checks if the specified property contains the given keyword using full-text search.
FullTextContainsAll(DbFunctions, String, String[])

Checks if the specified property contains all the given keywords using full-text search.
FullTextContainsAny(DbFunctions, String, String[])

Checks if the specified property contains any of the given keywords using full-text search.
FullTextScore(DbFunctions, String, String[])

Returns the full-text search score for the specified property and keywords.
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.
Greatest<T>(DbFunctions, T[])

Returns the greatest value from the given list of values. Usually corresponds to the GREATEST SQL function.
Hex(DbFunctions, Byte[])

Maps to the SQLite hex function which returns a hexadecimal string representing the specified value.
IsDate(DbFunctions, String)

Validate if the given string is a valid date. Corresponds to SQL Server's ISDATE('date').
IsDefined(DbFunctions, Object)

Returns a boolean indicating if the property has been assigned a value. Corresponds to the Cosmos IS_DEFINED function.
IsDefined(DbFunctions, Object)

Returns a boolean indicating if the property has been assigned a value. Corresponds to the Cosmos IS_DEFINED function.
IsNumeric(DbFunctions, String)

Validate if the given string is a valid numeric. Corresponds to the SQL Server ISNUMERIC(expression).
Least<T>(DbFunctions, T[])

Returns the smallest value from the given list of values. Usually corresponds to the LEAST SQL function.
Like(DbFunctions, String, String, String)

An implementation of the SQL LIKE operation. On relational databases this is usually directly translated to SQL.
Like(DbFunctions, String, String)

An implementation of the SQL LIKE operation. On relational databases this is usually directly translated to SQL.
PatIndex(DbFunctions, String, String)

Returns the starting position of the first occurrence of a pattern in a specified expression, or zero if the pattern is not found, on all valid text and character data types.
Random(DbFunctions)

A random double number generator which generates a number between 0 and 1, exclusive.
Rrf(DbFunctions, Double[], Double[])

Combines scores provided by two or more specified functions.
Rrf(DbFunctions, Double[])

Combines scores provided by two or more specified functions.
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.
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.
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.
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).
Unhex(DbFunctions, String, String)

Maps to the SQLite unhex function which returns a BLOB representing decoding of the hexadecimal string.
Unhex(DbFunctions, String)

Maps to the SQLite unhex function which returns a BLOB representing decoding of the hexadecimal string.
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.
VectorDistance(DbFunctions, ReadOnlyMemory<Byte>, ReadOnlyMemory<Byte>, Boolean, DistanceFunction)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<Byte>, ReadOnlyMemory<Byte>, Boolean)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<Byte>, ReadOnlyMemory<Byte>, Nullable<Boolean>, VectorDistanceOptions)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<Byte>, ReadOnlyMemory<Byte>)

Returns the distance between two vectors, using the distance function and data type defined using IsVector(PropertyBuilder, DistanceFunction, Int32) .
VectorDistance(DbFunctions, ReadOnlyMemory<SByte>, ReadOnlyMemory<SByte>, Boolean, DistanceFunction)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<SByte>, ReadOnlyMemory<SByte>, Boolean)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<SByte>, ReadOnlyMemory<SByte>, Nullable<Boolean>, VectorDistanceOptions)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<SByte>, ReadOnlyMemory<SByte>)

Returns the distance between two vectors, using the distance function and data type defined using IsVector(PropertyBuilder, DistanceFunction, Int32) .
VectorDistance(DbFunctions, ReadOnlyMemory<Single>, ReadOnlyMemory<Single>, Boolean, DistanceFunction)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<Single>, ReadOnlyMemory<Single>, Boolean)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<Single>, ReadOnlyMemory<Single>, Nullable<Boolean>, VectorDistanceOptions)

Returns the distance between two vectors, given a distance function (aka similarity measure).
VectorDistance(DbFunctions, ReadOnlyMemory<Single>, ReadOnlyMemory<Single>)

Returns the distance between two vectors, using the distance function and data type defined using IsVector(PropertyBuilder, DistanceFunction, Int32) .
VectorDistance<T>(DbFunctions, String, SqlVector<T>, SqlVector<T>)

Calculates the distance between two vectors using a specified distance metric.

Applies to