public string GenerateSql() { var orderByString = orderBy != null ? $@" {orderBy.GenerateSql()}" : string.Empty; return($@"SELECT {rowSelection.GenerateSql()}{columns.GenerateSql()} FROM {from.GenerateSql()}{where.GenerateSql()}{orderByString}"); }
public string GenerateSql() { var orderByString = orderBy != null ? $@" {orderBy.GenerateSql()}" : string.Empty; var sql = $@"SELECT {rowSelection.GenerateSql()}{columns.GenerateSql()} FROM {from.GenerateSql()}{where.GenerateSql()}{orderByString}"; if (sql.Contains("Release_LatestByProjectChannel")) { sql += " OPTION (RECOMPILE)"; } return(sql); }