C# Класс Hd.QueryExtensions.WhereTerm

Наследование: ICloneable

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
Clone ( ) : WhereTerm	Creates a copy of this WhereTerm
CreateBetween ( SqlExpression expr, SqlExpression lowBound, SqlExpression highBound ) : WhereTerm	Creates a WhereTerm which checks weather a value is in a specifed range. CreateBetween only accepts expressions which yeild a 'Date' or 'Number' values. All expressions must be of compatible types.
CreateCompare ( SqlExpression expr1, SqlExpression expr2, CompareOperator op ) : WhereTerm	Creates a comparison WhereTerm. A comparison term compares two expression on the basis of their values. Expressions can be of any type but their results must be of comparible types. For instance, you can not compare a database field of type 'date' and a static value of type 'int'.
CreateExists ( string sql ) : WhereTerm	Creates a WhereTerm which encapsulates SQL EXISTS clause
CreateIn ( SqlExpression expr, SqlConstantCollection values ) : WhereTerm	Creates a WhereTerm which represents SQL IN clause
CreateIn ( SqlExpression expr, string sql ) : WhereTerm	Creates a WhereTerm which represents SQL IN clause
CreateIsNotNull ( SqlExpression expr ) : WhereTerm	Creates a WhereTerm which returns TRUE if an expression is NOT NULL
CreateIsNull ( SqlExpression expr ) : WhereTerm	Creates a WhereTerm which returns TRUE if an expression is NULL
CreateNotExists ( string sql ) : WhereTerm	Creates a WhereTerm which encapsulates SQL NOT EXISTS clause
CreateNotIn ( SqlExpression expr, SqlConstantCollection values ) : WhereTerm	Creates a WhereTerm which represents SQL NOT IN clause
CreateNotIn ( SqlExpression expr, string sql ) : WhereTerm	Creates a WhereTerm which represents SQL NOT IN clause
WhereTerm ( ) : System

Приватные методы

Метод	Описание
ICloneable ( ) : object

Описание методов

Clone() публичный Метод

Creates a copy of this WhereTerm

public Clone ( ) : WhereTerm
Результат	WhereTerm

CreateBetween() публичный статический Метод

Creates a WhereTerm which checks weather a value is in a specifed range.

CreateBetween only accepts expressions which yeild a 'Date' or 'Number' values. All expressions must be of compatible types.

public static CreateBetween ( SqlExpression expr, SqlExpression lowBound, SqlExpression highBound ) : WhereTerm
expr	SqlExpression	Expression which yeilds the value to be checked
lowBound	SqlExpression	Expression which yeilds the low bound of the range
highBound	SqlExpression	Expression which yeilds the high bound of the range
Результат	WhereTerm

CreateCompare() публичный статический Метод

Creates a comparison WhereTerm.

A comparison term compares two expression on the basis of their values. Expressions can be of any type but their results must be of comparible types. For instance, you can not compare a database field of type 'date' and a static value of type 'int'.

public static CreateCompare ( SqlExpression expr1, SqlExpression expr2, CompareOperator op ) : WhereTerm
expr1	SqlExpression	Expression on the left side of the operator
expr2	SqlExpression	Expression on the right side of the operator
op	CompareOperator	Conditional operator to be applied on the expressions
Результат	WhereTerm

CreateExists() публичный статический Метод

Creates a WhereTerm which encapsulates SQL EXISTS clause

public static CreateExists ( string sql ) : WhereTerm
sql	string	Sub query for the EXISTS clause
Результат	WhereTerm

CreateIn() публичный статический Метод

Creates a WhereTerm which represents SQL IN clause

public static CreateIn ( SqlExpression expr, SqlConstantCollection values ) : WhereTerm
expr	SqlExpression	Expression to be looked up
values	SqlConstantCollection	List of values
Результат	WhereTerm

CreateIn() публичный статический Метод

Creates a WhereTerm which represents SQL IN clause

public static CreateIn ( SqlExpression expr, string sql ) : WhereTerm
expr	SqlExpression	Expression to be looked up
sql	string	Sub query
Результат	WhereTerm

CreateIsNotNull() публичный статический Метод

Creates a WhereTerm which returns TRUE if an expression is NOT NULL

public static CreateIsNotNull ( SqlExpression expr ) : WhereTerm
expr	SqlExpression
Результат	WhereTerm

CreateIsNull() публичный статический Метод

Creates a WhereTerm which returns TRUE if an expression is NULL

public static CreateIsNull ( SqlExpression expr ) : WhereTerm
expr	SqlExpression	Expression to be evaluated
Результат	WhereTerm

CreateNotExists() публичный статический Метод

Creates a WhereTerm which encapsulates SQL NOT EXISTS clause

public static CreateNotExists ( string sql ) : WhereTerm
sql	string	Sub query for the NOT EXISTS clause
Результат	WhereTerm

CreateNotIn() публичный статический Метод

Creates a WhereTerm which represents SQL NOT IN clause

public static CreateNotIn ( SqlExpression expr, SqlConstantCollection values ) : WhereTerm
expr	SqlExpression	Expression to be looked up
values	SqlConstantCollection
Результат	WhereTerm

CreateNotIn() публичный статический Метод

Creates a WhereTerm which represents SQL NOT IN clause

public static CreateNotIn ( SqlExpression expr, string sql ) : WhereTerm
expr	SqlExpression	Expression to be looked up
sql	string	Sub query
Результат	WhereTerm

WhereTerm() публичный Метод

public WhereTerm ( ) : System
Результат	System