Dashing.Engine.Dialects.SqlServer2012Dialect.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 (orderClause.Length == 0) {
                // Sql Server 2012 only supports offset with an order by clause
                base.ApplySkipTake(sql, orderClause, take, skip);
                return;
            }

            sql.Append(" offset " + (skip > 0 ? "@skip" : "0") + " rows");

            if (take > 0) {
                sql.Append(" fetch next @take rows only");
            }
        }
    }
SqlServer2012Dialect