SqlMethods Class
.NET Framework 4.5
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)
| 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. |
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
