linq2db by Igor Tkachev, Ilya Chudin, Svyatoslav Danyliv, Dmitry Lukashenko

<PackageReference Include="linq2db" Version="5.0.0-rc.2" />

.NET API 4,326,400 bytes

 SqlServerExtensions

public static class SqlServerExtensions
public class FreeTextKey<TKey>

public static bool Contains(this ISqlServerExtensions ext, string search, object[] tableOrColumns)

Applies full-text search condition using CONTAINS predicate against specified full-text columns or all FTS columns in table. Example: "CONTAINS((col1, col2), N'search')".

public static bool ContainsProperty(this ISqlServerExtensions ext, object column, string property, string search)

Applies full-text search condition using CONTAINS(PROPERTY(...)) predicate against specified full-text column property. Example: "CONTAINS(PROPERTY(column, 'property'), N'search')".

public static bool ContainsPropertyWithLanguage(this ISqlServerExtensions ext, object column, string property, string search, string language)

Applies full-text search condition using CONTAINS(PROPERTY(...)) predicate against specified full-text column property. Example: "CONTAINS(PROPERTY(column, 'property'), N'search', LANGUAGE N'language')".

public static bool ContainsPropertyWithLanguage(this ISqlServerExtensions ext, object column, string property, string search, int language)

Applies full-text search condition using CONTAINS(PROPERTY(...)) predicate against specified full-text column property. Example: "CONTAINS(PROPERTY(column, 'property'), N'search', LANGUAGE language_code)".

public static IQueryable<FreeTextKey<TKey>> ContainsTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search)

Performs full-text search query using CONTAINSTABLE function against all full-text columns in table. Example: "CONTAINSTABLE(table, *, N'search')".

public static IQueryable<FreeTextKey<TKey>> ContainsTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, int top)

Performs full-text search query using CONTAINSTABLE function against all full-text columns in table. Example: "CONTAINSTABLE(table, *, N'search', top)".

public static IQueryable<FreeTextKey<TKey>> ContainsTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search)

Performs full-text search query using CONTAINSTABLE function against specified full-text columns. Example: "CONTAINSTABLE(table, (col1, col2), N'search')".

public static IQueryable<FreeTextKey<TKey>> ContainsTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, int top)

Performs full-text search query using CONTAINSTABLE function against specified full-text columns. Example: "CONTAINSTABLE(table, (col1, col2), N'search', top)".

public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, string language)

Performs full-text search query using CONTAINSTABLE function against all full-text columns in table. Example: "CONTAINSTABLE(table, *, N'search', LANGUAGE N'language')".

public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, string language, int top)

Performs full-text search query using CONTAINSTABLE function against all full-text columns in table. Example: "CONTAINSTABLE(table, *, N'search', LANGUAGE N'language', top)".

public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, int language, int top)

Performs full-text search query using CONTAINSTABLE function against all full-text columns in table. Example: "CONTAINSTABLE(table, *, N'search', LANGUAGE language_code)".

public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, int language)

Performs full-text search query using CONTAINSTABLE function against all full-text columns in table. Example: "CONTAINSTABLE(table, *, N'search', LANGUAGE language_code, top)".

public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, string language, int top)

Performs full-text search query using CONTAINSTABLE function against specified full-text columns. Example: "CONTAINSTABLE(table, (col1, col2), N'search', LANGUAGE N'language', top)".

public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, string language)

Performs full-text search query using CONTAINSTABLE function against specified full-text columns. Example: "CONTAINSTABLE(table, (col1, col2), N'search', LANGUAGE N'language')".

public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, int language, int top)

Performs full-text search query using CONTAINSTABLE function against specified full-text columns. Example: "CONTAINSTABLE(table, (col1, col2), N'search', LANGUAGE language_code, top)".

public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, int language)

Performs full-text search query using CONTAINSTABLE function against specified full-text columns. Example: "CONTAINSTABLE(table, (col1, col2), N'search', LANGUAGE language_code)".

public static bool ContainsWithLanguage(this ISqlServerExtensions ext, string search, string language, object[] tableOrColumns)

Applies full-text search condition using CONTAINS predicate against specified full-text columns or all FTS columns in table. Example: "CONTAINS((col1, col2), N'search', LANGUAGE N'language')".

public static bool ContainsWithLanguage(this ISqlServerExtensions ext, string search, int language, object[] tableOrColumns)

Applies full-text search condition using CONTAINS predicate against specified full-text columns or all FTS columns in table. Example: "CONTAINS((col1, col2), N'search', LANGUAGE language_code)".

public static bool FreeText(this ISqlServerExtensions ext, string term, object[] tableOrColumns)

Applies full-text search condition using FREETEXT predicate against specified full-text columns or all FTS columns in table. Example: "FREETEXT((col1, col2), N'search')".

public static IQueryable<FreeTextKey<TKey>> FreeTextTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term)

Performs full-text search query using FREETEXTTABLE function against all full-text columns in table. Example: "FREETEXTTABLE(table, *, N'search')".

public static IQueryable<FreeTextKey<TKey>> FreeTextTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, int top)

Performs full-text search query using FREETEXTTABLE function against all full-text columns in table. Example: "FREETEXTTABLE(table, *, N'search', top)".

public static IQueryable<FreeTextKey<TKey>> FreeTextTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term)

Performs full-text search query using FREETEXTTABLE function against specified full-text columns. Example: "FREETEXTTABLE(table, (col1, col2), N'search')".

public static IQueryable<FreeTextKey<TKey>> FreeTextTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, int top)

Performs full-text search query using FREETEXTTABLE function against specified full-text columns. Example: "FREETEXTTABLE(table, (col1, col2), N'search', top)".

public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, string language)

Performs full-text search query using FREETEXTTABLE function against all full-text columns in table. Example: "FREETEXTTABLE(table, *, N'search', LANGUAGE N'language')".

public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, string language, int top)

Performs full-text search query using FREETEXTTABLE function against all full-text columns in table. Example: "FREETEXTTABLE(table, *, N'search', LANGUAGE N'language', top)".

public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, int language, int top)

Performs full-text search query using FREETEXTTABLE function against all full-text columns in table. Example: "FREETEXTTABLE(table, *, N'search', LANGUAGE language_code, top)".

public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, int language)

Performs full-text search query using FREETEXTTABLE function against all full-text columns in table. Example: "FREETEXTTABLE(table, *, N'search', LANGUAGE language_code)".

public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, string language)

Performs full-text search query using FREETEXTTABLE function against specified full-text columns. Example: "FREETEXTTABLE(table, (col1, col2), N'search', LANGUAGE N'language')".

public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, string language, int top)

Performs full-text search query using FREETEXTTABLE function against specified full-text columns. Example: "FREETEXTTABLE(table, (col1, col2), N'search', LANGUAGE N'language', top)".

public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, int language, int top)

Performs full-text search query using FREETEXTTABLE function against specified full-text columns. Example: "FREETEXTTABLE(table, (col1, col2), N'search', LANGUAGE language_code, top)".

public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, int language)

Performs full-text search query using FREETEXTTABLE function against specified full-text columns. Example: "FREETEXTTABLE(table, (col1, col2), N'search', LANGUAGE language_code)".

public static bool FreeTextWithLanguage(this ISqlServerExtensions ext, string term, string language, object[] tableOrColumns)

Applies full-text search condition using FREETEXT predicate against specified full-text columns or all FTS columns in table. Example: "FREETEXT((col1, col2), N'search', LANGUAGE N'language')".

public static bool FreeTextWithLanguage(this ISqlServerExtensions ext, string term, int language, object[] tableOrColumns)

Applies full-text search condition using FREETEXT predicate against specified full-text columns or all FTS columns in table. Example: "FREETEXT((col1, col2), N'search', LANGUAGE language_code)".

public static T IsNull<T>(this ISqlServerExtensions ext, T value, T replacementValue)

Generates 'ISNULL( value, replacementValue )' function.

public static ISqlServerExtensions SqlServer(this ISqlExtension ext)