public override bool Intercept(MethodCallExpression m, StringBuilder sql,
Func <Expression, Expression> visit)
{
if (m.Method.DeclaringType == typeof(string) && m.Method.Name == "Substring")
{
var start = m.Arguments[0];
var end = m.Arguments.Count > 1 ? m.Arguments[1] : Expression.Constant(int.MaxValue);
sql.Append(Dialect.Keyword(SqlKeyword.SubString));
sql.Append(Dialect.Symbol(SqlSymbols.StartGroup));
visit(m.Object);
sql.Append(Dialect.Symbol(SqlSymbols.Comma));
sql.Append(Dialect.Symbol(SqlSymbols.StartGroup));
visit(start);
sql.Append(Dialect.Symbol(SqlSymbols.EndGroup));
sql.Append($" {Dialect.ArithMeticOperand(SqlArithmeticOperand.Add)} 1");
sql.Append(Dialect.Symbol(SqlSymbols.Comma));
visit(end);
sql.Append(Dialect.Symbol(SqlSymbols.EndGroup));
return(true);
}
return(false);
}