# 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