Class QueryCondition

The query condition.

Inheritance
System.Object
System.Collections.ObjectModel.Collection<QueryCondition>
QueryCondition
Implements
System.Collections.Generic.IList<QueryCondition>
System.Collections.Generic.ICollection<QueryCondition>
System.Collections.IList
System.Collections.ICollection
System.Collections.Generic.IReadOnlyList<QueryCondition>
System.Collections.Generic.IReadOnlyCollection<QueryCondition>
System.Collections.Generic.IEnumerable<QueryCondition>
System.Collections.IEnumerable
System.ICloneable
Inherited Members
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.Add(Terrasoft.Core.DB.QueryCondition)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.Clear()
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.CopyTo(Terrasoft.Core.DB.QueryCondition[], System.Int32)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.Contains(Terrasoft.Core.DB.QueryCondition)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.GetEnumerator()
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.IndexOf(Terrasoft.Core.DB.QueryCondition)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.Insert(System.Int32, Terrasoft.Core.DB.QueryCondition)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.Remove(Terrasoft.Core.DB.QueryCondition)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.RemoveAt(System.Int32)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.ClearItems()
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.InsertItem(System.Int32, Terrasoft.Core.DB.QueryCondition)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.RemoveItem(System.Int32)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.SetItem(System.Int32, Terrasoft.Core.DB.QueryCondition)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IEnumerable.GetEnumerator()
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.ICollection.CopyTo(System.Array, System.Int32)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.get_Item(System.Int32)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.set_Item(System.Int32, System.Object)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.Add(System.Object)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.Contains(System.Object)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.IndexOf(System.Object)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.Insert(System.Int32, System.Object)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.Remove(System.Object)
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.Count
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.Items
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.Item[System.Int32]
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.Generic.ICollection<Terrasoft.Core.DB.QueryCondition>.IsReadOnly
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.ICollection.IsSynchronized
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.ICollection.SyncRoot
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.Item[System.Int32]
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.IsReadOnly
System.Collections.ObjectModel.Collection<Terrasoft.Core.DB.QueryCondition>.System.Collections.IList.IsFixedSize
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Terrasoft.Core.DB
Assembly: Terrasoft.Core.dll
Syntax
public class QueryCondition : Collection<QueryCondition>, IList<QueryCondition>, ICollection<QueryCondition>, IList, ICollection, IReadOnlyList<QueryCondition>, IReadOnlyCollection<QueryCondition>, IEnumerable<QueryCondition>, IEnumerable, ICloneable

Constructors

QueryCondition()

Initializes a new QueryCondition instance.

Declaration
public QueryCondition()

QueryCondition(Query)

Initializes a new QueryCondition instance for the specified query.

Declaration
public QueryCondition(Query parentQuery)
Parameters
Type Name Description
Query parentQuery

The query for which the QueryCondition instance is initialized.

QueryCondition(QueryColumnExpression)

Initializes a new QueryCondition instance for the specified expression.

Declaration
public QueryCondition(QueryColumnExpression leftExpression)
Parameters
Type Name Description
QueryColumnExpression leftExpression

The expression for which the QueryCondition instance is initialized.

QueryCondition(QueryCondition)

Initializes a new QueryCondition instance that is a clone of the specified QueryCondition instance.

Declaration
public QueryCondition(QueryCondition source)
Parameters
Type Name Description
QueryCondition source

The QueryCondition instance whose clone is being created.

QueryCondition(QueryConditionType)

Initializes a new QueryCondition instance with the specified type of the query condition.

Declaration
public QueryCondition(QueryConditionType conditionType)
Parameters
Type Name Description
QueryConditionType conditionType

The type of the query condition.

Properties

ConditionType

The type of the condition.

Declaration
public QueryConditionType ConditionType { get; set; }
Property Value
Type Description
QueryConditionType

HasRightExpressions

Determines whether at least one expression exists in the right side of the condition.

Declaration
public bool HasRightExpressions { get; }
Property Value
Type Description
System.Boolean

IsNot

Determines whether to use the NOT operator before the condition.

Declaration
public bool IsNot { get; set; }
Property Value
Type Description
System.Boolean

LeftExpression

Expression of the left side of the condition.

Declaration
public QueryColumnExpression LeftExpression { get; set; }
Property Value
Type Description
QueryColumnExpression

LogicalOperation

The logical operator that associates the given condition with the prior query condition.

Declaration
public LogicalOperation LogicalOperation { get; set; }
Property Value
Type Description
LogicalOperation

Name

Condition name.

Declaration
public string Name { get; set; }
Property Value
Type Description
System.String

ParentQuery

The query that contains the current condition.

Declaration
public Query ParentQuery { get; }
Property Value
Type Description
Query

RightExpressions

Collection of expressions of the right side of the condition.

Declaration
public QueryColumnExpressionCollection RightExpressions { get; }
Property Value
Type Description
QueryColumnExpressionCollection

Methods

And(String)

In the current condition of the query of the [Comparison Range] type, as the upper bound adds the expression for the column with the specified alias.

Declaration
public Query And(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

And(String, String)

In the current condition of the query of the [Comparison Range] type, as the upper bound adds the expression for the column with the specified alias from the specified source.

Declaration
public Query 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
Query

The instance of the Query query that contains the current condition.

And(IQueryColumnExpressionConvertible)

In the current condition of the query of the [Comparison Range] type, as the upper bound adds the passed-in expression.

Declaration
public Query And(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

And(Query)

In the current condition of the query of the [Comparison Range] type, as the upper bound adds the expression for results of the passed-in random subquery.

Declaration
public Query And(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

And(QueryColumnExpression)

In the current condition of the query of the [Comparison Range] type, as the upper bound adds the passed-in expression.

Declaration
public Query And(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

And(QueryParameter)

In the current condition of the query of the [Comparison Range] type, as the upper bound adds the passed-in query parameter.

Declaration
public Query And(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

And(Select)

In the current condition of the query of the [Comparison Range] type, as the upper bound adds the expression for results of the passed-in select subquery.

Declaration
public Query And(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

Clone()

Creates the clone of the current QueryCondition instance.

Declaration
public object Clone()
Returns
Type Description
System.Object

The QueryCondition instance that is a clone of the current instance.

ConsistsWith(String)

In the current condition of the query, adds the comparison of the [Contains Expression] type and as the comparison pattern sets the expression for the column with the specified alias.

Declaration
public Query ConsistsWith(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

ConsistsWith(String, String)

In the current condition of the query, adds the comparison of the [Contains Expression] type and as the comparison pattern sets the expression for the column with the specified alias from the specified source.

Declaration
public Query ConsistsWith(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
Query

The instance of the Query query that contains the current condition.

ConsistsWith(IQueryColumnExpressionConvertible)

In the current condition of the query, adds the comparison of the [Contains Expression] type and as the comparison pattern sets the passed-in expression.

Declaration
public Query ConsistsWith(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

ConsistsWith(Query)

In the current condition of the query, adds the comparison of the [Contains Expression] type and as the comparison pattern sets the expression for results of the passed-in random subquery.

Declaration
public Query ConsistsWith(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

ConsistsWith(QueryColumnExpression)

In the current condition of the query, adds the comparison of the [Contains Expression] type and as the comparison pattern sets the passed-in expression.

Declaration
public Query ConsistsWith(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

ConsistsWith(QueryParameter)

In the current condition of the query, adds the comparison of the [Contains Expression] type and as the comparison pattern sets the expression for the passed-in query parameter.

Declaration
public Query ConsistsWith(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

ConsistsWith(Select)

In the current condition of the query, adds the comparison of the [Contains Expression] type and as the comparison pattern sets the expression for results of the passed-in select subquery.

Declaration
public Query ConsistsWith(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

EndsWith(String)

In the current condition of the query, adds the comparison of the [Ends with Expression] type and as the comparison pattern sets the expression for the column with the specified alias.

Declaration
public Query EndsWith(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

EndsWith(String, String)

In the current condition of the query, adds the comparison of the [Ends with Expression] type and as the comparison pattern sets the expression for the column with the specified alias from the specified source.

Declaration
public Query EndsWith(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
Query

The instance of the Query query that contains the current condition.

EndsWith(IQueryColumnExpressionConvertible)

In the current condition of the query, adds the comparison of the [Ends with Expression] type and as the comparison pattern sets the passed-in expression.

Declaration
public Query EndsWith(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

EndsWith(Query)

In the current condition of the query, adds the comparison of the [Ends with Expression] type and as the comparison pattern sets the expression for the passed-in random subquery.

Declaration
public Query EndsWith(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

EndsWith(QueryColumnExpression)

In the current condition of the query, adds the comparison of the [Ends with Expression] type and as the comparison pattern sets the passed-in expression.

Declaration
public Query EndsWith(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

EndsWith(QueryParameter)

In the current condition of the query, adds the comparison of the [Ends with Expression] type and as the comparison pattern sets the expression for the passed-in query parameter.

Declaration
public Query EndsWith(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

EndsWith(Select)

In the current condition of the query, adds the comparison of the [Ends with Expression] type and as the comparison pattern sets the expression for results of the passed-in select subquery.

Declaration
public Query EndsWith(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

Exists(Query)

In the current condition of the query, sets the comparison of the [Exists by Specified Condition] type and as the validation criteria adds the expression for results of the passed-in random subquery.

Declaration
public Query Exists(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

Exists(QueryColumnExpression)

In the current condition of the query, sets the comparison of the [Exists by Specified Condition] type and as the validation criteria adds the passed-in expression.

Declaration
public Query Exists(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

Exists(Select)

In the current condition of the query, sets the comparison of the [Exists by Specified Condition] type and as the validation criteria adds the expression for results of the passed-in selected subquery.

Declaration
public Query Exists(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(IEnumerable<String>)

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified enumerator of column aliases.

Declaration
public Query In(IEnumerable<string> sourceColumnAliases)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<System.String> sourceColumnAliases

Enumerator of the column aliases.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(IEnumerable<IQueryColumnExpressionConvertible>)

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified enumerator of column expressions.

Declaration
public Query In(IEnumerable<IQueryColumnExpressionConvertible> expressions)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<IQueryColumnExpressionConvertible> expressions

Enumerator of the column expressions.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(IEnumerable<QueryColumnExpression>)

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified enumerator of column expressions.

Declaration
public Query In(IEnumerable<QueryColumnExpression> columnExpressions)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<QueryColumnExpression> columnExpressions

Enumerator of the column expressions.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(IEnumerable<QueryParameter>)

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified enumerator of query parameters.

Declaration
public Query In(IEnumerable<QueryParameter> parameters)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<QueryParameter> parameters

Enumerator of the query parameters.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(String[])

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified array of column aliases.

Declaration
public Query In(params string[] sourceColumnAliases)
Parameters
Type Name Description
System.String[] sourceColumnAliases

Array of column aliases.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(IQueryColumnExpressionConvertible[])

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified array of column expressions.

Declaration
public Query In(params IQueryColumnExpressionConvertible[] expressions)
Parameters
Type Name Description
IQueryColumnExpressionConvertible[] expressions

Array of column expressions.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(Query)

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified random subquery.

Declaration
public Query In(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(QueryColumnExpression[])

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified array of column expressions.

Declaration
public Query In(params QueryColumnExpression[] columnExpressions)
Parameters
Type Name Description
QueryColumnExpression[] columnExpressions

Array of column expressions.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(QueryParameter[])

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the specified array of query parameters.

Declaration
public Query In(params QueryParameter[] parameters)
Parameters
Type Name Description
QueryParameter[] parameters

Array of the query parameters.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

In(Select)

In the current condition of the query, sets the comparison of the [Belongs to Set of Values] type and in the first side of the condition adds the expression for the results of the passed-in select subquery.

Declaration
public Query In(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsBetween(String)

In the current condition sets the [Range of Values] comparison type and as the lower bound adds the expression for the column with the specified alias.

Declaration
public QueryCondition IsBetween(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
QueryCondition

The current condition of the QueryCondition query.

IsBetween(String, String)

In the current condition of the query, sets the [Range of Values] comparison type and as the lower bound adds the expression for the column with the specified alias from the specified source.

Declaration
public QueryCondition IsBetween(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 current condition of the QueryCondition query.

IsBetween(IQueryColumnExpressionConvertible)

In the current condition of the query, sets the [Range of Values] comparison type and as the lower bound adds the passed-in expression.

Declaration
public QueryCondition IsBetween(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

Expression.
Returns
Type Description
QueryCondition

The current condition of the QueryCondition query.

IsBetween(Query)

In the current condition of the query, sets the [Range of Values] comparison type and as the lower bound adds the expression for results of the passed-in random subquery.

Declaration
public QueryCondition IsBetween(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
QueryCondition

The current condition of the QueryCondition query.

IsBetween(QueryColumnExpression)

In the current condition of the query, tests whether the value of the condition expression is within the range whose lower bound is equal to the value of the passed-in expression.

Declaration
public QueryCondition IsBetween(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

Expression.
Returns
Type Description
QueryCondition

The current condition of the QueryCondition query.

IsBetween(QueryParameter)

In the current condition of the query, sets the [Range of Values] comparison type and as the lower bound adds the expression for the passed-in query parameter.

Declaration
public QueryCondition IsBetween(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
QueryCondition

The current condition of the QueryCondition query.

IsBetween(Select)

In the current condition of the query, sets the [Range of Values] comparison type and as the lower bound adds the expression for results of the passed-in select subquery.

Declaration
public QueryCondition IsBetween(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
QueryCondition

The current condition of the QueryCondition query.

IsEqual(String)

In the current condition sets the [Equal To] comparison type and in the right side of the condition adds the expression for the query column with the specified alias.

Declaration
public Query IsEqual(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsEqual(String, String)

In the current condition sets the [Equal To] comparison type and in the right side of the condition adds the expression for the column with the specified alias from the specified source.

Declaration
public Query IsEqual(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
Query

The instance of the Query query that contains the current condition.

IsEqual(IQueryColumnExpressionConvertible)

In the current condition sets the [Equal To] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsEqual(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsEqual(Query)

In the current condition sets the [Equal To] comparison type and in the right side of the condition adds the expression for results of the passed-in random subquery.

Declaration
public Query IsEqual(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsEqual(QueryColumnExpression)

In the current condition sets the [Equal To] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsEqual(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsEqual(QueryParameter)

In the current condition sets the [Equal To] comparison type and in the right side of the condition adds the expression for the passed-in query parameter.

Declaration
public Query IsEqual(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsEqual(Select)

In the current condition sets the [Equal To] comparison type and in the right side of the condition adds the expression for results of the passed-in select subquery.

Declaration
public Query IsEqual(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreater(String)

In the current condition sets the [Greater Than] comparison type and in the right part of the condition adds the expression for the column with the specified alias.

Declaration
public Query IsGreater(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreater(String, String)

In the current condition sets the [Greater Than] comparison type and in the right side of the condition adds the expression for the column with the specified alias from the specified source.

Declaration
public Query IsGreater(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
Query

The instance of the Query query that contains the current condition.

IsGreater(IQueryColumnExpressionConvertible)

In the current condition sets the [Greater Than] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsGreater(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreater(Query)

In the current condition sets the [Greater Than] comparison type and in the right side of the condition adds the expression for results of the passed-in random subquery.

Declaration
public Query IsGreater(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreater(QueryColumnExpression)

In the current condition sets the [Greater Than] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsGreater(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreater(QueryParameter)

In the current condition sets the [Greater Than] comparison type and in the right side of the condition adds the expression for the passed-in query parameter.

Declaration
public Query IsGreater(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreater(Select)

In the current condition sets the [Greater Than] comparison type and in the right side of the condition adds the expression for results of the passed-in select subquery.

Declaration
public Query IsGreater(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreaterOrEqual(String)

In the current condition sets the [Greater Than or Equal To] comparison type and in the right side of the condition adds the expression for the column with the specified alias.

Declaration
public Query IsGreaterOrEqual(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreaterOrEqual(String, String)

In the current condition sets the [Greater Than or Equal To] comparison type and in the right side of the condition adds the expression for the column with the specified alias from the specified source.

Declaration
public Query IsGreaterOrEqual(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
Query

The instance of the Query query that contains the current condition.

IsGreaterOrEqual(IQueryColumnExpressionConvertible)

In the current condition sets the [Greater Than or Equal To] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsGreaterOrEqual(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreaterOrEqual(Query)

In the current condition sets the [Greater Than or Equal To] comparison type and in the right side of the condition adds the expression for results of the passed-in random subquery.

Declaration
public Query IsGreaterOrEqual(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreaterOrEqual(QueryColumnExpression)

In the current condition sets the [Greater Than or Equal To] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsGreaterOrEqual(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreaterOrEqual(QueryParameter)

In the current condition sets the [Greater Than or Equal To] comparison type and in the right side of the condition adds the expression for the passed-in query parameter.

Declaration
public Query IsGreaterOrEqual(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsGreaterOrEqual(Select)

In the current condition sets the [Greater Than or Equal To] comparison type and in the right side of the condition adds the expression for the passed-in select query.

Declaration
public Query IsGreaterOrEqual(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLess(String)

In the current condition sets the [Less Than] comparison type and in the right side of the condition adds the expression for the column with the specified alias.

Declaration
public Query IsLess(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLess(String, String)

In the current condition sets the [Less Than] comparison type and in the right side of the condition adds the expression for the column with the specified alias from the specified source.

Declaration
public Query IsLess(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
Query

The instance of the Query query that contains the current condition.

IsLess(IQueryColumnExpressionConvertible)

In the current condition sets the [Less Than] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsLess(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLess(Query)

In the current condition sets the [Less Than] comparison type and in the right side of the condition adds the expression for results of the passed-in random subquery.

Declaration
public Query IsLess(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLess(QueryColumnExpression)

In the current condition sets the [Less Than] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsLess(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLess(QueryParameter)

In the current condition sets the [Less Than] comparison type and in the right side of the condition adds the expression for the passed-in query parameter.

Declaration
public Query IsLess(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLess(Select)

In the current condition sets the [Less Than] comparison type and in the right side of the condition adds the expression for results of the passed-in select subquery.

Declaration
public Query IsLess(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLessOrEqual(String)

In the current condition sets the [Less Than or Equal To] comparison type and in the right side of the condition adds the expression for the column with the specified alias.

Declaration
public Query IsLessOrEqual(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLessOrEqual(String, String)

In the current condition sets the [Less Than or Equal To] comparison type and in the right side of the condition adds the expression for the column with the specified alias from the specified source.

Declaration
public Query IsLessOrEqual(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
Query

The instance of the Query query that contains the current condition.

IsLessOrEqual(IQueryColumnExpressionConvertible)

In the current condition sets the [Less Than or Equal To] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsLessOrEqual(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLessOrEqual(Query)

In the current condition sets the [Less Than or Equal To] comparison type and in the right side of the condition adds the expression for results of the passed-in random subquery.

Declaration
public Query IsLessOrEqual(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLessOrEqual(QueryColumnExpression)

In the current condition sets the [Less Than or Equal To] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsLessOrEqual(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLessOrEqual(QueryParameter)

In the current condition sets the [Less Than or Equal To] comparison type and in the right side of the condition adds the expression for the passed-in query parameter.

Declaration
public Query IsLessOrEqual(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLessOrEqual(Select)

In the current query condition, checks whether the value of the condition expression is less than or equal to the results of the passed-in subquery for the sample.

Declaration
public Query IsLessOrEqual(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLike(String)

In the current condition of the query, adds the comparison of the [Match for Pattern] type and as the pattern sets the expression for the column with the specified alias.

Declaration
public Query IsLike(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLike(String, String)

In the current condition of the query, adds the comparison of the [Match for Pattern] type and as the pattern sets the expression for the column with the specified alias from the specified source.

Declaration
public Query IsLike(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
Query

The instance of the Query query that contains the current condition.

IsLike(IQueryColumnExpressionConvertible)

In the current condition of the query, adds the comparison of the [Match for Pattern] type and as the pattern sets the passed-in expression.

Declaration
public Query IsLike(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLike(Query)

In the current condition of the query, adds the comparison of the [Match for Pattern] type and as the pattern sets the expression for results of the passed-in random subquery.

Declaration
public Query IsLike(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLike(QueryColumnExpression)

In the current condition of the query, adds the comparison of the [Match for Pattern] type and as the pattern sets the passed-in expression.

Declaration
public Query IsLike(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLike(QueryParameter)

In the current condition of the query, adds the comparison of the [Match for Pattern] type and as the pattern sets the expression for the passed-in query parameter.

Declaration
public Query IsLike(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsLike(Select)

In the current condition of the query, adds the comparison of the [Match for Pattern] type and as the pattern sets the expression for results of the passed-in select subquery.

Declaration
public Query IsLike(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsNotEqual(String)

In the current condition sets the [Not Equal To] comparison type and in the right side of the condition adds the expression for the column with the specified alias.

Declaration
public Query IsNotEqual(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsNotEqual(String, String)

In the current condition sets the [Not Equal To] comparison type and in the right side of the condition adds the expression for the column with the specified alias from the specified source.

Declaration
public Query IsNotEqual(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
Query

The instance of the Query query that contains the current condition.

IsNotEqual(IQueryColumnExpressionConvertible)

In the current condition sets the [Not Equal To] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsNotEqual(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsNotEqual(Query)

In the current condition sets the [Not Equal To] comparison type and in the right side of the condition adds the expression for results of the passed-in random subquery.

Declaration
public Query IsNotEqual(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsNotEqual(QueryColumnExpression)

In the current condition sets the [Not Equal To] comparison type and in the right side of the condition adds the passed-in expression.

Declaration
public Query IsNotEqual(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

The expression that is added in the right side of the condition.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsNotEqual(QueryParameter)

In the current condition of the query tests whether the value of the condition expression is not equal to the passed-in query parameter.

Declaration
public Query IsNotEqual(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsNotEqual(Select)

In the current condition sets the [Not Equal To] comparison type and in the right side of the condition adds the expression for results of the passed-in select subquery.

Declaration
public Query IsNotEqual(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

IsNull()

To the current condition, adds a check to determine whether the value of the condition expression is null.

Declaration
public Query IsNull()
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

Not()

Adds a negation in the current condition.

Declaration
public QueryCondition Not()
Returns
Type Description
QueryCondition

The current QueryCondition instance in which the negation will be added.

OpenBlock()

Adds a conditional block to the current condition.

Declaration
public QueryCondition OpenBlock()
Returns
Type Description
QueryCondition

The QueryCondition condition of the block type that is added to the current condition.

OpenBlock(String)

To the current condition, adds a conditional block for the column with the specified alias.

Declaration
public QueryCondition OpenBlock(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column for which the expression block is opened.
Returns
Type Description
QueryCondition

The QueryCondition condition for the column with the sourceColumnAlias alias that is added to the current condition.

OpenBlock(String, String)

To the current condition, adds the conditional block for the column with the specified alias from the specified source.

Declaration
public QueryCondition OpenBlock(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 condition for the column with the sourceColumnAlias alias from the sourceAlias source.

OpenBlock(IQueryColumnExpressionConvertible)

To the current condition, adds a conditional block for the value of the specified expression.

Declaration
public QueryCondition OpenBlock(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

The expression for whose value the conditional block is added.
Returns
Type Description
QueryCondition

The QueryCondition condition for the expression expression value. This condition is added to the current condition.

OpenBlock(Query)

To the current condition, adds a conditional block for the results of the specified random subquery.

Declaration
public QueryCondition OpenBlock(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

The random subquery for whose results the conditional block is added.
Returns
Type Description
QueryCondition

The QueryCondition condition for the results of the subSelectQuery subquery. This condition is added to the current query condition.

OpenBlock(QueryColumnExpression)

To the current condition, adds a conditional block for the value of the specified expression.

Declaration
public QueryCondition OpenBlock(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

The expression for whose value the conditional block is added.
Returns
Type Description
QueryCondition

The QueryCondition condition for the columnExpression expression value. This condition is added to the current condition.

OpenBlock(QueryParameter)

To the current condition, adds a conditional block for the specified query parameter.

Declaration
public QueryCondition OpenBlock(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter for which the conditional block is added.
Returns
Type Description
QueryCondition

The QueryCondition condition for the parameter query parameter. This condition is added to the current condition.

OpenBlock(Select)

To the current condition, adds a conditional block for the results of the specified select subquery.

Declaration
public QueryCondition OpenBlock(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery for whose results the conditional block is added.
Returns
Type Description
QueryCondition

The QueryCondition condition for the results of the subSelect select subquery. This condition is added to the current condition.

StartsWith(String)

In the current condition of the query, adds the comparison of the [Starts with Expression] type and as the comparison pattern sets the expression for the column with the specified alias.

Declaration
public Query StartsWith(string sourceColumnAlias)
Parameters
Type Name Description
System.String sourceColumnAlias

The alias of the column.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

StartsWith(String, String)

In the current condition of the query, adds the comparison of the [Starts with Expression] type and as the comparison pattern sets the expression for the column with the specified alias from the specified source.

Declaration
public Query StartsWith(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
Query

The instance of the Query query that contains the current condition.

StartsWith(IQueryColumnExpressionConvertible)

In the current condition of the query, adds the comparison of the [Starts with Expression] type and as the comparison pattern sets the passed-in expression.

Declaration
public Query StartsWith(IQueryColumnExpressionConvertible expression)
Parameters
Type Name Description
IQueryColumnExpressionConvertible expression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

StartsWith(Query)

In the current condition of the query, adds the comparison of the [Starts with Expression] type and as the comparison pattern sets the expression for results of the passed-in random subquery.

Declaration
public Query StartsWith(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery

Random subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

StartsWith(QueryColumnExpression)

In the current condition of the query, adds the comparison of the [Starts with Expression] type and as the comparison pattern sets the passed-in expression.

Declaration
public Query StartsWith(QueryColumnExpression columnExpression)
Parameters
Type Name Description
QueryColumnExpression columnExpression

Expression.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

StartsWith(QueryParameter)

In the current condition of the query, adds the comparison of the [Starts with Expression] type and as the comparison pattern sets the expression for the passed-in query parameter.

Declaration
public Query StartsWith(QueryParameter parameter)
Parameters
Type Name Description
QueryParameter parameter

The query parameter.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

StartsWith(Select)

In the current condition of the query, adds the comparison of the [Starts with Expression] type and as the comparison pattern sets the expression for results of the passed-in select subquery.

Declaration
public Query StartsWith(Select subSelect)
Parameters
Type Name Description
Select subSelect

The select subquery.
Returns
Type Description
Query

The instance of the Query query that contains the current condition.

WrapBlock()

Places the current condition in the block.

Declaration
public QueryCondition WrapBlock()
Returns
Type Description
QueryCondition

The QueryCondition current condition that is placed in the block.

Implements

System.Collections.Generic.IList<T>
System.Collections.Generic.ICollection<T>
System.Collections.IList
System.Collections.ICollection
System.Collections.Generic.IReadOnlyList<T>
System.Collections.Generic.IReadOnlyCollection<T>
System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable
System.ICloneable

Extension Methods