SqlServerDbFunctionsExtensions.FreeText Method

  • Reference

Definition

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

Overloads

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, 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 store function.
FreeText(DbFunctions, String, String)

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

FreeText(DbFunctions, String, String, Int32)

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 Boolean

Parameters

_
DbFunctions

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

Boolean

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

FreeText(DbFunctions, Object, String, Int32)

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 Boolean

Parameters

_
DbFunctions

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

Boolean

Remarks

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

Applies to

FreeText(DbFunctions, Object, String)

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 Boolean

Parameters

_
DbFunctions

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

Boolean

Remarks

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

Applies to

FreeText(DbFunctions, String, String)

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 Boolean

Parameters

_
DbFunctions

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

Boolean

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