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.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5

.NET Framework Client Profile

Supported in: 4
© 2015 Microsoft