Dashing.Engine.Dialects.MySqlDialect.ApplySkipTake C# (CSharp) 메소드

ApplySkipTake() 공개 메소드

public ApplySkipTake ( StringBuilder sql, StringBuilder orderClause, int take, int skip ) : void
sql System.Text.StringBuilder
orderClause System.Text.StringBuilder
take int
skip int
리턴 void
        public override void ApplySkipTake(StringBuilder sql, StringBuilder orderClause, int take, int skip) {
            if (take > 0 && skip > 0) {
                sql.Append(" limit @skip, @take");
            }
            else if (take > 0) {
                sql.Append(" limit @take");
            }
            else if (skip > 0) {
                // yikes, limit is not optional so specify massive number 2^64-1
                sql.Append(" limit @skip, 18446744073709551615");
            }
        }
    }