SqlMethods Class
[ This article is for Windows Phone 8 developers. If you’re developing for Windows 10, see the latest documentation. ]
Provides methods that correspond to SQL Server functions. Methods in the SqlMethods class are only supported in LINQ to SQL queries.
Assembly: System.Data.Linq (in System.Data.Linq.dll)
| Name | Description | |
|---|---|---|
  | DateDiffDay(DateTime, DateTime) | Counts the number of day boundaries between two non-nullable dates. |
| DateDiffDay(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of day boundaries between two nullable dates. |
| DateDiffDay(DateTimeOffset, DateTimeOffset) | Counts the number of day boundaries between two non-nullable dates. |
| DateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of day boundaries between two nullable dates. |
| DateDiffHour(DateTime, DateTime) | Counts the number of hour boundaries between two non-nullable dates. |
| DateDiffHour(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of hour boundaries between two nullable dates. |
| DateDiffHour(DateTimeOffset, DateTimeOffset) | Counts the number of hour boundaries between two non-nullable dates. |
| DateDiffHour(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of hour boundaries between two nullable dates. |
| DateDiffMicrosecond(DateTime, DateTime) | Counts the number of microsecond boundaries between two non-nullable dates. |
| DateDiffMicrosecond(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of microsecond boundaries between two nullable dates. |
| DateDiffMicrosecond(DateTimeOffset, DateTimeOffset) | Counts the number of microsecond boundaries between two non-nullable dates. |
| DateDiffMicrosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of microsecond boundaries between two nullable dates. |
| DateDiffMillisecond(DateTime, DateTime) | Counts the number of millisecond boundaries between two non-nullable dates. |
| DateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of millisecond boundaries between two nullable dates. |
| DateDiffMillisecond(DateTimeOffset, DateTimeOffset) | Counts the number of millisecond boundaries between two non-nullable dates. |
| DateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of millisecond boundaries between two nullable dates. |
| DateDiffMinute(DateTime, DateTime) | Counts the number of minute boundaries between two non-nullable dates. |
| DateDiffMinute(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of minute boundaries between two nullable dates. |
| DateDiffMinute(DateTimeOffset, DateTimeOffset) | Counts the number of minute boundaries between two non-nullable dates. |
| DateDiffMinute(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of minute boundaries between two nullable dates. |
| DateDiffMonth(DateTime, DateTime) | Counts the number of month boundaries between two non-nullable dates. |
| DateDiffMonth(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of month boundaries between two nullable dates. |
| DateDiffMonth(DateTimeOffset, DateTimeOffset) | Counts the number of month boundaries between two non-nullable dates. |
| DateDiffMonth(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of month boundaries between two nullable dates. |
| DateDiffNanosecond(DateTime, DateTime) | Counts the number of nanosecond boundaries between two non-nullable dates. |
| DateDiffNanosecond(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of nanosecond boundaries between two nullable dates. |
| DateDiffNanosecond(DateTimeOffset, DateTimeOffset) | Counts the number of nanosecond boundaries between two non-nullable dates. |
| DateDiffNanosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of nanosecond boundaries between two nullable dates. |
| DateDiffSecond(DateTime, DateTime) | Counts the number of second boundaries between two non-nullable dates. |
| DateDiffSecond(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of second boundaries between two nullable dates. |
| DateDiffSecond(DateTimeOffset, DateTimeOffset) | Counts the number of second boundaries between two non-nullable dates. |
| DateDiffSecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of second boundaries between two nullable dates. |
| DateDiffYear(DateTime, DateTime) | Counts the number of year boundaries between two non-nullable dates. |
| DateDiffYear(Nullable<DateTime>, Nullable<DateTime>) | Counts the number of year boundaries between two nullable dates. |
| DateDiffYear(DateTimeOffset, DateTimeOffset) | Counts the number of year boundaries between two non-nullable dates. |
| DateDiffYear(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) | Counts the number of year boundaries between two nullable dates. |
| 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) | Determines whether a specific character string matches a specified pattern. This method is currently only supported in LINQ to SQL queries. |
Show: