SqlServerDbFunctionsExtensions.Contains Method
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
| Contains(DbFunctions, Object, String) |
A DbFunction method stub that can be used in LINQ queries to target the SQL Server |
| 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(DbFunctions, String, String, Int32) |
A DbFunction method stub that can be used in LINQ queries to target the SQL Server CONTAINS store function. |
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 BooleanParameters
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
Entity Framework Core 9.0 and other versions
| Product | Versions |
|---|---|
| Entity Framework Core | 6.0, 7.0, 8.0, 9.0 |
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 BooleanParameters
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
Entity Framework Core 5.0 and other versions
| Product | Versions |
|---|---|
| Entity Framework Core | 2.2, 3.0, 3.1, 5.0 |
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 BooleanParameters
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
Entity Framework Core 9.0 and other versions
| Product | Versions |
|---|---|
| Entity Framework Core | 6.0, 7.0, 8.0, 9.0 |
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 BooleanParameters
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
Entity Framework Core 5.0 and other versions
| Product | Versions |
|---|---|
| Entity Framework Core | 2.2, 3.0, 3.1, 5.0 |
Entity Framework feedback
Entity Framework is an open source project. Select a link to provide feedback: