C# Class Hd.QueryExtensions.WhereTerm

Inheritance: ICloneable
Mostrar archivo Open project: TargetProcess/Tp.HelpDesk Class Usage Examples

Public Methods

Method Description
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

Private Methods

Method Description
ICloneable ( ) : object

Method Details

Clone() public method

Creates a copy of this WhereTerm
public Clone ( ) : WhereTerm
return WhereTerm

CreateBetween() public static method

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
return WhereTerm

CreateCompare() public static method

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
return WhereTerm

CreateExists() public static method

Creates a WhereTerm which encapsulates SQL EXISTS clause
public static CreateExists ( string sql ) : WhereTerm
sql string Sub query for the EXISTS clause
return WhereTerm

CreateIn() public static method

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
return WhereTerm

CreateIn() public static method

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
return WhereTerm

CreateIsNotNull() public static method

Creates a WhereTerm which returns TRUE if an expression is NOT NULL
public static CreateIsNotNull ( SqlExpression expr ) : WhereTerm
expr SqlExpression
return WhereTerm

CreateIsNull() public static method

Creates a WhereTerm which returns TRUE if an expression is NULL
public static CreateIsNull ( SqlExpression expr ) : WhereTerm
expr SqlExpression Expression to be evaluated
return WhereTerm

CreateNotExists() public static method

Creates a WhereTerm which encapsulates SQL NOT EXISTS clause
public static CreateNotExists ( string sql ) : WhereTerm
sql string Sub query for the NOT EXISTS clause
return WhereTerm

CreateNotIn() public static method

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
return WhereTerm

CreateNotIn() public static method

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
return WhereTerm

WhereTerm() public method

public WhereTerm ( ) : System
return System