Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Like Method (String, String, Char)
Collapse the table of content
Expand the table of content

SqlMethods.Like Method (String, String, Char)

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)

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


Type: System.String
The string to be searched for a match.
Type: System.String
The pattern, which may include wildcard characters, to match in matchExpression.
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.

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.

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.

Community Additions

© 2015 Microsoft