public static ISqlCeSpecificTable <TSource> TableHint <TSource>(this ISqlCeSpecificTable <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);
}
public static ISqlCeSpecificTable <TSource> TableHint <TSource, TParam>(
this ISqlCeSpecificTable <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 ISqlCeSpecificTable <TSource> WithRowLock <TSource>(this ISqlCeSpecificTable <TSource> table)
where TSource : notnull
{
return(TableHint(table, Table.RowLock));
}
public static ISqlCeSpecificTable <TSource> WithIndex <TSource>(this ISqlCeSpecificTable <TSource> table, params string[] indexNames)
where TSource : notnull
{
return(table.TableHint(Table.Index, indexNames));
}
public static ISqlCeSpecificTable <TSource> WithIndex <TSource>(this ISqlCeSpecificTable <TSource> table, string indexName)
where TSource : notnull
{
return(TableHint(table, Table.Index, indexName));
}
