Share via


SqlServerDbFunctionsExtensions.Contains Method

Definition

Overloads

Contains(DbFunctions, Object, String)

A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.

Contains(DbFunctions, String, String)

A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.

Contains(DbFunctions, Object, String, Int32)

A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.

Contains(DbFunctions, String, String, Int32)

A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.

Contains(DbFunctions, Object, String)

Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs

A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.

public static bool Contains (this Microsoft.EntityFrameworkCore.DbFunctions _, object propertyReference, string searchCondition);
static member Contains : Microsoft.EntityFrameworkCore.DbFunctions * obj * string -> bool
<Extension()>
Public Function Contains (_ As DbFunctions, propertyReference As Object, searchCondition As String) As Boolean

Parameters

_
DbFunctions

The DbFunctions instance.

propertyReference
Object

The property on which the search will be performed.

searchCondition
String

The text that will be searched for in the property and the condition for a match.

Returns

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Applies to

Contains(DbFunctions, String, String)

Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs

A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.

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

Parameters

_
DbFunctions

DbFunctions instance

propertyReference
String

The property on which the search will be performed.

searchCondition
String

The text that will be searched for in the property and the condition for a match.

Returns

Remarks

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

Contains(DbFunctions, Object, String, Int32)

Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs

A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.

public static bool Contains (this Microsoft.EntityFrameworkCore.DbFunctions _, object propertyReference, string searchCondition, int languageTerm);
static member Contains : Microsoft.EntityFrameworkCore.DbFunctions * obj * string * int -> bool
<Extension()>
Public Function Contains (_ As DbFunctions, propertyReference As Object, searchCondition As String, languageTerm As Integer) As Boolean

Parameters

_
DbFunctions

The DbFunctions instance.

propertyReference
Object

The property on which the search will be performed.

searchCondition
String

The text that will be searched for in the property and the condition for a match.

languageTerm
Int32

A Language ID from the sys.syslanguages table.

Returns

Remarks

See Database functions, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

Applies to

Contains(DbFunctions, String, String, Int32)

Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs
Source:
SqlServerDbFunctionsExtensions.cs

A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function.

public static bool Contains (this Microsoft.EntityFrameworkCore.DbFunctions _, string propertyReference, string searchCondition, int languageTerm);
static member Contains : Microsoft.EntityFrameworkCore.DbFunctions * string * string * int -> bool
<Extension()>
Public Function Contains (_ As DbFunctions, propertyReference As String, searchCondition As String, languageTerm As Integer) As Boolean

Parameters

_
DbFunctions

DbFunctions instance

propertyReference
String

The property on which the search will be performed.

searchCondition
String

The text that will be searched for in the property and the condition for a match.

languageTerm
Int32

A Language ID from the sys.syslanguages table.

Returns

Remarks

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