protected override SqlBuilder In(NewArrayExpression expression, SqlBuilder sqlBuilder)
{
sqlBuilder += "(";
foreach (Expression expressionItem in expression.Expressions)
{
Expression2SqlProvider.In(expressionItem, sqlBuilder);
}
if (sqlBuilder[sqlBuilder.Length - 1] == ',')
{
sqlBuilder.Remove(sqlBuilder.Length - 1, 1);
}
sqlBuilder += ")";
return(sqlBuilder);
}
protected override SqlPack In(NewArrayExpression expression, SqlPack sqlPack)
{
sqlPack += "(";
foreach (Expression expressionItem in expression.Expressions)
{
Expression2SqlProvider.In(expressionItem, sqlPack);
}
if (sqlPack.Sql[sqlPack.Sql.Length - 1] == ',')
{
sqlPack.Sql.Remove(sqlPack.Sql.Length - 1, 1);
}
sqlPack += ")";
return(sqlPack);
}
private static void InnerIn(MethodCallExpression expression, SqlBuilder sqlBuilder)
{
Expression2SqlProvider.Where(expression.Arguments[0], sqlBuilder);
sqlBuilder += " in";
Expression2SqlProvider.In(expression.Arguments[1], sqlBuilder);
}
private static void In(MethodCallExpression expression, SqlPack sqlPack)
{
Expression2SqlProvider.Where(expression.Arguments[0], sqlPack);
sqlPack += " in";
Expression2SqlProvider.In(expression.Arguments[1], sqlPack);
}