Class NpgsqlFullTextSearchDbFunctionsExtensions
Provides CLR methods that get translated to database functions when used in LINQ to Entities queries.
The methods on this class are accessed via .
Inheritance
NpgsqlFullTextSearchDbFunctionsExtensions
Assembly: Npgsql.EntityFrameworkCore.PostgreSQL.dll
Syntax
public static class NpgsqlFullTextSearchDbFunctionsExtensions
Methods
|
Improve this Doc
View Source
ArrayToTsVector(DbFunctions, string[])
Convert lexemes
to a tsvector.
Declaration
public static NpgsqlTsVector ArrayToTsVector(this DbFunctions _, string[] lexemes)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string[] |
lexemes |
|
Returns
Type |
Description |
NpgsqlTsVector |
|
|
Improve this Doc
View Source
PhraseToTsQuery(DbFunctions, string, string)
Produce tsquery that searches for a phrase from query
ignoring punctuation
and using the text search configuration specified by config
.
Declaration
public static NpgsqlTsQuery PhraseToTsQuery(this DbFunctions _, string config, string query)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
config |
|
string |
query |
|
Returns
Type |
Description |
NpgsqlTsQuery |
|
|
Improve this Doc
View Source
PhraseToTsQuery(DbFunctions, string)
Produce tsquery that searches for a phrase from query
ignoring punctuation.
Declaration
public static NpgsqlTsQuery PhraseToTsQuery(this DbFunctions _, string query)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
query |
|
Returns
Type |
Description |
NpgsqlTsQuery |
|
|
Improve this Doc
View Source
PlainToTsQuery(DbFunctions, string, string)
Produce tsquery from query
ignoring punctuation and using the text search
configuration specified by config
.
Declaration
public static NpgsqlTsQuery PlainToTsQuery(this DbFunctions _, string config, string query)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
config |
|
string |
query |
|
Returns
Type |
Description |
NpgsqlTsQuery |
|
|
Improve this Doc
View Source
PlainToTsQuery(DbFunctions, string)
Produce tsquery from query
ignoring punctuation.
Declaration
public static NpgsqlTsQuery PlainToTsQuery(this DbFunctions _, string query)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
query |
|
Returns
Type |
Description |
NpgsqlTsQuery |
|
|
Improve this Doc
View Source
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.
Declaration
public static NpgsqlTsQuery ToTsQuery(this DbFunctions _, string config, string query)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
config |
|
string |
query |
|
Returns
Type |
Description |
NpgsqlTsQuery |
|
|
Improve this Doc
View Source
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.
Declaration
public static NpgsqlTsQuery ToTsQuery(this DbFunctions _, string query)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
query |
|
Returns
Type |
Description |
NpgsqlTsQuery |
|
|
Improve this Doc
View Source
ToTsVector(DbFunctions, string, string)
Reduce document
to tsvector using the text search configuration specified
by config
.
Declaration
public static NpgsqlTsVector ToTsVector(this DbFunctions _, string config, string document)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
config |
|
string |
document |
|
Returns
Type |
Description |
NpgsqlTsVector |
|
|
Improve this Doc
View Source
ToTsVector(DbFunctions, string)
Reduce document
to tsvector.
Declaration
public static NpgsqlTsVector ToTsVector(this DbFunctions _, string document)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
document |
|
Returns
Type |
Description |
NpgsqlTsVector |
|
|
Improve this Doc
View Source
Unaccent(DbFunctions, string, string)
Returns a new string that removes diacritics from characters in the given text
.
Declaration
public static string Unaccent(this DbFunctions _, string regDictionary, string text)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
The instance.
|
string |
regDictionary |
A specific text search dictionary.
|
string |
text |
The text to remove the diacritics.
|
Returns
Type |
Description |
string |
A string without diacritics.
|
|
Improve this Doc
View Source
Unaccent(DbFunctions, string)
Returns a new string that removes diacritics from characters in the given text
.
Declaration
public static string Unaccent(this DbFunctions _, string text)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
The instance.
|
string |
text |
The text to remove the diacritics.
|
Returns
Type |
Description |
string |
A string without diacritics.
|
|
Improve this Doc
View Source
WebSearchToTsQuery(DbFunctions, string, string)
Convert query
tsquery using the simplified websearch syntax and the text
search configuration specified by config
.
Declaration
public static NpgsqlTsQuery WebSearchToTsQuery(this DbFunctions _, string config, string query)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
config |
|
string |
query |
|
Returns
Type |
Description |
NpgsqlTsQuery |
|
|
Improve this Doc
View Source
WebSearchToTsQuery(DbFunctions, string)
Convert query
tsquery using the simplified websearch syntax.
Declaration
public static NpgsqlTsQuery WebSearchToTsQuery(this DbFunctions _, string query)
Parameters
Type |
Name |
Description |
DbFunctions |
_ |
|
string |
query |
|
Returns
Type |
Description |
NpgsqlTsQuery |
|