Class MySqlExtensions

Namespace

LinqToDB.DataProvider.MySql

Assembly

linq2db.dll

public static class MySqlExtensions

Inheritance

object

MySqlExtensions

Methods

Match(IMySqlExtensions?, MatchModifier, string, params object?[])

Applies full-text search condition using MATCH AGAINST predicate against specified full-text columns using specified search modifier. Example: MATCH(col1, col2) AGAINST('search query' MODIFIER).

[Sql.Extension("MATCH({columns, ', '}) AGAINST ({search}{modifier?})", IsPredicate = true, ServerSideOnly = true, BuilderType = typeof(MySqlExtensions.ModifierBuilder))]
public static bool Match(this IMySqlExtensions? ext, MySqlExtensions.MatchModifier modifier, string search, params object?[] columns)

Parameters

ext IMySqlExtensions

Extension point.

modifier MySqlExtensions.MatchModifier

Search modifier.

search string

Full-text search condition.

columns object[]

Full-text columns that should be queried.

Returns

bool

Returns true if full-text search found matching records.

Match(IMySqlExtensions?, string, params object?[])

Applies full-text search condition using MATCH AGAINST predicate against specified full-text columns using default mode (IN NATURAL LANGUAGE MODE). Example: MATCH(col1, col2) AGAINST('search query').

[Sql.Extension("MATCH({columns, ', '}) AGAINST ({search})", IsPredicate = true, ServerSideOnly = true)]
public static bool Match(this IMySqlExtensions? ext, string search, params object?[] columns)

Parameters

ext IMySqlExtensions

Extension point.

search string

Full-text search condition.

columns object[]

Full-text columns that should be queried.

Returns

bool

Returns true if full-text search found matching records.

MatchRelevance(IMySqlExtensions?, MatchModifier, string, params object?[])

Calculates relevance of full-text search for current record using MATCH AGAINST predicate against specified full-text columns using specified search modifier. Example: MATCH(col1, col2) AGAINST('search query' MODIFIER).

[Sql.Extension("MATCH({columns, ', '}) AGAINST ({search}{modifier?})", ServerSideOnly = true, BuilderType = typeof(MySqlExtensions.ModifierBuilder))]
public static double MatchRelevance(this IMySqlExtensions? ext, MySqlExtensions.MatchModifier modifier, string search, params object?[] columns)

Parameters

ext IMySqlExtensions

Extension point.

modifier MySqlExtensions.MatchModifier

Search modifier.

search string

Full-text search condition.

columns object[]

Full-text columns that should be queried.

Returns

double

Returns full-text search relevance value for current record.

MatchRelevance(IMySqlExtensions?, string, params object?[])

Calculates relevance of full-text search for current record using MATCH AGAINST predicate against specified full-text columns using default mode (IN NATURAL LANGUAGE MODE). Example: MATCH(col1, col2) AGAINST('search query').

[Sql.Extension("MATCH({columns, ', '}) AGAINST ({search})", ServerSideOnly = true)]
public static double MatchRelevance(this IMySqlExtensions? ext, string search, params object?[] columns)

Parameters

ext IMySqlExtensions

Extension point.

search string

Full-text search condition.

columns object[]

Full-text columns that should be queried.

Returns

double

Returns full-text search relevance value for current record.

MySql(ISqlExtension?)

public static IMySqlExtensions? MySql(this Sql.ISqlExtension? ext)

Parameters

ext Sql.ISqlExtension

Returns

IMySqlExtensions