Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

SqlServerDbFunctionsExtensions.FreeText Method

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 v10.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v6.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v7.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v8.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v9.0.0

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.

Overloads

Name Description
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, String, String)

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, Int32)

Source:
SqlServerDbFunctionsExtensions.cs
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 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

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)

Source:
SqlServerDbFunctionsExtensions.cs
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 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

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)

Source:
SqlServerDbFunctionsExtensions.cs
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 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

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)

Source:
SqlServerDbFunctionsExtensions.cs
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 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

Remarks

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

Applies to


Feedback

Was this page helpful?