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
-
NpgsqlFullTextSearchDbFunctionsExtensions
- Inherited Members
Remarks
See Database functions.
Methods
ArrayToTsVector(DbFunctions, string[])
Convert lexemes to a tsvector.
public static NpgsqlTsVector ArrayToTsVector(this DbFunctions _, string[] lexemes)
Parameters
_DbFunctionslexemesstring[]
Returns
Remarks
PhraseToTsQuery(DbFunctions, string)
Produce tsquery that searches for a phrase from query ignoring punctuation.
public static NpgsqlTsQuery PhraseToTsQuery(this DbFunctions _, string query)
Parameters
_DbFunctionsquerystring
Returns
Remarks
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
_DbFunctionsconfigstringquerystring
Returns
Remarks
PlainToTsQuery(DbFunctions, string)
Produce tsquery from query ignoring punctuation.
public static NpgsqlTsQuery PlainToTsQuery(this DbFunctions _, string query)
Parameters
_DbFunctionsquerystring
Returns
Remarks
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
_DbFunctionsconfigstringquerystring
Returns
Remarks
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
_DbFunctionsquerystring
Returns
Remarks
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
_DbFunctionsconfigstringquerystring
Returns
Remarks
ToTsVector(DbFunctions, string)
Reduce document to tsvector.
public static NpgsqlTsVector ToTsVector(this DbFunctions _, string document)
Parameters
_DbFunctionsdocumentstring
Returns
Remarks
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
_DbFunctionsconfigstringdocumentstring
Returns
Remarks
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
_DbFunctionsThe DbFunctions instance.
textstringThe text to remove the diacritics.
Returns
- string
A string without diacritics.
Remarks
The method call is translated to unaccent(text).
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
_DbFunctionsThe DbFunctions instance.
regDictionarystringA specific text search dictionary.
textstringThe text to remove the diacritics.
Returns
- string
A string without diacritics.
Remarks
The method call is translated to unaccent(regdictionary, text).
WebSearchToTsQuery(DbFunctions, string)
Convert query tsquery using the simplified websearch syntax.
public static NpgsqlTsQuery WebSearchToTsQuery(this DbFunctions _, string query)
Parameters
_DbFunctionsquerystring
Returns
Remarks
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
_DbFunctionsconfigstringquerystring