C# Class DbExpressions.DbExpressionFactory

Contains the methods to create the various DbExpression types.

Datei anzeigen 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