• Article

SqlMethods.Like Method (String, String, Char)

Microsoft Silverlight will reach end of support after October 2021. Learn more.

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

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

Syntax

'Declaration
Public Shared Function Like ( _
    matchExpression As String, _
    pattern As String, _
    escapeCharacter As Char _
) As Boolean

public static bool Like(
    string matchExpression,
    string pattern,
    char escapeCharacter
)

Parameters

  • matchExpression
    Type: System.String
    The string to be searched for a match.
  • pattern
    Type: System.String
    The pattern, which may include wildcard characters, to match in matchExpression.
  • escapeCharacter
    Type: System.Char
    The character to put in front of a wildcard character to indicate that it should be interpreted as a regular character and not as a wildcard character.

Return Value

Type: System.Boolean
true if matchExpression matches the pattern; otherwise, false.

Remarks

The SQL Server LIKE functionality cannot be exposed through translation of existing common language runtime (CLR) and .NET Framework constructs, and is unsupported outside of a LINQ to SQL context. The use of this method outside of LINQ to SQL will always throw an exception of type NotSupportedException.

Version Information

Silverlight for Windows Phone

Supported in: Windows Phone OS 7.1

Platforms

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