DbFunctionsExtensions.Like DbFunctionsExtensions.Like DbFunctionsExtensions.Like Method

Definition

Overloads

Like(DbFunctions, String, String) Like(DbFunctions, String, String) Like(DbFunctions, String, String)

An implementation of the SQL LIKE operation. On relational databases this is usually directly translated to SQL.

Note that if this function is translated into SQL, then the semantics of the comparison will depend on the database configuration. In particular, it may be either case-sensitive or case-insensitive. If this function is evaluated on the client, then it will always use a case-insensitive comparison.

Like(DbFunctions, String, String, String) Like(DbFunctions, String, String, String) Like(DbFunctions, String, String, String)

An implementation of the SQL LIKE operation. On relational databases this is usually directly translated to SQL.

Note that if this function is translated into SQL, then the semantics of the comparison will depend on the database configuration. In particular, it may be either case-sensitive or case-insensitive. If this function is evaluated on the client, then it will always use a case-insensitive comparison.

Like(DbFunctions, String, String) Like(DbFunctions, String, String) Like(DbFunctions, String, String)

An implementation of the SQL LIKE operation. On relational databases this is usually directly translated to SQL.

Note that if this function is translated into SQL, then the semantics of the comparison will depend on the database configuration. In particular, it may be either case-sensitive or case-insensitive. If this function is evaluated on the client, then it will always use a case-insensitive comparison.

public static bool Like (this Microsoft.EntityFrameworkCore.DbFunctions _, string matchExpression, string pattern);
static member Like : Microsoft.EntityFrameworkCore.DbFunctions * string * string -> bool
<Extension()>
Public Function Like (_ As DbFunctions, matchExpression As String, pattern As String) As Boolean

Parameters

_
DbFunctions DbFunctions DbFunctions

The DbFunctions instance.

matchExpression
String String String

The string that is to be matched.

pattern
String String String

The pattern which may involve wildcards %,_,[,],^.

Returns

true if there is a match.

Like(DbFunctions, String, String, String) Like(DbFunctions, String, String, String) Like(DbFunctions, String, String, String)

An implementation of the SQL LIKE operation. On relational databases this is usually directly translated to SQL.

Note that if this function is translated into SQL, then the semantics of the comparison will depend on the database configuration. In particular, it may be either case-sensitive or case-insensitive. If this function is evaluated on the client, then it will always use a case-insensitive comparison.

public static bool Like (this Microsoft.EntityFrameworkCore.DbFunctions _, string matchExpression, string pattern, string escapeCharacter);
static member Like : Microsoft.EntityFrameworkCore.DbFunctions * string * string * string -> bool
<Extension()>
Public Function Like (_ As DbFunctions, matchExpression As String, pattern As String, escapeCharacter As String) As Boolean

Parameters

_
DbFunctions DbFunctions DbFunctions

The DbFunctions instance.

matchExpression
String String String

The string that is to be matched.

pattern
String String String

The pattern which may involve wildcards %,_,[,],^.

escapeCharacter
String String String

The escape character (as a single character string) to use in front of %,_,[,],^ if they are not used as wildcards.

Returns

true if there is a match.

Applies to