SqlServerDbFunctionsExtensions.FreeText 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.
| FreeText(DbFunctions, Object, String, Int32) |
A DbFunction method stub that can be used in LINQ queries to target the SQL Server |
| FreeText(DbFunctions, String, String, Int32) |
A DbFunction method stub that can be used in LINQ queries to target the SQL Server FREETEXT store function. |
| FreeText(DbFunctions, Object, String) |
A DbFunction method stub that can be used in LINQ queries to target the SQL Server |
| FreeText(DbFunctions, String, String) |
A DbFunction method stub that can be used in LINQ queries to target the SQL Server FREETEXT store function. |
A DbFunction method stub that can be used in LINQ queries to target the SQL Server FREETEXT store function.
public static bool FreeText (this Microsoft.EntityFrameworkCore.DbFunctions _, object propertyReference, string freeText, int languageTerm);static member FreeText : Microsoft.EntityFrameworkCore.DbFunctions * obj * string * int -> bool<Extension()>
Public Function FreeText (_ As DbFunctions, propertyReference As Object, freeText As String, languageTerm As Integer) As BooleanParameters
The DbFunctions instance.
- propertyReference
- Object
The property on which the search will be performed.
- freeText
- String
The text that will be searched for in the property.
- 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 FREETEXT store function.
public static bool FreeText (this Microsoft.EntityFrameworkCore.DbFunctions _, string propertyReference, string freeText, int languageTerm);static member FreeText : Microsoft.EntityFrameworkCore.DbFunctions * string * string * int -> bool<Extension()>
Public Function FreeText (_ As DbFunctions, propertyReference As String, freeText As String, languageTerm As Integer) As BooleanParameters
DbFunctions instance
- propertyReference
- String
The property on which the search will be performed.
- freeText
- String
The text that will be searched for in the property.
- 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.1, 2.2, 3.0, 3.1, 5.0 |
A DbFunction method stub that can be used in LINQ queries to target the SQL Server FREETEXT store function.
public static bool FreeText (this Microsoft.EntityFrameworkCore.DbFunctions _, object propertyReference, string freeText);static member FreeText : Microsoft.EntityFrameworkCore.DbFunctions * obj * string -> bool<Extension()>
Public Function FreeText (_ As DbFunctions, propertyReference As Object, freeText As String) As BooleanParameters
The DbFunctions instance.
- propertyReference
- Object
The property on which the search will be performed.
- freeText
- String
The text that will be searched for in the property.
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 FREETEXT store function.
public static bool FreeText (this Microsoft.EntityFrameworkCore.DbFunctions _, string propertyReference, string freeText);static member FreeText : Microsoft.EntityFrameworkCore.DbFunctions * string * string -> bool<Extension()>
Public Function FreeText (_ As DbFunctions, propertyReference As String, freeText As String) As BooleanParameters
DbFunctions instance
- propertyReference
- String
The property on which the search will be performed.
- freeText
- String
The text that will be searched for in the property.
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.1, 2.2, 3.0, 3.1, 5.0 |
Entity Framework feedback
Entity Framework is an open source project. Select a link to provide feedback: