Export (0) Print
Expand All

SqlMethods Class

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

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

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

public static class SqlMethods

  NameDescription
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffDay(DateTime, DateTime)Counts the number of day boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffDay(Nullable<DateTime>, Nullable<DateTime>)Counts the number of day boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffDay(DateTimeOffset, DateTimeOffset)Counts the number of day boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffDay(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of day boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffHour(DateTime, DateTime)Counts the number of hour boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffHour(Nullable<DateTime>, Nullable<DateTime>)Counts the number of hour boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffHour(DateTimeOffset, DateTimeOffset)Counts the number of hour boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffHour(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of hour boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMicrosecond(DateTime, DateTime)Counts the number of microsecond boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMicrosecond(Nullable<DateTime>, Nullable<DateTime>)Counts the number of microsecond boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMicrosecond(DateTimeOffset, DateTimeOffset)Counts the number of microsecond boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMicrosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of microsecond boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMillisecond(DateTime, DateTime)Counts the number of millisecond boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMillisecond(Nullable<DateTime>, Nullable<DateTime>)Counts the number of millisecond boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMillisecond(DateTimeOffset, DateTimeOffset)Counts the number of millisecond boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMillisecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of millisecond boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMinute(DateTime, DateTime)Counts the number of minute boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMinute(Nullable<DateTime>, Nullable<DateTime>)Counts the number of minute boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMinute(DateTimeOffset, DateTimeOffset)Counts the number of minute boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMinute(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of minute boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMonth(DateTime, DateTime)Counts the number of month boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMonth(Nullable<DateTime>, Nullable<DateTime>)Counts the number of month boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMonth(DateTimeOffset, DateTimeOffset)Counts the number of month boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffMonth(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of month boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffNanosecond(DateTime, DateTime)Counts the number of nanosecond boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffNanosecond(Nullable<DateTime>, Nullable<DateTime>)Counts the number of nanosecond boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffNanosecond(DateTimeOffset, DateTimeOffset)Counts the number of nanosecond boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffNanosecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of nanosecond boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffSecond(DateTime, DateTime)Counts the number of second boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffSecond(Nullable<DateTime>, Nullable<DateTime>)Counts the number of second boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffSecond(DateTimeOffset, DateTimeOffset)Counts the number of second boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffSecond(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of second boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffYear(DateTime, DateTime)Counts the number of year boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffYear(Nullable<DateTime>, Nullable<DateTime>)Counts the number of year boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffYear(DateTimeOffset, DateTimeOffset)Counts the number of year boundaries between two non-nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneDateDiffYear(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>)Counts the number of year boundaries between two nullable dates.
Public methodStatic memberSupported by Silverlight for Windows PhoneLike(String, String)Determines whether a specific character string matches a specified pattern. This method is currently only supported in LINQ to SQL queries.
Public methodStatic memberSupported by Silverlight for Windows PhoneLike(String, String, Char)Determines whether a specific character string matches a specified pattern. This method is currently only supported in LINQ to SQL queries.
Top

Silverlight for Windows Phone

Supported in: Windows Phone OS 7.1

For a list of the operating systems and browsers that are supported by Silverlight, see Supported Operating Systems and Browsers.

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

Community Additions

Show:
© 2014 Microsoft