예제 #1
0
        protected virtual string CompileInQueryCondition(InQueryCondition item)
        {
            var compiled = CompileQuery(item.Query);

            var inOperator = item.IsNot ? "NOT IN" : "IN";

            return(Wrap(item.Column) + $" {inOperator} ({compiled})");
        }
예제 #2
0
        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})");
        }
예제 #3
0
        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})");
        }