SqlServerDbFunctionsExtensions Class

Definition

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 static class SqlServerDbFunctionsExtensions
type SqlServerDbFunctionsExtensions = class
Public Module SqlServerDbFunctionsExtensions
Inheritance
SqlServerDbFunctionsExtensions

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Methods

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, 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.

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).

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.

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