C# Class DbExpressions.DbExpressionFactory

Contains the methods to create the various DbExpression types.
Mostra file Open project: seesharper/DbExpressions Class Usage Examples

Public Methods

Method Description
Abs ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the absolute (positive) value of the specified numeric expression.

Acos ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the angle, in radians, whose cosine is the specified float expression; also called arccosine.

Add ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents arithmetic addition.

AddDays ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents adding the specified number of days to the target date time.

AddHours ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents adding the specified number of hours to the target date time.

AddMilliseconds ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents adding the specified number of milliseconds to the target date time.

AddMinutes ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents adding the specified number of minutes to the target date time.

AddMonths ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents adding the specified number of months to the target date time.

AddSeconds ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents adding the specified number of seconds to the target date time.

AddYears ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents adding the specified number of years to the target date time.

Alias ( DbExpression target, string alias ) : DbAliasExpression

Creates a new DbAliasExpression.

And ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents a logical AND operation.

Asin ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the angle, in radians, whose cosine is the specified float expression; also called arccosine.

Assign ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents a column or variable assignment.

Atan ( DbExpression expression ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the angle in radians whose tangent is a specified float expression. This is also called arctangent.

Atan2 ( DbExpression x, DbExpression y ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values of the two specified float expressions.

Avg ( DbExpression target ) : DbAggregateFunctionExpression

Creates a DbAggregateFunctionExpression that represents returning the average of the values in the target expression.

Batch ( IEnumerable dbExpressions ) : DbBatchExpression

Creates a new DbBatchExpression.

Cast ( DbExpression operand, Type targetType ) : DbUnaryExpression

Creates a new DbUnaryExpression that represents a conversion operation.

Ceiling ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the smallest integer greater than, or equal to, the specified numeric expression.

Column ( string columnName ) : DbColumnExpression

Creates a new DbColumnExpression.

Column ( string prefix, string columnName ) : DbPrefixExpression

Creates a new DbColumnExpression that is wrapped inside a DbPrefixExpression.

Concat ( DbExpression leftExpression, DbExpression rightExpression ) : DbConcatExpression

Creates a new DbConcatExpression.

Conditional ( DbExpression condition, DbExpression trueExpression, DbExpression falseExpression ) : DbConditionalExpression

Creates a new DbConditionalExpression.

Constant ( object value ) : DbConstantExpression

Creates a new DbConstantExpression.

Cos ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the trigonometric cosine of the specified angle, in radians, in the specified expression.

Cot ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the trigonometric cotangent of the specified angle, in radians, in the specified float expression.

Count ( DbExpression target ) : DbAggregateFunctionExpression

Creates a DbAggregateFunctionExpression that represents returning the number of items in the target expression.

Date ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning the date portion of a date time value.

DayOfMonth ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning the day of the month.

DayOfWeek ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning the day of the week.

DayOfYear ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning the day of the year.

Degrees ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the corresponding angle in degrees for an angle specified in radians.

Delete ( DbExpression target, DbExpression fromExpression, DbExpression whereExpression ) : DbDeleteExpression

Creates a new DbDeleteExpression that represents delete statement.

Divide ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents arithmetic division.

Equal ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents an equality comparison.

Exists ( DbQuery subSelectQuery ) : DbExistsExpression

Creates a new DbExistsExpression.

Exists ( Func subQuerySelector ) : DbExistsExpression

Creates a new DbExistsExpression.

Exp ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the exponential value of the specified float expression.

Floor ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the largest integer less than or equal to the specified numeric expression.

GreaterThan ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents a 'greater than' comparison.

GreaterThanOrEqual ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents a 'greater than or equal' comparison.

Hour ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning hour component of a date/time value.

In ( DbExpression target, DbExpression expression ) : DbInExpression

Creates a new DbInExpression.

In ( DbExpression target, DbQuery selectQuery ) : DbInExpression

Creates a new DbInExpression.

In ( DbExpression target, object values ) : DbInExpression

Creates a new DbInExpression.

InnerJoin ( DbExpression target, DbExpression condition ) : DbJoinExpression

Create a new DbJoinExpression that represents an 'INNER JOIN'.

LeftOuterJoin ( DbExpression target, DbExpression condition ) : DbJoinExpression

Create a new DbJoinExpression that represents a 'LEFT OUTER JOIN'.

Length ( DbExpression expression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that returns the length of the expression.

LessThan ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents a 'less than' comparison.

LessThanOrEqual ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents a 'less than or equal' comparison.

List ( ) : DbListExpression

Creates a new DbListExpression.

List ( IEnumerable dbExpressions ) : DbListExpression

Creates a new DbListExpression.

Log ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the natural logarithm of the specified float expression.

Log10 ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the base-10 logarithm of the specified float expression.

MakeAggregateFunction ( DbAggregateFunctionExpressionType aggregateFunctionExpressionType, DbExpression target ) : DbAggregateFunctionExpression

Creates a DbAggregateFunctionExpression.

MakeBinary ( DbBinaryExpressionType binaryExpressionType, DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression.

MakeDateTimeFunction ( DbDateTimeFunctionExpressionType dateTimeFunctionExpressionType, DbExpression arguments ) : DbDateTimeFunctionExpression

Creates a new DbDateTimeFunctionExpression.

MakeJoin ( DbJoinExpressionType joinType, DbExpression target, DbExpression condition ) : DbJoinExpression

Creates a new DbJoinExpression.

MakeMathematicalFunction ( DbMathematicalFunctionExpressionType mathematicalFunctionExpressionType, DbExpression arguments ) : DbMathematicalFunctionExpression

Creates a new DbDateTimeFunctionExpression.

MakeOrderBy ( DbOrderByExpressionType orderByExpressionType, DbExpression expression ) : DbOrderByExpression

Creates a new DbOrderByExpression that represents ordering the result set.

MakeStringFunction ( DbStringFunctionExpressionType stringFunctionExpressionType, DbExpression arguments ) : DbStringFunctionExpression

Creates a new DbStringFunctionExpression.

MakeUnary ( DbUnaryExpressionType unaryExpressionType, DbExpression operand, Type targetType ) : DbUnaryExpression

Creates a new DbUnaryExpression.

Max ( DbExpression target ) : DbAggregateFunctionExpression

Creates a DbAggregateFunctionExpression that represents returning the maximum value in the target expression.

Millisecond ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning millisecond component of a date/time value.

Min ( DbExpression target ) : DbAggregateFunctionExpression

Creates a DbAggregateFunctionExpression that represents returning the minimum value in the target expression.

Minute ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning minute component of a date/time value.

Month ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning month component of a date/time value.

Multiply ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents arithmetic multiplication.

Not ( DbExpression operand ) : DbUnaryExpression

Creates a new DbUnaryExpression that represents negating the result of a boolean DbExpression.

NotEqual ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents an inequality comparison.

Now ( ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning the current date and time.

Or ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents a logical OR operation.

OrderByAscending ( DbExpression expression ) : DbOrderByExpression

Creates a new DbOrderByExpression that represents an ascending ordering of the result set.

OrderByDescending ( DbExpression expression ) : DbOrderByExpression

Creates a new DbOrderByExpression that represents an descending ordering of the result set.

PI ( ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the constant value of PI.

Power ( DbExpression target, DbExpression y ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the value of the specified expression to the specified power.

Prefix ( DbExpression target, string prefix ) : DbPrefixExpression

Creates a new DbPrefixExpression.

Radians ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the radians of the specified numeric expression.

Rand ( ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.

Rand ( DbExpression seed ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.

Replace ( DbExpression expression, DbExpression oldValue, DbExpression newValue ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that represents replacing all occurrences of a specified string value with another string value.

Reverse ( DbExpression expression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that represents reversing a string value.

RightOuterJoin ( DbExpression target, DbExpression condition ) : DbJoinExpression

Create a new DbJoinExpression that represents a 'RIGHT OUTER JOIN'.

Round ( DbExpression target, DbExpression precision ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.

Second ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning second component of a date/time value.

Select ( ) : DbSelectQuery

Creates a new DbSelectQuery that represents a sub query.

Select ( DbExpression expression ) : DbSelectQuery

Creates a new DbSelectQuery that represents a sub query.

SelectDistinct ( ) : DbSelectQuery

Creates a new DbSelectQuery that represents a distinct sub query.

SelectDistinct ( DbExpression expression ) : DbSelectQuery

Creates a new DbSelectQuery that represents a distinct sub query.

Sign ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the positive (+1), zero (0), or negative (-1) sign of the specified expression.

Sin ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression.

SoundEx ( DbExpression expression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that represents returning a four-character code to evaluate the similarity of two strings.

Sql ( string sqlFragment ) : DbSqlExpression

Creates a new DbSqlExpression that represents the SQL created when translating a DbExpression instance.

Sqrt ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the square root of the specified float value.

Square ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the square of the specified float value.

SubString ( DbExpression expression, DbExpression startExpression, DbExpression lengthExpression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that represents returning the substring from a string.

Subtract ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression

Creates a DbBinaryExpression that represents arithmetic subtraction.

Sum ( DbExpression target ) : DbAggregateFunctionExpression

Creates a DbAggregateFunctionExpression that represents returning the sum of all values in the target expression.

Table ( string tableName, string alias ) : DbAliasExpression

Creates a new DbTableExpression that is wrapped inside a DbAliasExpression.

Table ( string tableName ) : DbTableExpression

Creates a new DbColumnExpression.

Tan ( DbExpression target ) : DbMathematicalFunctionExpression

Creates a DbMathematicalFunctionExpression that represents returning the tangent of the input expression.

ToDay ( ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning the current date.

ToLower ( DbExpression expression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that converts the result of the expression to an 'lower' textual representation.

ToUpper ( DbExpression expression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that converts the result of the expression to an 'UPPER' textual representation.

Trim ( DbExpression expression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that represents removing all leading and trailing spaces from a string.

TrimEnd ( DbExpression expression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that represents removing all trailing spaces from a string.

TrimStart ( DbExpression expression ) : DbStringFunctionExpression

Creates a DbStringFunctionExpression that represents removing all leading spaces from a string.

Year ( DbExpression target ) : DbDateTimeFunctionExpression

Creates a DbDateTimeFunctionExpression that represents returning year component of a date/time value.

Method Details

Abs() public method

Creates a DbMathematicalFunctionExpression that represents returning the absolute (positive) value of the specified numeric expression.
public Abs ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Acos() public method

Creates a DbMathematicalFunctionExpression that represents returning the angle, in radians, whose cosine is the specified float expression; also called arccosine.
public Acos ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Add() public method

Creates a DbBinaryExpression that represents arithmetic addition.
public Add ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

AddDays() public method

Creates a DbDateTimeFunctionExpression that represents adding the specified number of days to the target date time.
public AddDays ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
numberExpression DbExpression A that represents the number of days to add.
return DbDateTimeFunctionExpression

AddHours() public method

Creates a DbDateTimeFunctionExpression that represents adding the specified number of hours to the target date time.
public AddHours ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
numberExpression DbExpression A that represents the number of hours to add.
return DbDateTimeFunctionExpression

AddMilliseconds() public method

Creates a DbDateTimeFunctionExpression that represents adding the specified number of milliseconds to the target date time.
public AddMilliseconds ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
numberExpression DbExpression A that represents the number of milliseconds to add.
return DbDateTimeFunctionExpression

AddMinutes() public method

Creates a DbDateTimeFunctionExpression that represents adding the specified number of minutes to the target date time.
public AddMinutes ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
numberExpression DbExpression A that represents the number of minutes to add.
return DbDateTimeFunctionExpression

AddMonths() public method

Creates a DbDateTimeFunctionExpression that represents adding the specified number of months to the target date time.
public AddMonths ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
numberExpression DbExpression A that represents the number of months to add.
return DbDateTimeFunctionExpression

AddSeconds() public method

Creates a DbDateTimeFunctionExpression that represents adding the specified number of seconds to the target date time.
public AddSeconds ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
numberExpression DbExpression A that represents the number of seconds to add.
return DbDateTimeFunctionExpression

AddYears() public method

Creates a DbDateTimeFunctionExpression that represents adding the specified number of years to the target date time.
public AddYears ( DbExpression target, DbExpression numberExpression ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
numberExpression DbExpression A that represents the number of years to add.
return DbDateTimeFunctionExpression

Alias() public method

Creates a new DbAliasExpression.
public Alias ( DbExpression target, string alias ) : DbAliasExpression
target DbExpression The target to be aliased.
alias string the alias to be used to reference the .
return DbAliasExpression

And() public method

Creates a DbBinaryExpression that represents a logical AND operation.
public And ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

Asin() public method

Creates a DbMathematicalFunctionExpression that represents returning the angle, in radians, whose cosine is the specified float expression; also called arccosine.
public Asin ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Assign() public method

Creates a DbBinaryExpression that represents a column or variable assignment.
public Assign ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

Atan() public method

Creates a DbMathematicalFunctionExpression that represents returning the angle in radians whose tangent is a specified float expression. This is also called arctangent.
public Atan ( DbExpression expression ) : DbMathematicalFunctionExpression
expression DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Atan2() public method

Creates a DbMathematicalFunctionExpression that represents returning the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values of the two specified float expressions.
public Atan2 ( DbExpression x, DbExpression y ) : DbMathematicalFunctionExpression
x DbExpression A that represents a numeric value (x).
y DbExpression A that represents a numeric value (y).
return DbMathematicalFunctionExpression

Avg() public method

Creates a DbAggregateFunctionExpression that represents returning the average of the values in the target expression.
public Avg ( DbExpression target ) : DbAggregateFunctionExpression
target DbExpression The that the aggregate function operates on.
return DbAggregateFunctionExpression

Batch() public method

Creates a new DbBatchExpression.
public Batch ( IEnumerable dbExpressions ) : DbBatchExpression
dbExpressions IEnumerable A that /// contains instances to be copied represented by the .
return DbBatchExpression

Cast() public method

Creates a new DbUnaryExpression that represents a conversion operation.
public Cast ( DbExpression operand, Type targetType ) : DbUnaryExpression
operand DbExpression The that represents the unary operand.
targetType System.Type The that specifies the type to convert to.
return DbUnaryExpression

Ceiling() public method

Creates a DbMathematicalFunctionExpression that represents returning the smallest integer greater than, or equal to, the specified numeric expression.
public Ceiling ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Column() public method

Creates a new DbColumnExpression.
public Column ( string columnName ) : DbColumnExpression
columnName string The name of the column.
return DbColumnExpression

Column() public method

Creates a new DbColumnExpression that is wrapped inside a DbPrefixExpression.
public Column ( string prefix, string columnName ) : DbPrefixExpression
prefix string The column prefix.
columnName string The name of the column.
return DbPrefixExpression

Concat() public method

Creates a new DbConcatExpression.
public Concat ( DbExpression leftExpression, DbExpression rightExpression ) : DbConcatExpression
leftExpression DbExpression The left operand of the concatenate operation.
rightExpression DbExpression The right operand of the concatenate operation.
return DbConcatExpression

Conditional() public method

Creates a new DbConditionalExpression.
public Conditional ( DbExpression condition, DbExpression trueExpression, DbExpression falseExpression ) : DbConditionalExpression
condition DbExpression The that is evaluated.
trueExpression DbExpression The that is executed if the evaluates to true.
falseExpression DbExpression The that is executed if the evaluates to false.
return DbConditionalExpression

Constant() public method

Creates a new DbConstantExpression.
public Constant ( object value ) : DbConstantExpression
value object The value that this represents.
return DbConstantExpression

Cos() public method

Creates a DbMathematicalFunctionExpression that represents returning the trigonometric cosine of the specified angle, in radians, in the specified expression.
public Cos ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Cot() public method

Creates a DbMathematicalFunctionExpression that represents returning the trigonometric cotangent of the specified angle, in radians, in the specified float expression.
public Cot ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Count() public method

Creates a DbAggregateFunctionExpression that represents returning the number of items in the target expression.
public Count ( DbExpression target ) : DbAggregateFunctionExpression
target DbExpression The that the aggregate function operates on.
return DbAggregateFunctionExpression

Date() public method

Creates a DbDateTimeFunctionExpression that represents returning the date portion of a date time value.
public Date ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

DayOfMonth() public method

Creates a DbDateTimeFunctionExpression that represents returning the day of the month.
public DayOfMonth ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

DayOfWeek() public method

Creates a DbDateTimeFunctionExpression that represents returning the day of the week.
public DayOfWeek ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

DayOfYear() public method

Creates a DbDateTimeFunctionExpression that represents returning the day of the year.
public DayOfYear ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

Degrees() public method

Creates a DbMathematicalFunctionExpression that represents returning the corresponding angle in degrees for an angle specified in radians.
public Degrees ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Delete() public method

Creates a new DbDeleteExpression that represents delete statement.
public Delete ( DbExpression target, DbExpression fromExpression, DbExpression whereExpression ) : DbDeleteExpression
target DbExpression The that represents the delete target.
fromExpression DbExpression The that represents the 'FROM' clause of the query.
whereExpression DbExpression the that represents the 'WHERE' clause of the query.
return DbDeleteExpression

Divide() public method

Creates a DbBinaryExpression that represents arithmetic division.
public Divide ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

Equal() public method

Creates a DbBinaryExpression that represents an equality comparison.
public Equal ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

Exists() public method

Creates a new DbExistsExpression.
public Exists ( DbQuery subSelectQuery ) : DbExistsExpression
subSelectQuery DbQuery The that is used as the sub query.
return DbExistsExpression

Exists() public method

Creates a new DbExistsExpression.
public Exists ( Func subQuerySelector ) : DbExistsExpression
subQuerySelector Func The that is used as the sub query.
return DbExistsExpression

Exp() public method

Creates a DbMathematicalFunctionExpression that represents returning the exponential value of the specified float expression.
public Exp ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Floor() public method

Creates a DbMathematicalFunctionExpression that represents returning the largest integer less than or equal to the specified numeric expression.
public Floor ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

GreaterThan() public method

Creates a DbBinaryExpression that represents a 'greater than' comparison.
public GreaterThan ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

GreaterThanOrEqual() public method

Creates a DbBinaryExpression that represents a 'greater than or equal' comparison.
public GreaterThanOrEqual ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

Hour() public method

Creates a DbDateTimeFunctionExpression that represents returning hour component of a date/time value.
public Hour ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

In() public method

Creates a new DbInExpression.
public In ( DbExpression target, DbExpression expression ) : DbInExpression
target DbExpression The target .
expression DbExpression The that represents a set of values or a sub query.
return DbInExpression

In() public method

Creates a new DbInExpression.
public In ( DbExpression target, DbQuery selectQuery ) : DbInExpression
target DbExpression The target .
selectQuery DbQuery A sub query that has a result set of one column.
return DbInExpression

In() public method

Creates a new DbInExpression.
public In ( DbExpression target, object values ) : DbInExpression
target DbExpression The target .
values object A list of values to test for a match.
return DbInExpression

InnerJoin() public method

Create a new DbJoinExpression that represents an 'INNER JOIN'.
public InnerJoin ( DbExpression target, DbExpression condition ) : DbJoinExpression
target DbExpression The join target.
condition DbExpression The join condition.
return DbJoinExpression

LeftOuterJoin() public method

Create a new DbJoinExpression that represents a 'LEFT OUTER JOIN'.
public LeftOuterJoin ( DbExpression target, DbExpression condition ) : DbJoinExpression
target DbExpression The join target.
condition DbExpression The join condition.
return DbJoinExpression

Length() public method

Creates a DbStringFunctionExpression that returns the length of the expression.
public Length ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The that represents the string to convert.
return DbStringFunctionExpression

LessThan() public method

Creates a DbBinaryExpression that represents a 'less than' comparison.
public LessThan ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

LessThanOrEqual() public method

Creates a DbBinaryExpression that represents a 'less than or equal' comparison.
public LessThanOrEqual ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

List() public method

Creates a new DbListExpression.
public List ( ) : DbListExpression
return DbListExpression

List() public method

Creates a new DbListExpression.
public List ( IEnumerable dbExpressions ) : DbListExpression
dbExpressions IEnumerable A that /// contains instances to be copied to the new list.
return DbListExpression

Log() public method

Creates a DbMathematicalFunctionExpression that represents returning the natural logarithm of the specified float expression.
public Log ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Log10() public method

Creates a DbMathematicalFunctionExpression that represents returning the base-10 logarithm of the specified float expression.
public Log10 ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

MakeAggregateFunction() public method

Creates a DbAggregateFunctionExpression.
public MakeAggregateFunction ( DbAggregateFunctionExpressionType aggregateFunctionExpressionType, DbExpression target ) : DbAggregateFunctionExpression
aggregateFunctionExpressionType DbAggregateFunctionExpressionType The that specifies the type of aggregate expression to create.
target DbExpression The that the aggregate function operates on.
return DbAggregateFunctionExpression

MakeBinary() public method

Creates a DbBinaryExpression.
public MakeBinary ( DbBinaryExpressionType binaryExpressionType, DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
binaryExpressionType DbBinaryExpressionType The that specifies the type of binary expression to create.
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

MakeDateTimeFunction() public method

Creates a new DbDateTimeFunctionExpression.
public MakeDateTimeFunction ( DbDateTimeFunctionExpressionType dateTimeFunctionExpressionType, DbExpression arguments ) : DbDateTimeFunctionExpression
dateTimeFunctionExpressionType DbDateTimeFunctionExpressionType The that specifies the type of to create.
arguments DbExpression A list of instances that is used as arguments when calling the function.
return DbDateTimeFunctionExpression

MakeJoin() public method

Creates a new DbJoinExpression.
public MakeJoin ( DbJoinExpressionType joinType, DbExpression target, DbExpression condition ) : DbJoinExpression
joinType DbJoinExpressionType The that specifies the type of join to create.
target DbExpression The join target.
condition DbExpression The join condition.
return DbJoinExpression

MakeMathematicalFunction() public method

Creates a new DbDateTimeFunctionExpression.
public MakeMathematicalFunction ( DbMathematicalFunctionExpressionType mathematicalFunctionExpressionType, DbExpression arguments ) : DbMathematicalFunctionExpression
mathematicalFunctionExpressionType DbMathematicalFunctionExpressionType The that specifies the type of to create.
arguments DbExpression A list of instances that is used as arguments when calling the function.
return DbMathematicalFunctionExpression

MakeOrderBy() public method

Creates a new DbOrderByExpression that represents ordering the result set.
public MakeOrderBy ( DbOrderByExpressionType orderByExpressionType, DbExpression expression ) : DbOrderByExpression
orderByExpressionType DbOrderByExpressionType The that specifies the ordering direction.
expression DbExpression The representing an element in the 'ORDER BY' clause.
return DbOrderByExpression

MakeStringFunction() public method

Creates a new DbStringFunctionExpression.
public MakeStringFunction ( DbStringFunctionExpressionType stringFunctionExpressionType, DbExpression arguments ) : DbStringFunctionExpression
stringFunctionExpressionType DbStringFunctionExpressionType The that specifies the type of to create.
arguments DbExpression A list of instances that is used as arguments when calling the function.
return DbStringFunctionExpression

MakeUnary() public method

Creates a new DbUnaryExpression.
public MakeUnary ( DbUnaryExpressionType unaryExpressionType, DbExpression operand, Type targetType ) : DbUnaryExpression
unaryExpressionType DbUnaryExpressionType The that specifies the type of unary expression to create.
operand DbExpression The that represents the unary operand.
targetType System.Type The that specifies the type to convert to.
return DbUnaryExpression

Max() public method

Creates a DbAggregateFunctionExpression that represents returning the maximum value in the target expression.
public Max ( DbExpression target ) : DbAggregateFunctionExpression
target DbExpression The that the aggregate function operates on.
return DbAggregateFunctionExpression

Millisecond() public method

Creates a DbDateTimeFunctionExpression that represents returning millisecond component of a date/time value.
public Millisecond ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

Min() public method

Creates a DbAggregateFunctionExpression that represents returning the minimum value in the target expression.
public Min ( DbExpression target ) : DbAggregateFunctionExpression
target DbExpression The that the aggregate function operates on.
return DbAggregateFunctionExpression

Minute() public method

Creates a DbDateTimeFunctionExpression that represents returning minute component of a date/time value.
public Minute ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

Month() public method

Creates a DbDateTimeFunctionExpression that represents returning month component of a date/time value.
public Month ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

Multiply() public method

Creates a DbBinaryExpression that represents arithmetic multiplication.
public Multiply ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

Not() public method

Creates a new DbUnaryExpression that represents negating the result of a boolean DbExpression.
public Not ( DbExpression operand ) : DbUnaryExpression
operand DbExpression The that represents the unary operand.
return DbUnaryExpression

NotEqual() public method

Creates a DbBinaryExpression that represents an inequality comparison.
public NotEqual ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

Now() public method

Creates a DbDateTimeFunctionExpression that represents returning the current date and time.
public Now ( ) : DbDateTimeFunctionExpression
return DbDateTimeFunctionExpression

Or() public method

Creates a DbBinaryExpression that represents a logical OR operation.
public Or ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

OrderByAscending() public method

Creates a new DbOrderByExpression that represents an ascending ordering of the result set.
public OrderByAscending ( DbExpression expression ) : DbOrderByExpression
expression DbExpression The representing an element in the 'ORDER BY' clause.
return DbOrderByExpression

OrderByDescending() public method

Creates a new DbOrderByExpression that represents an descending ordering of the result set.
public OrderByDescending ( DbExpression expression ) : DbOrderByExpression
expression DbExpression The representing an element in the 'ORDER BY' clause.
return DbOrderByExpression

PI() public method

Creates a DbMathematicalFunctionExpression that represents returning the constant value of PI.
public PI ( ) : DbMathematicalFunctionExpression
return DbMathematicalFunctionExpression

Power() public method

Creates a DbMathematicalFunctionExpression that represents returning the value of the specified expression to the specified power.
public Power ( DbExpression target, DbExpression y ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
y DbExpression The power to which to raise the numeric value.
return DbMathematicalFunctionExpression

Prefix() public method

Creates a new DbPrefixExpression.
public Prefix ( DbExpression target, string prefix ) : DbPrefixExpression
target DbExpression The target to be aliased.
prefix string the prefix to be used to reference the .
return DbPrefixExpression

Radians() public method

Creates a DbMathematicalFunctionExpression that represents returning the radians of the specified numeric expression.
public Radians ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Rand() public method

Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.
public Rand ( ) : DbMathematicalFunctionExpression
return DbMathematicalFunctionExpression

Rand() public method

Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.
public Rand ( DbExpression seed ) : DbMathematicalFunctionExpression
seed DbExpression The target that represents the seed value.
return DbMathematicalFunctionExpression

Replace() public method

Creates a DbStringFunctionExpression that represents replacing all occurrences of a specified string value with another string value.
public Replace ( DbExpression expression, DbExpression oldValue, DbExpression newValue ) : DbStringFunctionExpression
expression DbExpression The that represents target string.
oldValue DbExpression The value to be replaced.
newValue DbExpression The value to replace all occurrences of .
return DbStringFunctionExpression

Reverse() public method

Creates a DbStringFunctionExpression that represents reversing a string value.
public Reverse ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The to convert.
return DbStringFunctionExpression

RightOuterJoin() public method

Create a new DbJoinExpression that represents a 'RIGHT OUTER JOIN'.
public RightOuterJoin ( DbExpression target, DbExpression condition ) : DbJoinExpression
target DbExpression The join target.
condition DbExpression The join condition.
return DbJoinExpression

Round() public method

Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.
public Round ( DbExpression target, DbExpression precision ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
precision DbExpression A that represents the number of decimals returned.
return DbMathematicalFunctionExpression

Second() public method

Creates a DbDateTimeFunctionExpression that represents returning second component of a date/time value.
public Second ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression

Select() public method

Creates a new DbSelectQuery that represents a sub query.
public Select ( ) : DbSelectQuery
return DbSelectQuery

Select() public method

Creates a new DbSelectQuery that represents a sub query.
public Select ( DbExpression expression ) : DbSelectQuery
expression DbExpression The that represents the projection.
return DbSelectQuery

SelectDistinct() public method

Creates a new DbSelectQuery that represents a distinct sub query.
public SelectDistinct ( ) : DbSelectQuery
return DbSelectQuery

SelectDistinct() public method

Creates a new DbSelectQuery that represents a distinct sub query.
public SelectDistinct ( DbExpression expression ) : DbSelectQuery
expression DbExpression The that represents the projection.
return DbSelectQuery

Sign() public method

Creates a DbMathematicalFunctionExpression that represents returning the positive (+1), zero (0), or negative (-1) sign of the specified expression.
public Sign ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Sin() public method

Creates a DbMathematicalFunctionExpression that represents returning the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression.
public Sin ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

SoundEx() public method

Creates a DbStringFunctionExpression that represents returning a four-character code to evaluate the similarity of two strings.
public SoundEx ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The that represents the string for which to return the SoundEx code.
return DbStringFunctionExpression

Sql() public method

Creates a new DbSqlExpression that represents the SQL created when translating a DbExpression instance.
public Sql ( string sqlFragment ) : DbSqlExpression
sqlFragment string The SQL that this represents.
return DbSqlExpression

Sqrt() public method

Creates a DbMathematicalFunctionExpression that represents returning the square root of the specified float value.
public Sqrt ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

Square() public method

Creates a DbMathematicalFunctionExpression that represents returning the square of the specified float value.
public Square ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

SubString() public method

Creates a DbStringFunctionExpression that represents returning the substring from a string.
public SubString ( DbExpression expression, DbExpression startExpression, DbExpression lengthExpression ) : DbStringFunctionExpression
expression DbExpression The that represents the string for which to return the substring.
startExpression DbExpression The that represents the staring position.
lengthExpression DbExpression The that represents the length of the sub string.
return DbStringFunctionExpression

Subtract() public method

Creates a DbBinaryExpression that represents arithmetic subtraction.
public Subtract ( DbExpression leftExpression, DbExpression rightExpression ) : DbBinaryExpression
leftExpression DbExpression A that represents the left operand.
rightExpression DbExpression A that represents the right operand.
return DbBinaryExpression

Sum() public method

Creates a DbAggregateFunctionExpression that represents returning the sum of all values in the target expression.
public Sum ( DbExpression target ) : DbAggregateFunctionExpression
target DbExpression The that the aggregate function operates on.
return DbAggregateFunctionExpression

Table() public method

Creates a new DbTableExpression that is wrapped inside a DbAliasExpression.
public Table ( string tableName, string alias ) : DbAliasExpression
tableName string The name of the table.
alias string The table alias.
return DbAliasExpression

Table() public method

Creates a new DbColumnExpression.
public Table ( string tableName ) : DbTableExpression
tableName string The name of the table.
return DbTableExpression

Tan() public method

Creates a DbMathematicalFunctionExpression that represents returning the tangent of the input expression.
public Tan ( DbExpression target ) : DbMathematicalFunctionExpression
target DbExpression The target that represents a numeric value.
return DbMathematicalFunctionExpression

ToDay() public method

Creates a DbDateTimeFunctionExpression that represents returning the current date.
public ToDay ( ) : DbDateTimeFunctionExpression
return DbDateTimeFunctionExpression

ToLower() public method

Creates a DbStringFunctionExpression that converts the result of the expression to an 'lower' textual representation.
public ToLower ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The that represents the string to convert.
return DbStringFunctionExpression

ToUpper() public method

Creates a DbStringFunctionExpression that converts the result of the expression to an 'UPPER' textual representation.
public ToUpper ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The that represents the string to convert.
return DbStringFunctionExpression

Trim() public method

Creates a DbStringFunctionExpression that represents removing all leading and trailing spaces from a string.
public Trim ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The that represents the string to trim.
return DbStringFunctionExpression

TrimEnd() public method

Creates a DbStringFunctionExpression that represents removing all trailing spaces from a string.
public TrimEnd ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The that represents the string to trim.
return DbStringFunctionExpression

TrimStart() public method

Creates a DbStringFunctionExpression that represents removing all leading spaces from a string.
public TrimStart ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The that represents the string to trim.
return DbStringFunctionExpression

Year() public method

Creates a DbDateTimeFunctionExpression that represents returning year component of a date/time value.
public Year ( DbExpression target ) : DbDateTimeFunctionExpression
target DbExpression A that represents the target date time.
return DbDateTimeFunctionExpression