This documentation is archived and is not being maintained.

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.

Windows 7, Windows Vista, Windows XP SP2, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5