sqlstatement-class

Represents the result of performing BuildSQL command.

public class Korzh.EasyQuery.Db.SqlStatement
    : QueryStatement, ISqlStatement, IQueryStatement

Assembly: Korzh.EasyQuery.Db.dll

Constructors

Name	Type	Description
SqlStatement(SqlQueryBuilder builder)	void	Initializes a new instance of the Korzh.EasyQuery.Db.SqlStatement class.

Properties

Name	Type	Description
BuiltSQL	string	Get the text of the genereted SQL statement
CountSQL	string	Gets the text of result SQL statement for count total rows.
FromClause	string	Gets the text of FROM clause.
GroupClause	string	Gets the text of GROUP BY clause.
HasChunkLimit	bool	Gets a value indicating whether the result query statement includes paging (offset/fetch/limit) clauses.
HavingClause	string	Gets the text of HAVING clause.
OrderClause	string	Gets the text of ORDER BY clause.
Query	DbQuery	Gets the query.
RootNode	ResultTableNode	Gets or sets the root table node in the generated SQL statement.
RowNumberAlias	string	Gets the alias for Total Records column. This option works only if is true.
SelectClause	string	Gets the text of SELECT clause.
SQL	string	Gets the text of result SQL statement.
WhereClause	string	Gets the text of WHERE clause.

Methods

Name	Type	Description
AddCondition(string s)	void	Adds text of some condition to WHERE clause.
AddHavingCondition(string s)	void	Adds text of some condition to HAVING clause.
AddToHavingClause(string s)	void	Adds some text to HAVING clause.
AddToWhereClause(string s)	void	Adds some text to WHERE clause.
ClearAll()	void
GetAsSection()	string
GetCountTableAlias()	string
GetSql(string selectExpr, string orderExpr)	string	Gets the SQL statement with custom SELECT and ORDER BY clauses.
GetStatement()	string	Returns the statement (SQL, filter expression, etc - depending on the concrete QueryBuilderResult type).
ToString()	string	Returns a System.String that represents this instance.