DbFunctionsExtensions.Like Method

  • Reference

Definition

Namespace:
Microsoft.EntityFrameworkCore
Assembly:
Microsoft.EntityFrameworkCore.dll
Package:
Microsoft.EntityFrameworkCore v2.0.3
Package:
Microsoft.EntityFrameworkCore v2.1.11
Package:
Microsoft.EntityFrameworkCore v2.2.6
Package:
Microsoft.EntityFrameworkCore v3.0.0
Package:
Microsoft.EntityFrameworkCore v3.1.0
Package:
Microsoft.EntityFrameworkCore v5.0.0
Package:
Microsoft.EntityFrameworkCore v6.0.0
Package:
Microsoft.EntityFrameworkCore v7.0.0
Package:
Microsoft.EntityFrameworkCore v8.0.0

Overloads

Like(DbFunctions, String, String)

An implementation of the SQL LIKE operation. On relational databases this is usually directly translated to SQL.
Like(DbFunctions, String, String, String)

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

Like(DbFunctions, String, String)

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

public static bool Like (this Microsoft.EntityFrameworkCore.DbFunctions _, string matchExpression, string pattern);
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

The DbFunctions instance.

matchExpression
String

The string that is to be matched.

pattern
String

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

Returns

Boolean

true if there is a match.

Remarks

Note that the semantics of the comparison will depend on the database configuration. In particular, it may be either case-sensitive or case-insensitive.

This DbFunction method has no in-memory implementation and will throw if the query switches to client-evaluation. This can happen if the query contains one or more expressions that could not be translated to the store.

Applies to

Like(DbFunctions, String, String, String)

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

public static bool Like (this Microsoft.EntityFrameworkCore.DbFunctions _, string matchExpression, string pattern, string escapeCharacter);
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

The DbFunctions instance.

matchExpression
String

The string that is to be matched.

pattern
String

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

escapeCharacter
String

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

Returns

Boolean

true if there is a match.

Remarks

Note that the semantics of the comparison will depend on the database configuration. In particular, it may be either case-sensitive or case-insensitive.

This DbFunction method has no in-memory implementation and will throw if the query switches to client-evaluation. This can happen if the query contains one or more expressions that could not be translated to the store.

Applies to