Class Query
Base class of the data base query.
Inherited Members
Namespace: Terrasoft.Core.DB
Assembly: Terrasoft.Core.dll
Syntax
public abstract class Query : IParametrizedQuery, ISqlGenerating, ICacheableQuery, ICloneable
Constructors
Query()
Declaration
protected Query()
Query(Query)
Declaration
protected Query(Query source)
Parameters
Type | Name | Description |
---|---|---|
Query | source |
Properties
BuildParametersAsValue
Determines whether the query parameters are to be added as values into the query text.
Declaration
public bool BuildParametersAsValue { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
CachedSqlText
Cached text of the query.
Declaration
public string CachedSqlText { get; set; }
Property Value
Type | Description |
---|---|
System.String |
Condition
Gets the Where condition of the query.
Declaration
public QueryCondition Condition { get; }
Property Value
Type | Description |
---|---|
QueryCondition |
DBEngine
Declaration
protected DBEngine DBEngine { get; }
Property Value
Type | Description |
---|---|
DBEngine |
GroupByItems
The collection of expressions by which the query results are grouped.
Declaration
public QueryColumnExpressionCollection GroupByItems { get; }
Property Value
Type | Description |
---|---|
QueryColumnExpressionCollection |
HasCondition
Determines whether this query has the Where condition.
Declaration
public bool HasCondition { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
HasGroupByItems
Indicates whether the query expressions by which to group are defined in the query.
Declaration
public bool HasGroupByItems { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
HasHavingCondition
Determines whether this query has the Having statement.
Declaration
public bool HasHavingCondition { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
HasHints
Determines the presence of hints.
Declaration
public bool HasHints { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
HasJoins
Determines whether the query has at least one Join clause.
Declaration
public bool HasJoins { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
HasOrderByItems
Indicates whether the query expressions by which to sort are defined.
Declaration
public bool HasOrderByItems { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
HasParameters
Determines whether the query has parameters.
Declaration
public bool HasParameters { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
HasUnionQueries
Determines whether the given query has queries joined with it by the UNION operator.
Declaration
public bool HasUnionQueries { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
HavingCondition
Gets the Having statement of the query.
Declaration
public QueryCondition HavingCondition { get; }
Property Value
Type | Description |
---|---|
QueryCondition |
Hints
Declaration
public QueryHintCollection Hints { get; set; }
Property Value
Type | Description |
---|---|
QueryHintCollection |
IsCacheEnabled
Determines whether the query text is being cached.
Declaration
public bool IsCacheEnabled { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
IsUnionTypeAll
Determines whether to apply the All parameter for the UNION operator in this query.
Declaration
public bool IsUnionTypeAll { get; set; }
Property Value
Type | Description |
---|---|
System.Boolean |
Joins
Collection of Join statements of the given query.
Declaration
public JoinCollection Joins { get; }
Property Value
Type | Description |
---|---|
JoinCollection |
OrderByItems
The collection of expressions by which the query results are sorted.
Declaration
public OrderByItemCollection OrderByItems { get; }
Property Value
Type | Description |
---|---|
OrderByItemCollection |
Parameters
Collection of the query parameters.
Declaration
public QueryParameterCollection Parameters { get; }
Property Value
Type | Description |
---|---|
QueryParameterCollection |
RowCount
Number of first rows of the result set returned by the query.
Declaration
public int RowCount { get; set; }
Property Value
Type | Description |
---|---|
System.Int32 |
UnionQueries
Collection of queries joined with the given query by the UNION operator.
Declaration
public SelectQueryCollection UnionQueries { get; }
Property Value
Type | Description |
---|---|
SelectQueryCollection |
UserConnection
User connection.
Declaration
public UserConnection UserConnection { get; set; }
Property Value
Type | Description |
---|---|
UserConnection |
Methods
AddCondition(String, String, LogicalOperation)
To the current query condition, adds a predicate for the column with the specified alias from the specified source, using the specified logical operation.
Declaration
public QueryCondition AddCondition(string sourceAlias, string sourceColumnAlias, LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceAlias | The alias of the source. |
System.String | sourceColumnAlias | The alias of the column. |
LogicalOperation | logicalOperation | The logical operation that is used to add the predicate. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
AddCondition(String, LogicalOperation)
To the current query condition, adds a predicate for the column with the specified alias, using the specified logical operation.
Declaration
public QueryCondition AddCondition(string sourceColumnAlias, LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias | The alias of the column. |
LogicalOperation | logicalOperation | The logical operation that is used to add the predicate. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
AddCondition(LogicalOperation)
To the current query condition, adds the empty condition, using the specified logical operation.
Declaration
public QueryCondition AddCondition(LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
LogicalOperation | logicalOperation | The logical operation that is used to add the condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
AddCondition(IQueryColumnExpressionConvertible, LogicalOperation)
To the current query condition, adds the passed-in expression as the predicate, using the specified logical operation.
Declaration
public QueryCondition AddCondition(IQueryColumnExpressionConvertible expression, LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
IQueryColumnExpressionConvertible | expression | The expression being added as the predicate in the query condition. |
LogicalOperation | logicalOperation | The logical operation that is used to add the predicate. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
AddCondition(Query, LogicalOperation)
To the current query condition, adds the passed-in subquery as the predicate, using the specified logical operation.
Declaration
public QueryCondition AddCondition(Query subSelectQuery, LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | The subquery that is added to the query condition as the predicate. |
LogicalOperation | logicalOperation | The logical operation that is used to add the predicate. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
AddCondition(QueryColumnExpression, LogicalOperation)
To the current query condition, adds the passed-in expression as the predicate, using the specified logical operation.
Declaration
public QueryCondition AddCondition(QueryColumnExpression columnExpression, LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
QueryColumnExpression | columnExpression | The expression being added as the predicate in the query condition. |
LogicalOperation | logicalOperation | The logical operation that is used to add the predicate. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
AddCondition(QueryCondition, LogicalOperation)
To the current query condition, adds the passed-in query condition as the predicate, using the specified logical operation.
Declaration
public Query AddCondition(QueryCondition condition, LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
QueryCondition | condition | The query condition being added as the predicate. |
LogicalOperation | logicalOperation | The logical operation that is used to add the predicate. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
AddCondition(QueryParameter, LogicalOperation)
To the current query condition, adds the predicate for the passed-in query parameter, using the specified type of logical operation.
Declaration
public QueryCondition AddCondition(QueryParameter parameter, LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
QueryParameter | parameter | The query parameter. |
LogicalOperation | logicalOperation | The logical operation that is used to add the predicate. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
AddCondition(Select, LogicalOperation)
To the current query condition, adds the passed-in selection subquery as the predicate, using the specified logical operation.
Declaration
public QueryCondition AddCondition(Select subSelect, LogicalOperation logicalOperation)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | The select subquery that is added as the predicate in the query condition. |
LogicalOperation | logicalOperation | The logical operation that is used to add the predicate. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Exceptions
Type | Condition |
---|---|
UnsupportedTypeException | If the unspecified type of logical operation is passed as the |
And()
To the current query condition, adds the empty condition, using the AND logical operation.
Declaration
public QueryCondition And()
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
And(String)
To the current query condition, adds a predicate for the column with the specified alias, using the AND logical operation.
Declaration
public QueryCondition And(string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
And(String, String)
To the current query condition, adds a predicate for the column with the specified alias from the specified source, using the AND logical operation.
Declaration
public QueryCondition And(string sourceAlias, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceAlias | The alias of the source. |
System.String | sourceColumnAlias | The alias of the column. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
And(IQueryColumnExpressionConvertible)
To the current query condition, adds the passed-in expression as the predicate, using the AND logical operation.
Declaration
public QueryCondition And(IQueryColumnExpressionConvertible expression)
Parameters
Type | Name | Description |
---|---|---|
IQueryColumnExpressionConvertible | expression | The expression being added as the predicate in the query condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
And(Query)
To the current query condition, adds the passed-in query as the predicate, using the AND logical operation.
Declaration
public QueryCondition And(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | The query being added as the predicate in the query condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
And(QueryColumnExpression)
To the current query condition, adds the passed-in expression as the predicate.
Declaration
public QueryCondition And(QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
QueryColumnExpression | columnExpression | The expression being added as the predicate in the query condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
And(QueryCondition)
To the current query condition, adds the passed-in query condition as the predicate, using the AND logical operation.
Declaration
public Query And(QueryCondition condition)
Parameters
Type | Name | Description |
---|---|---|
QueryCondition | condition | The query condition being added as the predicate. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
And(QueryParameter)
To the current query condition, adds the predicate for the passed-in query parameter, using the AND logical operation.
Declaration
public QueryCondition And(QueryParameter parameter)
Parameters
Type | Name | Description |
---|---|---|
QueryParameter | parameter | The query parameter. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
And(Select)
To the current query condition, adds the passed-in selection subquery as the predicate, using the AND logical operation.
Declaration
public QueryCondition And(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | The select subquery being added as the predicate in the query condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
BuildSqlText(StringBuilder)
Builds the query text, using the passed-in System.Text.StringBuilder instance.
Declaration
public abstract void BuildSqlText(StringBuilder sb)
Parameters
Type | Name | Description |
---|---|---|
System.Text.StringBuilder | sb | The System.Text.StringBuilder instance used to create query text. |
Clone()
Creates the clone of the current Query instance.
Declaration
public abstract object Clone()
Returns
Type | Description |
---|---|
System.Object | A new Query instance that represents the copy of the current instance. |
CloseBlock()
Closes the conditions block.
Declaration
public Query CloseBlock()
Returns
Type | Description |
---|---|
Query | The current Query instance. |
Exceptions
Type | Condition |
---|---|
InvalidObjectStateException | If the query condition does not contain open blocks. |
Execute()
Executes SQL query and returns number of affected rows.
Declaration
public virtual int Execute()
Returns
Type | Description |
---|---|
System.Int32 | Number of affected rows. |
Execute(DBExecutor)
Executes SQL query using given instance of DBExecutor and returns number of affected rows.
Declaration
public virtual int Execute(DBExecutor dbExecutor)
Parameters
Type | Name | Description |
---|---|---|
DBExecutor | dbExecutor | Instance of DBExecutor, to be used for SQL query. |
Returns
Type | Description |
---|---|
System.Int32 | Number of affected rows. |
FullOuterJoin(String)
Associates the schema with the specified name with the current query, using the full outer join.
Declaration
public Join FullOuterJoin(string schemaName)
Parameters
Type | Name | Description |
---|---|---|
System.String | schemaName | Name of the schema to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the schema with the |
FullOuterJoin(Query)
Associates the specified random subquery with the current query, using the full outer join.
Declaration
public Join FullOuterJoin(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | Random subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
FullOuterJoin(QuerySourceExpression)
Associates the specified expression with the current query, using the full outer join.
Declaration
public Join FullOuterJoin(QuerySourceExpression sourceExpression)
Parameters
Type | Name | Description |
---|---|---|
QuerySourceExpression | sourceExpression | The expression to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
FullOuterJoin(Select)
Associates the specified select subquery with the current query, using the full outer join.
Declaration
public Join FullOuterJoin(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | Selection subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
GetSqlText()
Gets the query text.
Declaration
public abstract string GetSqlText()
Returns
Type | Description |
---|---|
System.String | The query text. |
GetUsingParameters()
Gets the collection of the query parameters.
Declaration
public virtual QueryParameterCollection GetUsingParameters()
Returns
Type | Description |
---|---|
QueryParameterCollection | Collection of the query parameters. |
GroupBy(String)
Groups query results in the descending order by the column with the specified alias.
Declaration
public Query GroupBy(string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias | The alias of the column by which the sorting is performed. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
GroupBy(String, String)
Groups the query results by the column with the specified alias from the specified source.
Declaration
public Query GroupBy(string sourceAlias, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceAlias | The alias of the source. |
System.String | sourceColumnAlias | The alias of the column by which the sorting is performed. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
GroupBy(IQueryColumnExpressionConvertible)
Groups the query results, using the value of the passed-in expression as the grouping key.
Declaration
public Query GroupBy(IQueryColumnExpressionConvertible expression)
Parameters
Type | Name | Description |
---|---|---|
IQueryColumnExpressionConvertible | expression | The expression whose value is used as the grouping key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
GroupBy(QueryColumnExpression)
Groups the query results, using the value of the passed-in expression as the grouping key.
Declaration
public Query GroupBy(QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
QueryColumnExpression | columnExpression | The expression whose value is used as the grouping key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
Having()
Adds the empty grouping condition to the current query.
Declaration
public QueryCondition Having()
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the empty grouping condition. |
Having(String)
In the current query, adds the grouping condition for the column with the specified alias.
Declaration
public QueryCondition Having(string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias | The alias of the column by which the grouping condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the grouping condition for the column with the |
Having(String, String)
In the current query, adds the grouping condition for the column with the specified alias from the specified source.
Declaration
public QueryCondition Having(string sourceAlias, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceAlias | The alias of the source. |
System.String | sourceColumnAlias | The alias of the column by which the grouping condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the grouping condition for the column with the |
Having(IQueryColumnExpressionConvertible)
In the current query, adds the grouping condition for the value of the passed-in expression.
Declaration
public QueryCondition Having(IQueryColumnExpressionConvertible expression)
Parameters
Type | Name | Description |
---|---|---|
IQueryColumnExpressionConvertible | expression | The expression for whose value the grouping condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the grouping condition for the value of the |
Having(Query)
In the current query, adds the grouping condition for results of the passed-in random subquery.
Declaration
public QueryCondition Having(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | The random subquery for whose results the grouping condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the grouping condition for results of the |
Having(QueryColumnExpression)
In the current query, adds the grouping condition for the value of the passed-in expression.
Declaration
public QueryCondition Having(QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
QueryColumnExpression | columnExpression | The expression for whose value the grouping condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the grouping condition for the value of the |
Having(QueryParameter)
In the current query, adds the grouping condition for the specified query parameter.
Declaration
public QueryCondition Having(QueryParameter parameter)
Parameters
Type | Name | Description |
---|---|---|
QueryParameter | parameter | The query parameter for which the grouping condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the grouping condition for the |
Having(Select)
In the current query, adds the grouping condition for results of the passed-in select subquery.
Declaration
public QueryCondition Having(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | The select subquery for whose results the grouping condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the group condition for results of the |
InitializeParameters()
Initializes the query parameters.
Declaration
public QueryParameterCollection InitializeParameters()
Returns
Type | Description |
---|---|
QueryParameterCollection | Collection of the initialized query parameters. |
InnerJoin(String)
Associates the specified schema with the current query, using the inner join.
Declaration
public Join InnerJoin(string schemaName)
Parameters
Type | Name | Description |
---|---|---|
System.String | schemaName | Name of the schema to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the schema with the |
InnerJoin(Query)
Associates the specified random subquery with the current query, using the inner join.
Declaration
public Join InnerJoin(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | Random subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
InnerJoin(QuerySourceExpression)
Associates the specified expression with the current query, using the inner join.
Declaration
public Join InnerJoin(QuerySourceExpression sourceExpression)
Parameters
Type | Name | Description |
---|---|---|
QuerySourceExpression | sourceExpression | The expression to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
InnerJoin(Select)
Associates the specified select subquery with the current query, using the inner join.
Declaration
public Join InnerJoin(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | Selection subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
Join(JoinType, String)
Associates the specified schema with the current query, using the specified join type.
Declaration
public Join Join(JoinType joinType, string schemaName)
Parameters
Type | Name | Description |
---|---|---|
JoinType | joinType | Join type. |
System.String | schemaName | Name of the schema to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the schema with the |
Join(JoinType, Query)
Associates the specified random subquery with the current query, using the specified join type.
Declaration
public Join Join(JoinType joinType, Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
JoinType | joinType | Join type. |
Query | subSelectQuery | Random subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
Join(JoinType, QuerySourceExpression)
Associates the specified expression with the current query, using the specified join type.
Declaration
public Join Join(JoinType joinType, QuerySourceExpression sourceExpression)
Parameters
Type | Name | Description |
---|---|---|
JoinType | joinType | Join type. |
QuerySourceExpression | sourceExpression | The expression to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
Join(JoinType, Select)
Associates the specified data select subquery with the current query, using the specified join type.
Declaration
public Join Join(JoinType joinType, Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
JoinType | joinType | Join type. |
Select | subSelect | Data select subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
LeftOuterJoin(String)
Associates the schema with the specified name with the current query, using the left outer join.
Declaration
public Join LeftOuterJoin(string schemaName)
Parameters
Type | Name | Description |
---|---|---|
System.String | schemaName | Name of the schema to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the schema with the |
LeftOuterJoin(Query)
Associates the specified random subquery with the current query, using the left outer join.
Declaration
public Join LeftOuterJoin(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | Random subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
LeftOuterJoin(QuerySourceExpression)
Associates the specified expression with the current query, using the left outer join.
Declaration
public Join LeftOuterJoin(QuerySourceExpression sourceExpression)
Parameters
Type | Name | Description |
---|---|---|
QuerySourceExpression | sourceExpression | The expression to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
LeftOuterJoin(Select)
Associates the specified select subquery with the current query, using the left outer join.
Declaration
public Join LeftOuterJoin(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | Selection subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
Or()
To the current query condition, adds the empty condition, using the OR logical operation.
Declaration
public QueryCondition Or()
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Or(String)
To the current query condition, adds a predicate for the column with the specified alias, using the OR logical operation.
Declaration
public QueryCondition Or(string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias | The alias of the column. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Or(String, String)
To the current query condition, adds a predicate for the column with the specified alias from the specified source, using the OR logical operation.
Declaration
public QueryCondition Or(string sourceAlias, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceAlias | The alias of the column. |
System.String | sourceColumnAlias | The alias of the source. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Or(IQueryColumnExpressionConvertible)
To the current query condition, adds the passed-in expression as the predicate, using the OR logical operation.
Declaration
public QueryCondition Or(IQueryColumnExpressionConvertible expression)
Parameters
Type | Name | Description |
---|---|---|
IQueryColumnExpressionConvertible | expression | The expression being added as the predicate in the query condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Or(Query)
To the current query condition, adds the passed-in subquery as the predicate, using the OR logical operation.
Declaration
public QueryCondition Or(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | The subquery being added as the predicate in the query condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Or(QueryColumnExpression)
To the current query condition, adds the passed-in expression as the predicate, using the OR logical operation.
Declaration
public QueryCondition Or(QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
QueryColumnExpression | columnExpression | The expression being added as the predicate in the query condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Or(QueryCondition)
To the current query condition, adds the passed-in query condition as the predicate, using the OR logical operation.
Declaration
public Query Or(QueryCondition condition)
Parameters
Type | Name | Description |
---|---|---|
QueryCondition | condition | The query condition being added as the predicate. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
Or(QueryParameter)
To the current query condition, adds the predicate for the passed-in query parameter, using the OR logical operation.
Declaration
public QueryCondition Or(QueryParameter parameter)
Parameters
Type | Name | Description |
---|---|---|
QueryParameter | parameter | The query parameter. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
Or(Select)
To the current query condition, adds the passed-in selection subquery as the predicate, using the OR logical operation.
Declaration
public QueryCondition Or(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | The select subquery being added as the predicate in the query condition. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the result query condition. |
OrderBy(OrderDirectionStrict, String)
Sorts query results in the specified order by the column with the specified alias.
Declaration
public Query OrderBy(OrderDirectionStrict direction, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
OrderDirectionStrict | direction | The sorting order for the query results. |
System.String | sourceColumnAlias | The alias of the column by which the sorting is performed. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderBy(OrderDirectionStrict, String, String)
Sorts the query results in the specified order by the column with the specified alias from the specified source.
Declaration
public Query OrderBy(OrderDirectionStrict direction, string sourceAlias, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
OrderDirectionStrict | direction | The sorting order for the query results. |
System.String | sourceAlias | The alias of the source. |
System.String | sourceColumnAlias | The alias of the column by which the sorting is performed. |
Returns
Type | Description |
---|---|
Query |
OrderBy(OrderDirectionStrict, IQueryColumnExpressionConvertible)
Sorts the query results in the specified order, using the value of the passed-in expression as the sort key.
Declaration
public Query OrderBy(OrderDirectionStrict direction, IQueryColumnExpressionConvertible expression)
Parameters
Type | Name | Description |
---|---|---|
OrderDirectionStrict | direction | The sorting order for the query results. |
IQueryColumnExpressionConvertible | expression | The expression whose value is used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderBy(OrderDirectionStrict, Query)
Sorts the query results in the specified order, using the results of the passed-in random subquery as the sort key.
Declaration
public Query OrderBy(OrderDirectionStrict direction, Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
OrderDirectionStrict | direction | The sorting order for the query results. |
Query | subSelectQuery | The random subquery whose results are used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderBy(OrderDirectionStrict, QueryColumnExpression)
Sorts the query results in the specified order, using the value of the passed-in expression as the sort key.
Declaration
public Query OrderBy(OrderDirectionStrict direction, QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
OrderDirectionStrict | direction | The sorting order for the query results. |
QueryColumnExpression | columnExpression | The expression whose value is used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderBy(OrderDirectionStrict, QueryFunction)
Sorts the query results in the specified order, using the value of the passed-in function as the sort key.
Declaration
public Query OrderBy(OrderDirectionStrict direction, QueryFunction queryFunction)
Parameters
Type | Name | Description |
---|---|---|
OrderDirectionStrict | direction | The sorting order for the query results. |
QueryFunction | queryFunction | The function whose value is used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderBy(OrderDirectionStrict, Select)
Sorts the query results in the specified order, using the results of the passed-in selection subquery as the sort key.
Declaration
public Query OrderBy(OrderDirectionStrict direction, Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
OrderDirectionStrict | direction | The sorting order. |
Select | subSelect | The select subquery whose results are used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByAsc(String)
Sorts query results in the ascending order by the column with the specified alias.
Declaration
public Query OrderByAsc(string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias | The alias of the column by which the sorting is performed. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByAsc(String, String)
Sorts the query results in the ascending order by the column with the specified alias from the specified source.
Declaration
public Query OrderByAsc(string sourceAlias, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceAlias | The alias of the source. |
System.String | sourceColumnAlias | The alias of the column by which the sorting is performed. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByAsc(IQueryColumnExpressionConvertible)
Sorts the query results in the ascending order, using the value of the passed-in expression as the sort key.
Declaration
public Query OrderByAsc(IQueryColumnExpressionConvertible expression)
Parameters
Type | Name | Description |
---|---|---|
IQueryColumnExpressionConvertible | expression | The expression whose value is used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByAsc(Query)
Sorts the query results in the ascending order, using the results of the passed-in random subquery as the sort key.
Declaration
public Query OrderByAsc(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | The random subquery whose results are used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByAsc(QueryColumnExpression)
Sorts the query results in the ascending order, using the value of the passed-in expression as the sort key.
Declaration
public Query OrderByAsc(QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
QueryColumnExpression | columnExpression | The expression whose value is used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByAsc(Select)
Sorts the query results in the ascending order, using the results of the passed-in selection subquery as the sort key.
Declaration
public Query OrderByAsc(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | The select subquery whose results are used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByDesc(String)
Sorts query results in the descending order by the column with the specified alias.
Declaration
public Query OrderByDesc(string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias | The alias of the column by which the sorting is performed. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByDesc(String, String)
Sorts the query results in the descending order by the column with the specified alias from the specified source.
Declaration
public Query OrderByDesc(string sourceAlias, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceAlias | The alias of the source. |
System.String | sourceColumnAlias | The alias of the column by which the sorting is performed. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByDesc(IQueryColumnExpressionConvertible)
Sorts the query results in the descending order, using the value of the passed-in expression as the sort key.
Declaration
public Query OrderByDesc(IQueryColumnExpressionConvertible expression)
Parameters
Type | Name | Description |
---|---|---|
IQueryColumnExpressionConvertible | expression | The expression whose value is used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByDesc(Query)
Sorts the query results in the descending order, using the results of the passed-in random subquery as the sort key.
Declaration
public Query OrderByDesc(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | The random subquery whose results are used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByDesc(QueryColumnExpression)
Sorts the query results in the descending order, using the value of the passed-in expression as the sort key.
Declaration
public Query OrderByDesc(QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
QueryColumnExpression | columnExpression | The expression whose value is used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
OrderByDesc(Select)
Sorts the query results in the descending order, using the results of the passed-in selection subquery as the query key.
Declaration
public Query OrderByDesc(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | The select subquery whose results are used as the sort key. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
ResetCachedSqlText()
Clears the cached text of the query.
Declaration
public void ResetCachedSqlText()
ResetParameters()
Clears the collection of the query parameters.
Declaration
public void ResetParameters()
RightOuterJoin(String)
Associates the schema with the specified name with the current query, using the right outer join.
Declaration
public Join RightOuterJoin(string schemaName)
Parameters
Type | Name | Description |
---|---|---|
System.String | schemaName | Name of the schema to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the schema with the |
RightOuterJoin(Query)
Associates the specified select subquery with the current query, using the right outer join.
Declaration
public Join RightOuterJoin(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | Selection subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
RightOuterJoin(QuerySourceExpression)
Associates the specified expression with the current query, using the right outer join.
Declaration
public Join RightOuterJoin(QuerySourceExpression sourceExpression)
Parameters
Type | Name | Description |
---|---|---|
QuerySourceExpression | sourceExpression | The expression to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
RightOuterJoin(Select)
Associates the specified random subquery with the current query, using the right outer join.
Declaration
public Join RightOuterJoin(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | Random subquery to associate. |
Returns
Type | Description |
---|---|
Join | The Join instance that associates the |
SetParameterValue(String, Object)
Sets the value of the query parameter.
Declaration
public void SetParameterValue(string name, object value)
Parameters
Type | Name | Description |
---|---|---|
System.String | name | The name of the parameter. |
System.Object | value | The value of the parameter. |
Union(Query)
Combines the results of the current query and results of the passed-in random query, excluding duplicate rows from the result set.
Declaration
public Query Union(Query unionSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | unionSelectQuery | The random query whose results are combined with the results of the current query. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
Union(Select)
Combines the results of the current query and results of the passed-in selectquery, excluding duplicate rows from the result set.
Declaration
public Query Union(Select unionSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | unionSelect | The select query whose results are combined with the results of the current query. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
UnionAll(Query)
Combines the results of the current query and results of the passed-in random query, but duplicate rows are not excluded from the result set.
Declaration
public Query UnionAll(Query unionSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | unionSelectQuery | The random query whose results are combined with the results of the current query. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
UnionAll(Select)
Combines the results of the current query and results of the passed-in select query, but duplicate rows are not excluded from the result set.
Declaration
public Query UnionAll(Select unionSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | unionSelect | The select query whose results are combined with the results of the current query. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
Where()
Adds the empty initial condition to the current query.
Declaration
public QueryCondition Where()
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the empty initial condition of the current query. |
Where(String)
In the current query, adds the initial condition for the column with the specified alias.
Declaration
public QueryCondition Where(string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceColumnAlias | The name of the schema for which the condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the initial condition for the column with the |
Where(String, String)
In the current query, adds a condition for the column with the specified alias from the specified source.
Declaration
public QueryCondition Where(string sourceAlias, string sourceColumnAlias)
Parameters
Type | Name | Description |
---|---|---|
System.String | sourceAlias | The alias of the source. |
System.String | sourceColumnAlias | The alias of the column. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the initial condition for the column with the |
Where(IQueryColumnExpressionConvertible)
In the current query, adds the initial condition for the value of the passed-in expression.
Declaration
public QueryCondition Where(IQueryColumnExpressionConvertible expression)
Parameters
Type | Name | Description |
---|---|---|
IQueryColumnExpressionConvertible | expression | The expression for whose value the initial condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the initial condition for the value of the |
Where(Query)
In the current query, adds the initial condition for results of the random subquery.
Declaration
public QueryCondition Where(Query subSelectQuery)
Parameters
Type | Name | Description |
---|---|---|
Query | subSelectQuery | The random subquery for whose results the initial condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the initial condition for results of the |
Where(QueryColumnExpression)
In the current query, adds the initial condition for the value of the passed-in expression.
Declaration
public QueryCondition Where(QueryColumnExpression columnExpression)
Parameters
Type | Name | Description |
---|---|---|
QueryColumnExpression | columnExpression | The expression for whose value the initial condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the initial condition in a form of the |
Where(QueryCondition)
In the current query, adds the passed-in condition as the initial condition.
Declaration
public Query Where(QueryCondition condition)
Parameters
Type | Name | Description |
---|---|---|
QueryCondition | condition | The query condition being added as the root condition to the current query. |
Returns
Type | Description |
---|---|
Query | The current Query instance. |
Where(QueryParameter)
In the current query, adds the initial condition for the passed-in query parameter.
Declaration
public QueryCondition Where(QueryParameter parameter)
Parameters
Type | Name | Description |
---|---|---|
QueryParameter | parameter | The query parameter. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the initial condition for the |
Where(Select)
In the current query, adds the initial condition for results of the passed-in select subquery.
Declaration
public QueryCondition Where(Select subSelect)
Parameters
Type | Name | Description |
---|---|---|
Select | subSelect | The select subquery for whose results the initial condition is added. |
Returns
Type | Description |
---|---|
QueryCondition | The QueryCondition instance that represents the initial condition for results of the |
Explicit Interface Implementations
IParametrizedQuery.InitializeParameters()
Initializes the query parameters.
Declaration
void IParametrizedQuery.InitializeParameters()