private string SimplePaging() { // Create paged query StringBuilder sql = new StringBuilder(); _innerQuery.BuildSelectClause(sql); _innerQuery.BuildFromClause(sql); _innerQuery.BuildJoinClauses(sql); _innerQuery.BuildWhereClause(sql); _innerQuery.BuildOrderClause(sql); sql.AppendLine(String.Format(" LIMIT {0},{1}", _skip, _take)); return(sql.ToString()); }
public string Generate() { StringBuilder sql = new StringBuilder(); BuildSelectCountClause(sql); if (_innerQuery.IsJoin) { sql.Append(" FROM ("); _innerQuery.BuildSelectClause(sql); _innerQuery.BuildFromClause(sql); _innerQuery.BuildJoinClauses(sql); _innerQuery.BuildWhereClause(sql); _innerQuery.BuildGroupBy(sql); sql.Append(") "); return(sql.ToString()); } _innerQuery.BuildFromClause(sql); _innerQuery.BuildJoinClauses(sql); _innerQuery.BuildWhereClause(sql); return(sql.ToString()); }
/// <summary> /// Generates a query that pages a simple inner query. /// </summary> /// <returns></returns> private string SimplePaging() { // Create paged query StringBuilder sql = new StringBuilder(); sql.AppendLine("WITH RowNumCTE AS"); sql.AppendLine("("); _innerQuery.BuildSelectClause(sql); BuildRowNumberColumn(sql); _innerQuery.BuildFromClause(sql); _innerQuery.BuildJoinClauses(sql); _innerQuery.BuildWhereClause(sql); sql.AppendLine(")"); BuildSimpleOuterSelect(sql); return(sql.ToString()); }