Search Results for

    Show / Hide Table of Contents

    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
    object
    NpgsqlFullTextSearchDbFunctionsExtensions
    Namespace: Microsoft.EntityFrameworkCore
    Assembly: Npgsql.EntityFrameworkCore.PostgreSQL.dll
    Syntax
    public static class NpgsqlFullTextSearchDbFunctionsExtensions
    Remarks

    See Database functions.

    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
    Remarks

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

    | 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
    Remarks

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

    | 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
    Remarks

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

    | 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
    Remarks

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

    | 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
    Remarks

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

    | 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
    Remarks

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

    | 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
    Remarks

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

    | 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
    Remarks

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

    | 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
    Remarks

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

    | 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.

    Remarks

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

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

    | 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.

    Remarks

    The method call is translated to unaccent(text).

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

    | 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
    Remarks

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

    | 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
    Remarks

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

    • Improve this Doc
    • View Source
    In This Article
    Back to top © Copyright 2023 The Npgsql Development Team