Class WhereConditionBase<TParent>

Namespace

CMS.DataEngine

Assembly

CMS.DataEngine.dll

Where condition builder - Generic base class

public abstract class WhereConditionBase<TParent> : QueryParametersBase<TParent>, IWhereCondition<TParent>, IWhereCondition, IQueryParameters<TParent>, IQueryParameters, IQueryObject where TParent : WhereConditionBase<TParent>, new()

Type Parameters

TParent

Inheritance

object

AbstractQueryObject

QueryParametersBase<TParent>

WhereConditionBase<TParent>

Implements

IWhereCondition<TParent>

IWhereCondition

IQueryParameters<TParent>

IQueryParameters

IQueryObject

Derived

DataQuerySettingsBase<TQuery>

WhereCondition

Inherited Members

QueryParametersBase<TParent>.mParameters

QueryParametersBase<TParent>.IsImmutable

QueryParametersBase<TParent>.Parameters

QueryParametersBase<TParent>.CloneObject()

QueryParametersBase<TParent>.Clone()

QueryParametersBase<TParent>.EnsureParameters()

QueryParametersBase<TParent>.IncludeDataParameters(QueryDataParameters, string)

QueryParametersBase<TParent>.Immutable()

QueryParametersBase<TParent>.GetTypedQuery()

QueryParametersBase<TParent>.Expand(string)

QueryParametersBase<TParent>.ToString()

AbstractQueryObject.Name

AbstractQueryObject.Changed()

AbstractQueryObject.Reset()

Extension Methods

DataExtensions.With<T>(T, Action<T>)

QueryExtensions.AsLiteral<T>(T)

QueryExtensions.AsValue<T>(T, bool)

Constructors

WhereConditionBase()

Default constructor

protected WhereConditionBase()

Properties

DataSourceName

Data source identifier that represents the location from which the data are obtained.

public virtual string DataSourceName { get; set; }

Property Value

string

Remarks

Source identifiers are used to determine whether sub queries should be materialized or inserted directly into parent query.

ReturnsNoResults

Returns true if query doesn't return any results

public bool ReturnsNoResults { get; }

Property Value

bool

WhereCondition

Where condition on the data, e.g. "DocumentName = 'ABC'"

public virtual string WhereCondition { get; set; }

Property Value

string

WhereIsComplex

Returns true if the given where condition contains compound conditions, e. g. "A > 1 AND B = 5"

public virtual bool WhereIsComplex { get; set; }

Property Value

bool

Remarks

Complex where condition will be surrounded by brackets if added to other where condition.

WhereIsEmpty

Returns true if the where condition is empty

public virtual bool WhereIsEmpty { get; }

Property Value

bool

WhereOperator

Operator used for adding where condition. Default is AND

protected string WhereOperator { get; set; }

Property Value

string

Methods

AddWhereCondition(string)

Adds the given where condition to the final where condition

protected TParent AddWhereCondition(string where)

Parameters

where string

Where condition

Returns

TParent

AddWhereConditionInternal(IWhereCondition, bool)

Adds the given where condition

protected void AddWhereConditionInternal(IWhereCondition condition, bool negation = false)

Parameters

condition IWhereCondition

Condition to add

negation bool

If true, the added where condition is negated

And()

Changes the where operator to AND for subsequent where conditions. Use in combination of methods Where...

public virtual TParent And()

Returns

TParent

And(IWhereCondition)

Adds the given where condition with the AND operator

public virtual TParent And(IWhereCondition where)

Parameters

where IWhereCondition

Returns

TParent

And(Action<WhereCondition>)

Adds the given where condition with the AND operator. Creates a new where condition object and runs the setup actions on it.

public virtual TParent And(Action<WhereCondition> where)

Parameters

where Action<WhereCondition>

Returns

TParent

AnySettingsDefined()

Returns true if the object has any settings defined that influence the resulting query

protected virtual bool AnySettingsDefined()

Returns

bool

ApplyParametersTo(IQueryObject)

Applies this where condition to the target object

public override void ApplyParametersTo(IQueryObject target)

Parameters

target IQueryObject

Target object defining parameters

CopyPropertiesTo(IQueryObject)

Creates the clone of the collection.

public override void CopyPropertiesTo(IQueryObject target)

Parameters

target IQueryObject

Target class

Equals(object)

Determines whether the specified object is equal to the current object.

public override bool Equals(object obj)

Parameters

obj object

The object to compare with the current object.

Returns

bool

true if the specified object is equal to the current object; otherwise, false.

Equals(TParent)

Indicates whether the current object is equal to another object of the same type.

public virtual bool Equals(TParent other)

Parameters

other TParent

An object to compare with this object.

Returns

bool

true if the current object is equal to the other parameter; otherwise, false.

GetContainsPattern(string)

Gets the contains pattern for the like expression

protected static string GetContainsPattern(string text)

Parameters

text string

Text to match

Returns

string

GetDataSourceName()

Gets data source identifier that represents the location from which the data are obtained.

protected virtual string GetDataSourceName()

Returns

string

Remarks

Source identifiers are used to determine whether sub queries should be materialized or inserted directly into parent query.

GetHashCode()

Serves as a hash function for a particular type.

public override int GetHashCode()

Returns

int

A hash code for the current object.

GetWhere(IQueryObjectWithValue, QueryOperator, object)

Gets the where condition for the given column

protected string GetWhere(IQueryObjectWithValue leftSide, QueryOperator op, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side of the condition

op QueryOperator

Operator

rightSide object

Right side of the condition

Returns

string

GetWhere(string, QueryOperator, object)

Gets the where condition for the given column

protected string GetWhere(string columnName, QueryOperator op, object value)

Parameters

columnName string

Column name

op QueryOperator

Operator

value object

Value

Returns

string

HasCompatibleSource(IDataQuery)

Returns true if the given query is an external source

public virtual bool HasCompatibleSource(IDataQuery query)

Parameters

query IDataQuery

Nested query

Returns

bool

NewWhere()

Clears the current where condition

public virtual TParent NewWhere()

Returns

TParent

NoResults()

Sets the where condition to exclude all data from result

public virtual TParent NoResults()

Returns

TParent

Or()

Changes the where operator to OR for next where conditions. Use in combination of methods Where...

public virtual TParent Or()

Returns

TParent

Or(IWhereCondition)

Adds the given where condition with the OR operator

public virtual TParent Or(IWhereCondition where)

Parameters

where IWhereCondition

Returns

TParent

Or(Action<WhereCondition>)

Adds the given where condition with the OR operator. Creates a new where condition object and runs the setup actions on it.

public virtual TParent Or(Action<WhereCondition> where)

Parameters

where Action<WhereCondition>

Returns

TParent

ResetWhereOperator()

Resets the where operator to the default value

protected void ResetWhereOperator()

ToString(bool)

Returns the string representation of the expression, with possibility of expanding parameters

public override string ToString(bool expand)

Parameters

expand bool

If true, the result is expanded with parameters so it can act as standalone value.

Returns

string

Where(IQueryObjectWithValue, QueryOperator, object)

Adds the given where condition to the query. Matches the column to a given value.

public virtual TParent Where(IQueryObjectWithValue leftSide, QueryOperator op, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Column name

op QueryOperator

Operator

rightSide object

Value

Returns

TParent

Where(IQueryObjectWithValue, QueryUnaryOperator)

Adds the given where condition to the query. Matches the column value with an unary operator.

public virtual TParent Where(IQueryObjectWithValue expression, QueryUnaryOperator op)

Parameters

expression IQueryObjectWithValue

Expression

op QueryUnaryOperator

Operator

Returns

TParent

Where(params IWhereCondition[])

Adds the given where conditions to the query

public virtual TParent Where(params IWhereCondition[] conditions)

Parameters

conditions IWhereCondition[]

Nested where conditions

Returns

TParent

Where(Action<WhereCondition>)

Adds the given where condition to the query. Creates a new where condition object and runs the setup actions on it.

public virtual TParent Where(Action<WhereCondition> condition)

Parameters

condition Action<WhereCondition>

Nested where condition

Returns

TParent

Where(string, QueryDataParameters)

Adds the given where condition to the query

public virtual TParent Where(string where, QueryDataParameters parameters = null)

Parameters

where string

Where condition

parameters QueryDataParameters

Query parameters

Returns

TParent

Where(string, QueryOperator, object)

Adds the given where condition to the query. Matches the column to a given value.

public virtual TParent Where(string columnName, QueryOperator op, object value)

Parameters

columnName string

Column name

op QueryOperator

Operator

value object

Value

Returns

TParent

Where(string, QueryUnaryOperator)

Adds the given where condition to the query. Matches the column value with an unary operator.

public virtual TParent Where(string columnName, QueryUnaryOperator op)

Parameters

columnName string

Column name

op QueryUnaryOperator

Operator

Returns

TParent

WhereContains(IQueryObjectWithValue, string)

Adds the condition for a string column to contain some substring

public virtual TParent WhereContains(IQueryObjectWithValue expression, string value)

Parameters

expression IQueryObjectWithValue

Expression

value string

Value

Returns

TParent

WhereContains(string, string)

Adds the condition for a string column to contain some substring

public virtual TParent WhereContains(string columnName, string value)

Parameters

columnName string

Column name

value string

Value

Returns

TParent

WhereEmpty(string)

Adds the where condition for a null or empty column value

public virtual TParent WhereEmpty(string columnName)

Parameters

columnName string

Column name

Returns

TParent

WhereEndsWith(IQueryObjectWithValue, string)

Adds the condition for a string expression to end with some prefix

public virtual TParent WhereEndsWith(IQueryObjectWithValue expression, string value)

Parameters

expression IQueryObjectWithValue

Expression

value string

Value

Returns

TParent

WhereEndsWith(string, string)

Adds the condition for a string column to end with some prefix

public virtual TParent WhereEndsWith(string columnName, string value)

Parameters

columnName string

Column name

value string

Value

Returns

TParent

WhereEquals(IQueryObjectWithValue, object)

Adds the given where condition to the query. Matches the left side to the given right side.

public virtual TParent WhereEquals(IQueryObjectWithValue leftSide, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side

rightSide object

Right side

Returns

TParent

WhereEquals(string, object)

Adds the given where condition to the query. Matches the column to a given value.

public virtual TParent WhereEquals(string columnName, object value)

Parameters

columnName string

Column name

value object

Value

Returns

TParent

WhereEqualsOrNull(string, object)

Adds the given where condition to the query. Matches the column to a given value or null value.

public virtual TParent WhereEqualsOrNull(string columnName, object value)

Parameters

columnName string

Column name

value object

Value

Returns

TParent

WhereExists(IDataQuery)

Adds where condition with EXISTS and the nested query "EXISTS (...)"

public virtual TParent WhereExists(IDataQuery nestedQuery)

Parameters

nestedQuery IDataQuery

Nested query

Returns

TParent

WhereExists(IDataQuery, bool)

Adds where condition with EXISTS and the nested query "EXISTS (...)"

protected TParent WhereExists(IDataQuery nestedQuery, bool negation)

Parameters

nestedQuery IDataQuery

Nested query

negation bool

If true, the expression is NOT EXISTS

Returns

TParent

WhereFalse(IQueryObjectWithValue)

Adds the where condition for a false expression value (boolean expression equals false).

public virtual TParent WhereFalse(IQueryObjectWithValue expression)

Parameters

expression IQueryObjectWithValue

Column name

Returns

TParent

WhereFalse(string)

Adds the where condition for a false column value (boolean column equals false).

public virtual TParent WhereFalse(string columnName)

Parameters

columnName string

Column name

Returns

TParent

WhereGreaterOrEquals(IQueryObjectWithValue, object)

Adds the given where condition to the query. Matches the left side which is greater or equal than the right side.

public virtual TParent WhereGreaterOrEquals(IQueryObjectWithValue leftSide, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side

rightSide object

Right side

Returns

TParent

WhereGreaterOrEquals(string, object)

Adds the given where condition to the query. Matches the left side which is greater or equal than the right side.

public virtual TParent WhereGreaterOrEquals(string columnName, object value)

Parameters

columnName string

Column name

value object

Value

Returns

TParent

WhereGreaterThan(IQueryObjectWithValue, object)

Adds the given where condition to the query. Matches the left side which is greater than the right side.

public virtual TParent WhereGreaterThan(IQueryObjectWithValue leftSide, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side

rightSide object

Right side

Returns

TParent

WhereGreaterThan(string, object)

Adds the given where condition to the query. Matches the left side which is greater than the right side.

public virtual TParent WhereGreaterThan(string columnName, object value)

Parameters

columnName string

Column name

value object

Value

Returns

TParent

WhereID(string, int)

Adds the where condition to match the ID to the query. In case the column name is not provided or unknown, does not generate where condition. If given ID is invalid, adds the condition to match NULL.

public virtual TParent WhereID(string columnName, int id)

Parameters

columnName string

Column name

id int

ID

Returns

TParent

WhereIn(string, IDataQuery)

Adds where condition to the nested query, e.g. "columnName IN (...)"

public virtual TParent WhereIn(string columnName, IDataQuery nestedQuery)

Parameters

columnName string

Column name

nestedQuery IDataQuery

Nested query

Returns

TParent

WhereIn(string, IDataQuery, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)". Supported generic type is int, long, string or guid ONLY!

protected TParent WhereIn(string columnName, IDataQuery nestedQuery, bool negation)

Parameters

columnName string

Column name

nestedQuery IDataQuery

Nested query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereIn(string, ICollection<Guid>)

Adds where condition to the list of values, e.g. "columnName IN (...)"

public virtual TParent WhereIn(string columnName, ICollection<Guid> values)

Parameters

columnName string

Column name

values ICollection<Guid>

List of values for the query

Returns

TParent

WhereIn(string, ICollection<Guid>, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)"

protected TParent WhereIn(string columnName, ICollection<Guid> values, bool negation)

Parameters

columnName string

Column name

values ICollection<Guid>

List of values for the query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereIn(string, ICollection<int>)

Adds where condition to the list of values, e.g. "columnName IN (...)"

public virtual TParent WhereIn(string columnName, ICollection<int> values)

Parameters

columnName string

Column name

values ICollection<int>

List of values for the query

Returns

TParent

WhereIn(string, ICollection<int>, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)"

protected TParent WhereIn(string columnName, ICollection<int> values, bool negation)

Parameters

columnName string

Column name

values ICollection<int>

List of values for the query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereIn(string, ICollection<long>)

Adds where condition to the list of values, e.g. "columnName IN (...)"

public virtual TParent WhereIn(string columnName, ICollection<long> values)

Parameters

columnName string

Column name

values ICollection<long>

List of values for the query

Returns

TParent

WhereIn(string, ICollection<long>, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)"

protected TParent WhereIn(string columnName, ICollection<long> values, bool negation)

Parameters

columnName string

Column name

values ICollection<long>

List of values for the query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereIn(string, ICollection<string>)

Adds where condition to the list of values, e.g. "columnName IN (...)"

public virtual TParent WhereIn(string columnName, ICollection<string> values)

Parameters

columnName string

Column name

values ICollection<string>

List of values for the query

Returns

TParent

WhereIn(string, ICollection<string>, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)"

protected TParent WhereIn(string columnName, ICollection<string> values, bool negation)

Parameters

columnName string

Column name

values ICollection<string>

List of values for the query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereIn(string, IEnumerable<Guid>)

Adds where condition to the list of values, e.g. "columnName IN (...)"

public TParent WhereIn(string columnName, IEnumerable<Guid> values)

Parameters

columnName string

Column name

values IEnumerable<Guid>

List of values for the query

Returns

TParent

WhereIn(string, IEnumerable<Guid>, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)"

protected TParent WhereIn(string columnName, IEnumerable<Guid> values, bool negation)

Parameters

columnName string

Column name

values IEnumerable<Guid>

List of values for the query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereIn(string, IEnumerable<int>)

Adds where condition to the list of values, e.g. "columnName IN (...)"

public TParent WhereIn(string columnName, IEnumerable<int> values)

Parameters

columnName string

Column name

values IEnumerable<int>

List of values for the query

Returns

TParent

WhereIn(string, IEnumerable<int>, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)"

protected TParent WhereIn(string columnName, IEnumerable<int> values, bool negation)

Parameters

columnName string

Column name

values IEnumerable<int>

List of values for the query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereIn(string, IEnumerable<long>)

Adds where condition to the list of values, e.g. "columnName IN (...)"

public TParent WhereIn(string columnName, IEnumerable<long> values)

Parameters

columnName string

Column name

values IEnumerable<long>

List of values for the query

Returns

TParent

WhereIn(string, IEnumerable<long>, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)"

protected TParent WhereIn(string columnName, IEnumerable<long> values, bool negation)

Parameters

columnName string

Column name

values IEnumerable<long>

List of values for the query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereIn(string, IEnumerable<string>)

Adds where condition to the list of values, e.g. "columnName IN (...)"

public TParent WhereIn(string columnName, IEnumerable<string> values)

Parameters

columnName string

Column name

values IEnumerable<string>

List of values for the query

Returns

TParent

WhereIn(string, IEnumerable<string>, bool)

Adds where condition to the list of values, e.g. "columnName IN (...)"

protected TParent WhereIn(string columnName, IEnumerable<string> values, bool negation)

Parameters

columnName string

Column name

values IEnumerable<string>

List of values for the query

negation bool

If true, the expression is NOT IN

Returns

TParent

WhereLessOrEquals(IQueryObjectWithValue, object)

Adds the given where condition to the query. Matches the left side which is less or equal than the right side.

public virtual TParent WhereLessOrEquals(IQueryObjectWithValue leftSide, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side

rightSide object

Right side

Returns

TParent

WhereLessOrEquals(string, object)

Adds the given where condition to the query. Matches the left side which is less or equal than the right side.

public virtual TParent WhereLessOrEquals(string columnName, object value)

Parameters

columnName string

Column name

value object

Value

Returns

TParent

WhereLessThan(IQueryObjectWithValue, object)

Adds the given where condition to the query. Matches the left side which is less than the right side.

public virtual TParent WhereLessThan(IQueryObjectWithValue leftSide, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side

rightSide object

Right side

Returns

TParent

WhereLessThan(string, object)

Adds the given where condition to the query. Matches the left side which is less than the right side.

public virtual TParent WhereLessThan(string columnName, object value)

Parameters

columnName string

Column name

value object

Value

Returns

TParent

WhereLike(IQueryObjectWithValue, object)

Adds the given where condition to the query. Matches the left side and right side using LIKE operator.

public virtual TParent WhereLike(IQueryObjectWithValue leftSide, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side

rightSide object

Right side

Returns

TParent

WhereLike(string, string)

Adds the given where condition to the query. Matches the column to a given value using LIKE operator.

public virtual TParent WhereLike(string columnName, string value)

Parameters

columnName string

Column name

value string

Value

Returns

TParent

WhereNot(IWhereCondition)

Adds the negation of the given where condition

public virtual TParent WhereNot(IWhereCondition where)

Parameters

where IWhereCondition

Where condition

Returns

TParent

WhereNotContains(IQueryObjectWithValue, string)

Adds the condition for a string column not to contain some substring

public virtual TParent WhereNotContains(IQueryObjectWithValue expression, string value)

Parameters

expression IQueryObjectWithValue

Expression

value string

Value

Returns

TParent

WhereNotContains(string, string)

Adds the condition for a string column not to contain some substring

public virtual TParent WhereNotContains(string columnName, string value)

Parameters

columnName string

Column name

value string

Value

Returns

TParent

WhereNotEmpty(string)

Adds the where condition for a non empty column value

public virtual TParent WhereNotEmpty(string columnName)

Parameters

columnName string

Column name

Returns

TParent

WhereNotEndsWith(IQueryObjectWithValue, string)

Adds the condition for a string column not to end with some prefix

public virtual TParent WhereNotEndsWith(IQueryObjectWithValue expression, string value)

Parameters

expression IQueryObjectWithValue

Expression

value string

Value

Returns

TParent

WhereNotEndsWith(string, string)

Adds the condition for a string column not to end with some prefix

public virtual TParent WhereNotEndsWith(string columnName, string value)

Parameters

columnName string

Column name

value string

Value

Returns

TParent

WhereNotEquals(IQueryObjectWithValue, object)

Adds the given where condition to the query. Matches the left side which is not equal to the right side.

public virtual TParent WhereNotEquals(IQueryObjectWithValue leftSide, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side

rightSide object

Right side

Returns

TParent

WhereNotEquals(string, object)

Adds the given where condition to the query. Matches the column which is not equal to a given value.

public virtual TParent WhereNotEquals(string columnName, object value)

Parameters

columnName string

Column name

value object

Value

Returns

TParent

WhereNotExists(IDataQuery)

Adds where condition with NOT EXISTS and the nested query "NOT EXISTS (...)"

public virtual TParent WhereNotExists(IDataQuery nestedQuery)

Parameters

nestedQuery IDataQuery

Nested query

Returns

TParent

WhereNotIn(string, IDataQuery)

Adds where condition to the nested query, e.g. "columnName NOT IN (...)"

public virtual TParent WhereNotIn(string columnName, IDataQuery nestedQuery)

Parameters

columnName string

Column name

nestedQuery IDataQuery

Nested query

Returns

TParent

WhereNotIn(string, ICollection<Guid>)

Adds where condition to the list of values, e.g. "columnName NOT IN (...)"

public virtual TParent WhereNotIn(string columnName, ICollection<Guid> values)

Parameters

columnName string

Column name

values ICollection<Guid>

List of values for the query

Returns

TParent

WhereNotIn(string, ICollection<int>)

Adds where condition to the list of values, e.g. "columnName NOT IN (...)"

public virtual TParent WhereNotIn(string columnName, ICollection<int> values)

Parameters

columnName string

Column name

values ICollection<int>

List of values for the query

Returns

TParent

WhereNotIn(string, ICollection<long>)

Adds where condition to the list of values, e.g. "columnName NOT IN (...)"

public virtual TParent WhereNotIn(string columnName, ICollection<long> values)

Parameters

columnName string

Column name

values ICollection<long>

List of values for the query

Returns

TParent

WhereNotIn(string, ICollection<string>)

Adds where condition to the list of values, e.g. "columnName NOT IN (...)"

public virtual TParent WhereNotIn(string columnName, ICollection<string> values)

Parameters

columnName string

Column name

values ICollection<string>

List of values for the query

Returns

TParent

WhereNotIn(string, IEnumerable<Guid>)

Adds where condition to the list of values, e.g. "columnName NOT IN (...)"

public virtual TParent WhereNotIn(string columnName, IEnumerable<Guid> values)

Parameters

columnName string

Column name

values IEnumerable<Guid>

List of values for the query

Returns

TParent

WhereNotIn(string, IEnumerable<int>)

Adds where condition to the list of values, e.g. "columnName NOT IN (...)"

public TParent WhereNotIn(string columnName, IEnumerable<int> values)

Parameters

columnName string

Column name

values IEnumerable<int>

List of values for the query

Returns

TParent

WhereNotIn(string, IEnumerable<long>)

Adds where condition to the list of values, e.g. "columnName NOT IN (...)"

public TParent WhereNotIn(string columnName, IEnumerable<long> values)

Parameters

columnName string

Column name

values IEnumerable<long>

List of values for the query

Returns

TParent

WhereNotIn(string, IEnumerable<string>)

Adds where condition to the list of values, e.g. "columnName NOT IN (...)"

public TParent WhereNotIn(string columnName, IEnumerable<string> values)

Parameters

columnName string

Column name

values IEnumerable<string>

List of values for the query

Returns

TParent

WhereNotLike(IQueryObjectWithValue, object)

Adds the given where condition to the query. Matches the left side and right side using NOT LIKE operator.

public virtual TParent WhereNotLike(IQueryObjectWithValue leftSide, object rightSide)

Parameters

leftSide IQueryObjectWithValue

Left side

rightSide object

Right side

Returns

TParent

WhereNotLike(string, string)

Adds the given where condition to the query. Matches the column to a given value using NOT LIKE operator.

public virtual TParent WhereNotLike(string columnName, string value)

Parameters

columnName string

Column name

value string

Value

Returns

TParent

WhereNotNull(IQueryObjectWithValue)

Adds the where condition for a not null expression value

public virtual TParent WhereNotNull(IQueryObjectWithValue expression)

Parameters

expression IQueryObjectWithValue

Expression

Returns

TParent

WhereNotNull(string)

Adds the where condition for a not null column value

public virtual TParent WhereNotNull(string columnName)

Parameters

columnName string

Column name

Returns

TParent

WhereNotStartsWith(IQueryObjectWithValue, string)

Adds the condition for a string column not to start with some prefix

public virtual TParent WhereNotStartsWith(IQueryObjectWithValue expression, string value)

Parameters

expression IQueryObjectWithValue

Expression

value string

Value

Returns

TParent

WhereNotStartsWith(string, string)

Adds the condition for a string column not to start with some prefix

public virtual TParent WhereNotStartsWith(string columnName, string value)

Parameters

columnName string

Column name

value string

Value

Returns

TParent

WhereNull(IQueryObjectWithValue)

Adds the where condition for a null expression value

public virtual TParent WhereNull(IQueryObjectWithValue expression)

Parameters

expression IQueryObjectWithValue

Expression

Returns

TParent

WhereNull(string)

Adds the where condition for a null column value

public virtual TParent WhereNull(string columnName)

Parameters

columnName string

Column name

Returns

TParent

WhereStartsWith(IQueryObjectWithValue, string)

Adds the condition for a string column to start with some prefix

public virtual TParent WhereStartsWith(IQueryObjectWithValue expression, string value)

Parameters

expression IQueryObjectWithValue

Expression

value string

Value

Returns

TParent

WhereStartsWith(string, string)

Adds the condition for a string column to start with some prefix

public virtual TParent WhereStartsWith(string columnName, string value)

Parameters

columnName string

Column name

value string

Value

Returns

TParent

WhereTrue(IQueryObjectWithValue)

Adds the where condition for a true expression value (boolean expression equals true).

public virtual TParent WhereTrue(IQueryObjectWithValue expression)

Parameters

expression IQueryObjectWithValue

Column name

Returns

TParent

WhereTrue(string)

Adds the where condition for a true column value (boolean column equals true).

public virtual TParent WhereTrue(string columnName)

Parameters

columnName string

Column name

Returns

TParent