SqlMethods Class

 

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

Namespace:   System.Data.Linq.SqlClient
Assembly:  System.Data.Linq (in System.Data.Linq.dll)

System.Object
  System.Data.Linq.SqlClient.SqlMethods

public static class SqlMethods

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticDateDiffDay(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffDay(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffDay(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of day boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of day boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffHour(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffHour(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffHour(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of hour boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffHour(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of hour boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMicrosecond(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMicrosecond(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMicrosecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of microsecond boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMicrosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of microsecond boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMillisecond(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMillisecond(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of millisecond boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of millisecond boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMinute(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMinute(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMinute(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of minute boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMinute(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of minute boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMonth(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMonth(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMonth(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of month boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffMonth(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of month boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffNanosecond(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffNanosecond(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffNanosecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of nanosecond boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffNanosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of nanosecond boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffSecond(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffSecond(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffSecond(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of second boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffSecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of second boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffYear(DateTime, DateTime)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffYear(DateTimeOffset, DateTimeOffset)

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

System_CAPS_pubmethodSystem_CAPS_staticDateDiffYear(Nullable<DateTime>, Nullable<DateTime>)

Counts the number of year boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticDateDiffYear(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)

Counts the number of year boundaries between two nullable dates.

System_CAPS_pubmethodSystem_CAPS_staticLike(String, String)

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

System_CAPS_pubmethodSystem_CAPS_staticLike(String, String, Char)

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

.NET Framework
Available since 3.5
Windows Phone Silverlight
Available since 7.1

Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show: