protected virtual string CompileInQueryCondition(InQueryCondition item)
{
var compiled = CompileQuery(item.Query);
var inOperator = item.IsNot ? "NOT IN" : "IN";
return(Wrap(item.Column) + $" {inOperator} ({compiled})");
}
protected virtual string CompileInQueryCondition(SqlResult ctx, InQueryCondition item)
{
var subCtx = CompileSelectQuery(item.Query);
ctx.Bindings.AddRange(subCtx.Bindings);
var inOperator = item.IsNot ? "NOT IN" : "IN";
return(Wrap(item.Column) + $" {inOperator} ({subCtx.RawSql})");
}
protected virtual string CompileInQueryCondition(SqlResult context, InQueryCondition item)
{
SqlResult subContext = CompileSelectQuery(item.Query);
context.Bindings.AddRange(subContext.Bindings);
string inOperator = item.IsNot ? "NOT IN" : "IN";
return(wrapper.Wrap(item.Column) + $" {inOperator} ({subContext.RawSql})");
}