C# Class DbExpressions.DbExpressionFactory

Contains the methods to create the various DbExpression types.
Afficher le fichier Open project: seesharper/DbExpressions Class Usage Examples

Méthodes publiques

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

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.
Résultat DbMathematicalFunctionExpression

Acos() public méthode

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.
Résultat DbMathematicalFunctionExpression

Add() public méthode

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.
Résultat DbBinaryExpression

AddDays() public méthode

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.
Résultat DbDateTimeFunctionExpression

AddHours() public méthode

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.
Résultat DbDateTimeFunctionExpression

AddMilliseconds() public méthode

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.
Résultat DbDateTimeFunctionExpression

AddMinutes() public méthode

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.
Résultat DbDateTimeFunctionExpression

AddMonths() public méthode

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.
Résultat DbDateTimeFunctionExpression

AddSeconds() public méthode

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.
Résultat DbDateTimeFunctionExpression

AddYears() public méthode

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.
Résultat DbDateTimeFunctionExpression

Alias() public méthode

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 .
Résultat DbAliasExpression

And() public méthode

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.
Résultat DbBinaryExpression

Asin() public méthode

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.
Résultat DbMathematicalFunctionExpression

Assign() public méthode

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.
Résultat DbBinaryExpression

Atan() public méthode

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.
Résultat DbMathematicalFunctionExpression

Atan2() public méthode

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).
Résultat DbMathematicalFunctionExpression

Avg() public méthode

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.
Résultat DbAggregateFunctionExpression

Batch() public méthode

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

Cast() public méthode

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.
Résultat DbUnaryExpression

Ceiling() public méthode

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.
Résultat DbMathematicalFunctionExpression

Column() public méthode

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

Column() public méthode

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.
Résultat DbPrefixExpression

Concat() public méthode

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.
Résultat DbConcatExpression

Conditional() public méthode

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.
Résultat DbConditionalExpression

Constant() public méthode

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

Cos() public méthode

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.
Résultat DbMathematicalFunctionExpression

Cot() public méthode

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.
Résultat DbMathematicalFunctionExpression

Count() public méthode

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.
Résultat DbAggregateFunctionExpression

Date() public méthode

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.
Résultat DbDateTimeFunctionExpression

DayOfMonth() public méthode

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.
Résultat DbDateTimeFunctionExpression

DayOfWeek() public méthode

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.
Résultat DbDateTimeFunctionExpression

DayOfYear() public méthode

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.
Résultat DbDateTimeFunctionExpression

Degrees() public méthode

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.
Résultat DbMathematicalFunctionExpression

Delete() public méthode

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.
Résultat DbDeleteExpression

Divide() public méthode

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.
Résultat DbBinaryExpression

Equal() public méthode

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.
Résultat DbBinaryExpression

Exists() public méthode

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

Exists() public méthode

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

Exp() public méthode

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.
Résultat DbMathematicalFunctionExpression

Floor() public méthode

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.
Résultat DbMathematicalFunctionExpression

GreaterThan() public méthode

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.
Résultat DbBinaryExpression

GreaterThanOrEqual() public méthode

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.
Résultat DbBinaryExpression

Hour() public méthode

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.
Résultat DbDateTimeFunctionExpression

In() public méthode

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.
Résultat DbInExpression

In() public méthode

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.
Résultat DbInExpression

In() public méthode

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.
Résultat DbInExpression

InnerJoin() public méthode

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.
Résultat DbJoinExpression

LeftOuterJoin() public méthode

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.
Résultat DbJoinExpression

Length() public méthode

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

LessThan() public méthode

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.
Résultat DbBinaryExpression

LessThanOrEqual() public méthode

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.
Résultat DbBinaryExpression

List() public méthode

Creates a new DbListExpression.
public List ( ) : DbListExpression
Résultat DbListExpression

List() public méthode

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

Log() public méthode

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.
Résultat DbMathematicalFunctionExpression

Log10() public méthode

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.
Résultat DbMathematicalFunctionExpression

MakeAggregateFunction() public méthode

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.
Résultat DbAggregateFunctionExpression

MakeBinary() public méthode

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.
Résultat DbBinaryExpression

MakeDateTimeFunction() public méthode

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.
Résultat DbDateTimeFunctionExpression

MakeJoin() public méthode

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.
Résultat DbJoinExpression

MakeMathematicalFunction() public méthode

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.
Résultat DbMathematicalFunctionExpression

MakeOrderBy() public méthode

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.
Résultat DbOrderByExpression

MakeStringFunction() public méthode

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.
Résultat DbStringFunctionExpression

MakeUnary() public méthode

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.
Résultat DbUnaryExpression

Max() public méthode

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.
Résultat DbAggregateFunctionExpression

Millisecond() public méthode

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.
Résultat DbDateTimeFunctionExpression

Min() public méthode

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.
Résultat DbAggregateFunctionExpression

Minute() public méthode

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.
Résultat DbDateTimeFunctionExpression

Month() public méthode

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.
Résultat DbDateTimeFunctionExpression

Multiply() public méthode

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.
Résultat DbBinaryExpression

Not() public méthode

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.
Résultat DbUnaryExpression

NotEqual() public méthode

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.
Résultat DbBinaryExpression

Now() public méthode

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

Or() public méthode

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.
Résultat DbBinaryExpression

OrderByAscending() public méthode

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.
Résultat DbOrderByExpression

OrderByDescending() public méthode

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.
Résultat DbOrderByExpression

PI() public méthode

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

Power() public méthode

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.
Résultat DbMathematicalFunctionExpression

Prefix() public méthode

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 .
Résultat DbPrefixExpression

Radians() public méthode

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.
Résultat DbMathematicalFunctionExpression

Rand() public méthode

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

Rand() public méthode

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.
Résultat DbMathematicalFunctionExpression

Replace() public méthode

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 .
Résultat DbStringFunctionExpression

Reverse() public méthode

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

RightOuterJoin() public méthode

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.
Résultat DbJoinExpression

Round() public méthode

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.
Résultat DbMathematicalFunctionExpression

Second() public méthode

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.
Résultat DbDateTimeFunctionExpression

Select() public méthode

Creates a new DbSelectQuery that represents a sub query.
public Select ( ) : DbSelectQuery
Résultat DbSelectQuery

Select() public méthode

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

SelectDistinct() public méthode

Creates a new DbSelectQuery that represents a distinct sub query.
public SelectDistinct ( ) : DbSelectQuery
Résultat DbSelectQuery

SelectDistinct() public méthode

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

Sign() public méthode

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.
Résultat DbMathematicalFunctionExpression

Sin() public méthode

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.
Résultat DbMathematicalFunctionExpression

SoundEx() public méthode

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.
Résultat DbStringFunctionExpression

Sql() public méthode

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.
Résultat DbSqlExpression

Sqrt() public méthode

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.
Résultat DbMathematicalFunctionExpression

Square() public méthode

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.
Résultat DbMathematicalFunctionExpression

SubString() public méthode

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.
Résultat DbStringFunctionExpression

Subtract() public méthode

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.
Résultat DbBinaryExpression

Sum() public méthode

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.
Résultat DbAggregateFunctionExpression

Table() public méthode

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.
Résultat DbAliasExpression

Table() public méthode

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

Tan() public méthode

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.
Résultat DbMathematicalFunctionExpression

ToDay() public méthode

Creates a DbDateTimeFunctionExpression that represents returning the current date.
public ToDay ( ) : DbDateTimeFunctionExpression
Résultat DbDateTimeFunctionExpression

ToLower() public méthode

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.
Résultat DbStringFunctionExpression

ToUpper() public méthode

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.
Résultat DbStringFunctionExpression

Trim() public méthode

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.
Résultat DbStringFunctionExpression

TrimEnd() public méthode

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.
Résultat DbStringFunctionExpression

TrimStart() public méthode

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.
Résultat DbStringFunctionExpression

Year() public méthode

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.
Résultat DbDateTimeFunctionExpression