public static IOracleSpecificTable <TSource> TableHint <TSource>(this IOracleSpecificTable <TSource> table, [SqlQueryDependent] string hint)
where TSource : notnull
{
table.Expression = Expression.Call(
null,
MethodHelper.GetMethodInfo(TableHint, table, hint),
table.Expression, Expression.Constant(hint));
return(table);
}
static IOracleSpecificTable <TSource> TableHintWithComma <TSource, TParam>(
this IOracleSpecificTable <TSource> table,
[SqlQueryDependent] string hint,
[SqlQueryDependent] TParam hintParameter)
where TSource : notnull
{
table.Expression = Expression.Call(
null,
MethodHelper.GetMethodInfo(TableHintWithComma, table, hint, hintParameter),
table.Expression, Expression.Constant(hint), Expression.Constant(hintParameter));
return(table);
}
public static IOracleSpecificTable <TSource> TableHint <TSource, TParam>(
this IOracleSpecificTable <TSource> table,
[SqlQueryDependent] string hint,
[SqlQueryDependent] params TParam[] hintParameters)
where TSource : notnull
{
table.Expression = Expression.Call(
null,
MethodHelper.GetMethodInfo(TableHint, table, hint, hintParameters),
table.Expression,
Expression.Constant(hint),
Expression.NewArrayInit(typeof(TParam), hintParameters.Select(p => Expression.Constant(p, typeof(TParam)))));
return(table);
}
public static IOracleSpecificTable <TSource> DynamicSamplingHint <TSource>(this IOracleSpecificTable <TSource> table, int value)
where TSource : notnull
{
return(TableHint(table, Hint.DynamicSampling, value));
}
public static IOracleSpecificTable <TSource> NoParallelIndexHint <TSource>(this IOracleSpecificTable <TSource> table, params object[] values)
where TSource : notnull
{
return(TableHintWithComma(table, Hint.NoParallelIndex, values));
}
public static IOracleSpecificTable <TSource> PQDistributeHint <TSource>(this IOracleSpecificTable <TSource> table, string outerDistribution, string innerDistribution)
where TSource : notnull
{
return(TableHintWithComma2(table, Hint.PQDistribute, outerDistribution, innerDistribution));
}
public static IOracleSpecificTable <TSource> ParallelDefaultHint <TSource>(this IOracleSpecificTable <TSource> table)
where TSource : notnull
{
return(TableHintWithComma(table, Hint.Parallel, "DEFAULT"));
}
public static IOracleSpecificTable <TSource> ParallelHint <TSource>(this IOracleSpecificTable <TSource> table, int value)
where TSource : notnull
{
return(TableHintWithComma(table, Hint.Parallel, value));
}
