Class NpgsqlFullTextSearchDbFunctionsExtensions

Namespace

Microsoft.EntityFrameworkCore

Assembly

Npgsql.EntityFrameworkCore.PostgreSQL.dll

Provides CLR methods that get translated to database functions when used in LINQ to Entities queries. The methods on this class are accessed via Functions.

public static class NpgsqlFullTextSearchDbFunctionsExtensions

Inheritance

object

NpgsqlFullTextSearchDbFunctionsExtensions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

See Database functions.

Methods

ArrayToTsVector(DbFunctions, string[])

Convert lexemes to a tsvector.

public static NpgsqlTsVector ArrayToTsVector(this DbFunctions _, string[] lexemes)

Parameters

_ DbFunctions

lexemes string[]

Returns

NpgsqlTsVector

Remarks

https://www.postgresql.org/docs/current/static/functions-textsearch.html

PhraseToTsQuery(DbFunctions, string)

Produce tsquery that searches for a phrase from query ignoring punctuation.

public static NpgsqlTsQuery PhraseToTsQuery(this DbFunctions _, string query)

Parameters

_ DbFunctions

query string

Returns

NpgsqlTsQuery

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES

PhraseToTsQuery(DbFunctions, string, string)

Produce tsquery that searches for a phrase from query ignoring punctuation and using the text search configuration specified by config.

public static NpgsqlTsQuery PhraseToTsQuery(this DbFunctions _, string config, string query)

Parameters

_ DbFunctions

config string

query string

Returns

NpgsqlTsQuery

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES

PlainToTsQuery(DbFunctions, string)

Produce tsquery from query ignoring punctuation.

public static NpgsqlTsQuery PlainToTsQuery(this DbFunctions _, string query)

Parameters

_ DbFunctions

query string

Returns

NpgsqlTsQuery

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES

PlainToTsQuery(DbFunctions, string, string)

Produce tsquery from query ignoring punctuation and using the text search configuration specified by config.

public static NpgsqlTsQuery PlainToTsQuery(this DbFunctions _, string config, string query)

Parameters

_ DbFunctions

config string

query string

Returns

NpgsqlTsQuery

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES

ToTsQuery(DbFunctions, string)

Normalize words in query and convert to tsquery. If your input contains punctuation that should not be treated as text search operators, use PlainToTsQuery(DbFunctions, string) instead.

public static NpgsqlTsQuery ToTsQuery(this DbFunctions _, string query)

Parameters

_ DbFunctions

query string

Returns

NpgsqlTsQuery

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES

ToTsQuery(DbFunctions, string, string)

Normalize words in query and convert to tsquery using the text search configuration specified by config. If your input contains punctuation that should not be treated as text search operators, use PlainToTsQuery(DbFunctions, string, string) instead.

public static NpgsqlTsQuery ToTsQuery(this DbFunctions _, string config, string query)

Parameters

_ DbFunctions

config string

query string

Returns

NpgsqlTsQuery

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES

ToTsVector(DbFunctions, string)

Reduce document to tsvector.

public static NpgsqlTsVector ToTsVector(this DbFunctions _, string document)

Parameters

_ DbFunctions

document string

Returns

NpgsqlTsVector

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-DOCUMENTS

ToTsVector(DbFunctions, string, string)

Reduce document to tsvector using the text search configuration specified by config.

public static NpgsqlTsVector ToTsVector(this DbFunctions _, string config, string document)

Parameters

_ DbFunctions

config string

document string

Returns

NpgsqlTsVector

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-DOCUMENTS

Unaccent(DbFunctions, string)

Returns a new string that removes diacritics from characters in the given text.

public static string Unaccent(this DbFunctions _, string text)

Parameters

_ DbFunctions

The DbFunctions instance.

text string

The text to remove the diacritics.

Returns

string

A string without diacritics.

Remarks

The method call is translated to unaccent(text).

See https://www.postgresql.org/docs/current/unaccent.html.

Unaccent(DbFunctions, string, string)

Returns a new string that removes diacritics from characters in the given text.

public static string Unaccent(this DbFunctions _, string regDictionary, string text)

Parameters

_ DbFunctions

The DbFunctions instance.

regDictionary string

A specific text search dictionary.

text string

The text to remove the diacritics.

Returns

string

A string without diacritics.

Remarks

The method call is translated to unaccent(regdictionary, text).

See https://www.postgresql.org/docs/current/unaccent.html.

WebSearchToTsQuery(DbFunctions, string)

Convert query tsquery using the simplified websearch syntax.

public static NpgsqlTsQuery WebSearchToTsQuery(this DbFunctions _, string query)

Parameters

_ DbFunctions

query string

Returns

NpgsqlTsQuery

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES

WebSearchToTsQuery(DbFunctions, string, string)

Convert query tsquery using the simplified websearch syntax and the text search configuration specified by config.

public static NpgsqlTsQuery WebSearchToTsQuery(this DbFunctions _, string config, string query)

Parameters

_ DbFunctions

config string

query string

Returns

NpgsqlTsQuery

Remarks

http://www.postgresql.org/docs/current/static/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES