SqlStatement class

December 9, 2019

Represents the result of performing BuildSQL command.

public class Korzh.EasyQuery.Db.SqlStatement
    : QueryBuilderResult

Fields

Type Name Description
Boolean _needGroupBy

Properties

Type Name Description
String EntitySql Gets the "entity SQL" (for Entity Framework).
SqlExtras ExtraClauses Gets the Korzh.EasyQuery.Db.SqlExtras 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.
Boolean HasPaging Gets or sets a value indicating whether the result query statement includes paging clauses.
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.
String RecordCountAlias Gets the alias for Total Records column. This option works only if RecordCountTemplate is not empty
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.

Methods

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.