public static IQueryable <FreeTextKey <TKey> > FreeTextTableWithLanguage <TTable, TKey>(this ISqlServerExtensions?ext, ITable <TTable> table, string term, string language)
{
return(table.DataContext.FromSql <FreeTextKey <TKey> >($"FREETEXTTABLE({Sql.TableExpr(table)}, *, {term}, LANGUAGE {language})"));
}
public static bool ContainsWithLanguage(this ISqlServerExtensions?ext, [ExprParameter] string search, [ExprParameter] int language, [ExprParameter] params object?[] tableOrColumns)
{
throw new LinqException($"'{nameof(ContainsWithLanguage)}' is server-side method.");
}
public static bool ContainsPropertyWithLanguage(this ISqlServerExtensions?ext, object?column, string property, string search, int language)
{
throw new LinqException($"'{nameof(ContainsProperty)}' is server-side method.");
}
public static bool FreeTextWithLanguage(this ISqlServerExtensions?ext, [ExprParameter] string term, [ExprParameter] string language, [ExprParameter] params object?[] tableOrColumns)
{
throw new LinqException($"'{nameof(FreeTextWithLanguage)}' is server-side method.");
}
public static IQueryable <FreeTextKey <TKey> > FreeTextTable <TTable, TKey>(this ISqlServerExtensions?ext, ITable <TTable> table, string term, int top)
{
return(table.DataContext.FromSql <FreeTextKey <TKey> >($"FREETEXTTABLE({Sql.TableExpr(table)}, *, {term}, {top})"));
}
public static IQueryable <FreeTextKey <TKey> > ContainsTableWithLanguage <TTable, TKey>(this ISqlServerExtensions?ext, ITable <TTable> table, Expression <Func <TTable, object?> > columns, string search, int language)
{
return(table.DataContext.FromSql <FreeTextKey <TKey> >($"CONTAINSTABLE({Sql.TableExpr(table)}, ({Sql.FieldsExpr(table, columns)}), {search}, LANGUAGE {language})"));
}
public static IQueryable <FreeTextKey <TKey> > ContainsTableWithLanguage <TTable, TKey>(this ISqlServerExtensions?ext, ITable <TTable> table, string search, int language)
{
return(table.DataContext.FromSql <FreeTextKey <TKey> >($"CONTAINSTABLE({Sql.TableExpr(table)}, *, {search}, LANGUAGE {language})"));
}
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)
{
return(table.DataContext.FromSql <FreeTextKey <TKey> >($"FREETEXTTABLE({Sql.TableExpr(table)}, ({Sql.FieldsExpr(table, columns)}), {term}, LANGUAGE {language}, {top})"));
}