Dashing.Engine.Dialects.MySqlDialect.ApplySkipTake C# (CSharp) Method

ApplySkipTake() public method

public ApplySkipTake ( StringBuilder sql, StringBuilder orderClause, int take, int skip ) : void
sql System.Text.StringBuilder
orderClause System.Text.StringBuilder
take int
skip int
return 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");
            }
        }
    }