C# Class Hd.QueryExtensions.WhereTerm

Inheritance: ICloneable
Afficher le fichier Open project: TargetProcess/Tp.HelpDesk Class Usage Examples

Méthodes publiques

Méthode 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

Méthode Description
ICloneable ( ) : object

Method Details

Clone() public méthode

Creates a copy of this WhereTerm
public Clone ( ) : WhereTerm
Résultat WhereTerm

CreateBetween() public static méthode

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
Résultat WhereTerm

CreateCompare() public static méthode

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
Résultat WhereTerm

CreateExists() public static méthode

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

CreateIn() public static méthode

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
Résultat WhereTerm

CreateIn() public static méthode

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
Résultat WhereTerm

CreateIsNotNull() public static méthode

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

CreateIsNull() public static méthode

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

CreateNotExists() public static méthode

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

CreateNotIn() public static méthode

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
Résultat WhereTerm

CreateNotIn() public static méthode

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
Résultat WhereTerm

WhereTerm() public méthode

public WhereTerm ( ) : System
Résultat System