SqlMethods Methods
[ This article is for Windows Phone 8 developers. If you’re developing for Windows 10, see the latest documentation. ]
| 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: