Represents the result of performing BuildSQL command.
public class Korzh.EasyQuery.Db.SqlStatement
Type | Name | Description |
---|
Boolean | needGroupBy | |
Type | Name | Description |
---|
String | EntitySql | Gets the “entity SQL” (for Entity Framework). |
SqlExtraClauses | ExtraClauses | Gets the Korzh.EasyQuery.Db.SqlExtraClauses object which defines some extra clauses of generated query. |
DbQueryFormats | Formats | Gets the Korzh.EasyQuery.Db.DbQueryFormats object in the parent query. |
String | FromClause | Gets the text of FROM clause. |
String | GroupClause | Gets the text of GROUP BY clause. |
String | HavingClause | Gets the text of HAVING clause. |
Boolean | NeedGroupBy | Gets a value indicating whether GROUP BY section is necessary in result SQL. |
String | OrderClause | Gets the text of ORDER BY clause. |
ResultSetPortion | Portion | Allows to specify a portion of result set to return. |
DbQuery | Query | Gets the query. |
ResultTable | RootTable | Gets the root (first) table used in query. |
String | SelectClause | Gets the text of SELECT clause. |
String | SQL | Gets the text of result SQL statement. |
String | WhereClause | Gets the text of WHERE clause. |
Type | Name | Description |
---|
void | AddCondition(String s) | Adds text of some condition to WHERE clause. |
void | AddHavingCondition(String s) | Adds text of some condition to HAVING clause. |
Boolean | AddJoinToAppropriateResultTable(ResultTable resTable, Table table, String condExpr) | |
void | AddToAppropriateJoin(Table table, String condExpr) | |
void | AddToHavingClause(String s) | Adds some text to HAVING clause. |
void | AddToWhereClause(String s) | Adds some text to WHERE clause. |
void | ClearAll() | Clears all clauses. |
void | ClearHavingClause() | Clears the HAVING clause. |
void | ClearWhereClause() | Clears the WHERE clause. |
String | GetSql(String selectExpr, String orderExpr) | Gets the SQL statement with custom SELECT and ORDER BY clauses. |
String | GetStatement() | Returns the statement (SQL, filter expression, etc - depending on the concrete QueryBuilderResult type). |
void | SetRootTable(Table ATable) | |
String | ToString() | Returns a System.String that represents this instance. |