SqlMethods.Like Method (String, String, Char)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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
Available since 3.5
Windows Phone Silverlight
Available since 7.1
Return to top