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})"); }