SqlMethods SqlMethods SqlMethods SqlMethods Class

Definition

Provides methods that correspond to SQL Server functions. Methods in the SqlMethods class are only supported in LINQ to SQL queries.

public ref class SqlMethods abstract sealed
public static class SqlMethods
type SqlMethods = class
Public Class SqlMethods
Inheritance
SqlMethodsSqlMethodsSqlMethodsSqlMethods

Methods

DateDiffDay(DateTime, DateTime) DateDiffDay(DateTime, DateTime) DateDiffDay(DateTime, DateTime) DateDiffDay(DateTime, DateTime)

Counts the number of day boundaries between two non-nullable dates.

DateDiffDay(DateTimeOffset, DateTimeOffset) DateDiffDay(DateTimeOffset, DateTimeOffset) DateDiffDay(DateTimeOffset, DateTimeOffset) DateDiffDay(DateTimeOffset, DateTimeOffset)

Counts the number of day boundaries between two non-nullable dates.

DateDiffDay(Nullable<DateTime>, Nullable<DateTime>) DateDiffDay(Nullable<DateTime>, Nullable<DateTime>) DateDiffDay(Nullable<DateTime>, Nullable<DateTime>) DateDiffDay(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of day boundaries between two nullable dates.

DateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of day boundaries between two nullable dates.

DateDiffHour(DateTime, DateTime) DateDiffHour(DateTime, DateTime) DateDiffHour(DateTime, DateTime) DateDiffHour(DateTime, DateTime)

Counts the number of hour boundaries between two non-nullable dates.

DateDiffHour(DateTimeOffset, DateTimeOffset) DateDiffHour(DateTimeOffset, DateTimeOffset) DateDiffHour(DateTimeOffset, DateTimeOffset) DateDiffHour(DateTimeOffset, DateTimeOffset)

Counts the number of hour boundaries between two non-nullable dates.

DateDiffHour(Nullable<DateTime>, Nullable<DateTime>) DateDiffHour(Nullable<DateTime>, Nullable<DateTime>) DateDiffHour(Nullable<DateTime>, Nullable<DateTime>) DateDiffHour(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of hour boundaries between two nullable dates.

DateDiffHour(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffHour(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffHour(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffHour(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of hour boundaries between two nullable dates.

DateDiffMicrosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMicrosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMicrosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMicrosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of microsecond boundaries between two nullable dates.

DateDiffMicrosecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffMicrosecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffMicrosecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffMicrosecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of microsecond boundaries between two nullable dates.

DateDiffMicrosecond(DateTime, DateTime) DateDiffMicrosecond(DateTime, DateTime) DateDiffMicrosecond(DateTime, DateTime) DateDiffMicrosecond(DateTime, DateTime)

Counts the number of microsecond boundaries between two non-nullable dates.

DateDiffMicrosecond(DateTimeOffset, DateTimeOffset) DateDiffMicrosecond(DateTimeOffset, DateTimeOffset) DateDiffMicrosecond(DateTimeOffset, DateTimeOffset) DateDiffMicrosecond(DateTimeOffset, DateTimeOffset)

Counts the number of microsecond boundaries between two non-nullable dates.

DateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of millisecond boundaries between two nullable dates.

DateDiffMillisecond(DateTime, DateTime) DateDiffMillisecond(DateTime, DateTime) DateDiffMillisecond(DateTime, DateTime) DateDiffMillisecond(DateTime, DateTime)

Counts the number of millisecond boundaries between two non-nullable dates.

DateDiffMillisecond(DateTimeOffset, DateTimeOffset) DateDiffMillisecond(DateTimeOffset, DateTimeOffset) DateDiffMillisecond(DateTimeOffset, DateTimeOffset) DateDiffMillisecond(DateTimeOffset, DateTimeOffset)

Counts the number of millisecond boundaries between two non-nullable dates.

DateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of millisecond boundaries between two nullable dates.

DateDiffMinute(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMinute(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMinute(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMinute(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of minute boundaries between two nullable dates.

DateDiffMinute(Nullable<DateTime>, Nullable<DateTime>) DateDiffMinute(Nullable<DateTime>, Nullable<DateTime>) DateDiffMinute(Nullable<DateTime>, Nullable<DateTime>) DateDiffMinute(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of minute boundaries between two nullable dates.

DateDiffMinute(DateTime, DateTime) DateDiffMinute(DateTime, DateTime) DateDiffMinute(DateTime, DateTime) DateDiffMinute(DateTime, DateTime)

Counts the number of minute boundaries between two non-nullable dates.

DateDiffMinute(DateTimeOffset, DateTimeOffset) DateDiffMinute(DateTimeOffset, DateTimeOffset) DateDiffMinute(DateTimeOffset, DateTimeOffset) DateDiffMinute(DateTimeOffset, DateTimeOffset)

Counts the number of minute boundaries between two non-nullable dates.

DateDiffMonth(DateTime, DateTime) DateDiffMonth(DateTime, DateTime) DateDiffMonth(DateTime, DateTime) DateDiffMonth(DateTime, DateTime)

Counts the number of month boundaries between two non-nullable dates.

DateDiffMonth(DateTimeOffset, DateTimeOffset) DateDiffMonth(DateTimeOffset, DateTimeOffset) DateDiffMonth(DateTimeOffset, DateTimeOffset) DateDiffMonth(DateTimeOffset, DateTimeOffset)

Counts the number of month boundaries between two non-nullable dates.

DateDiffMonth(Nullable<DateTime>, Nullable<DateTime>) DateDiffMonth(Nullable<DateTime>, Nullable<DateTime>) DateDiffMonth(Nullable<DateTime>, Nullable<DateTime>) DateDiffMonth(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of month boundaries between two nullable dates.

DateDiffMonth(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMonth(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMonth(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffMonth(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of month boundaries between two nullable dates.

DateDiffNanosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffNanosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffNanosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffNanosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of nanosecond boundaries between two nullable dates.

DateDiffNanosecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffNanosecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffNanosecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffNanosecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of nanosecond boundaries between two nullable dates.

DateDiffNanosecond(DateTime, DateTime) DateDiffNanosecond(DateTime, DateTime) DateDiffNanosecond(DateTime, DateTime) DateDiffNanosecond(DateTime, DateTime)

Counts the number of nanosecond boundaries between two non-nullable dates.

DateDiffNanosecond(DateTimeOffset, DateTimeOffset) DateDiffNanosecond(DateTimeOffset, DateTimeOffset) DateDiffNanosecond(DateTimeOffset, DateTimeOffset) DateDiffNanosecond(DateTimeOffset, DateTimeOffset)

Counts the number of nanosecond boundaries between two non-nullable dates.

DateDiffSecond(DateTime, DateTime) DateDiffSecond(DateTime, DateTime) DateDiffSecond(DateTime, DateTime) DateDiffSecond(DateTime, DateTime)

Counts the number of second boundaries between two non-nullable dates.

DateDiffSecond(DateTimeOffset, DateTimeOffset) DateDiffSecond(DateTimeOffset, DateTimeOffset) DateDiffSecond(DateTimeOffset, DateTimeOffset) DateDiffSecond(DateTimeOffset, DateTimeOffset)

Counts the number of second boundaries between two non-nullable dates.

DateDiffSecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffSecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffSecond(Nullable<DateTime>, Nullable<DateTime>) DateDiffSecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of second boundaries between two nullable dates.

DateDiffSecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffSecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffSecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffSecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of second boundaries between two nullable dates.

DateDiffYear(Nullable<DateTime>, Nullable<DateTime>) DateDiffYear(Nullable<DateTime>, Nullable<DateTime>) DateDiffYear(Nullable<DateTime>, Nullable<DateTime>) DateDiffYear(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of year boundaries between two nullable dates.

DateDiffYear(DateTime, DateTime) DateDiffYear(DateTime, DateTime) DateDiffYear(DateTime, DateTime) DateDiffYear(DateTime, DateTime)

Counts the number of year boundaries between two non-nullable dates.

DateDiffYear(DateTimeOffset, DateTimeOffset) DateDiffYear(DateTimeOffset, DateTimeOffset) DateDiffYear(DateTimeOffset, DateTimeOffset) DateDiffYear(DateTimeOffset, DateTimeOffset)

Counts the number of year boundaries between two non-nullable dates.

DateDiffYear(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffYear(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffYear(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) DateDiffYear(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of year boundaries between two nullable dates.

Like(String, String) Like(String, String) Like(String, String) Like(String, String)

Determines whether a specific character string matches a specified pattern. This method is currently only supported in LINQ to SQL queries.

Like(String, String, Char) Like(String, String, Char) Like(String, String, Char) Like(String, String, Char)

Determines whether a specific character string matches a specified pattern. This method is currently only supported in LINQ to SQL queries.

Applies to