C# Класс DbExpressions.DbExpressionFactory

Contains the methods to create the various DbExpression types.
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
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.

Описание методов

Abs() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Acos() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Add() публичный Метод

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.
Результат DbBinaryExpression

AddDays() публичный Метод

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.
Результат DbDateTimeFunctionExpression

AddHours() публичный Метод

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.
Результат DbDateTimeFunctionExpression

AddMilliseconds() публичный Метод

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.
Результат DbDateTimeFunctionExpression

AddMinutes() публичный Метод

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.
Результат DbDateTimeFunctionExpression

AddMonths() публичный Метод

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.
Результат DbDateTimeFunctionExpression

AddSeconds() публичный Метод

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.
Результат DbDateTimeFunctionExpression

AddYears() публичный Метод

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.
Результат DbDateTimeFunctionExpression

Alias() публичный Метод

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 .
Результат DbAliasExpression

And() публичный Метод

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.
Результат DbBinaryExpression

Asin() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Assign() публичный Метод

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.
Результат DbBinaryExpression

Atan() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Atan2() публичный Метод

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).
Результат DbMathematicalFunctionExpression

Avg() публичный Метод

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.
Результат DbAggregateFunctionExpression

Batch() публичный Метод

Creates a new DbBatchExpression.
public Batch ( IEnumerable dbExpressions ) : DbBatchExpression
dbExpressions IEnumerable A that /// contains instances to be copied represented by the .
Результат DbBatchExpression

Cast() публичный Метод

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.
Результат DbUnaryExpression

Ceiling() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Column() публичный Метод

Creates a new DbColumnExpression.
public Column ( string columnName ) : DbColumnExpression
columnName string The name of the column.
Результат DbColumnExpression

Column() публичный Метод

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.
Результат DbPrefixExpression

Concat() публичный Метод

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.
Результат DbConcatExpression

Conditional() публичный Метод

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.
Результат DbConditionalExpression

Constant() публичный Метод

Creates a new DbConstantExpression.
public Constant ( object value ) : DbConstantExpression
value object The value that this represents.
Результат DbConstantExpression

Cos() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Cot() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Count() публичный Метод

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.
Результат DbAggregateFunctionExpression

Date() публичный Метод

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.
Результат DbDateTimeFunctionExpression

DayOfMonth() публичный Метод

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.
Результат DbDateTimeFunctionExpression

DayOfWeek() публичный Метод

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.
Результат DbDateTimeFunctionExpression

DayOfYear() публичный Метод

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.
Результат DbDateTimeFunctionExpression

Degrees() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Delete() публичный Метод

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.
Результат DbDeleteExpression

Divide() публичный Метод

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.
Результат DbBinaryExpression

Equal() публичный Метод

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.
Результат DbBinaryExpression

Exists() публичный Метод

Creates a new DbExistsExpression.
public Exists ( DbQuery subSelectQuery ) : DbExistsExpression
subSelectQuery DbQuery The that is used as the sub query.
Результат DbExistsExpression

Exists() публичный Метод

Creates a new DbExistsExpression.
public Exists ( Func subQuerySelector ) : DbExistsExpression
subQuerySelector Func The that is used as the sub query.
Результат DbExistsExpression

Exp() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Floor() публичный Метод

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.
Результат DbMathematicalFunctionExpression

GreaterThan() публичный Метод

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.
Результат DbBinaryExpression

GreaterThanOrEqual() публичный Метод

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.
Результат DbBinaryExpression

Hour() публичный Метод

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.
Результат DbDateTimeFunctionExpression

In() публичный Метод

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.
Результат DbInExpression

In() публичный Метод

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.
Результат DbInExpression

In() публичный Метод

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.
Результат DbInExpression

InnerJoin() публичный Метод

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.
Результат DbJoinExpression

LeftOuterJoin() публичный Метод

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.
Результат DbJoinExpression

Length() публичный Метод

Creates a DbStringFunctionExpression that returns the length of the expression.
public Length ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The that represents the string to convert.
Результат DbStringFunctionExpression

LessThan() публичный Метод

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.
Результат DbBinaryExpression

LessThanOrEqual() публичный Метод

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.
Результат DbBinaryExpression

List() публичный Метод

Creates a new DbListExpression.
public List ( ) : DbListExpression
Результат DbListExpression

List() публичный Метод

Creates a new DbListExpression.
public List ( IEnumerable dbExpressions ) : DbListExpression
dbExpressions IEnumerable A that /// contains instances to be copied to the new list.
Результат DbListExpression

Log() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Log10() публичный Метод

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.
Результат DbMathematicalFunctionExpression

MakeAggregateFunction() публичный Метод

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.
Результат DbAggregateFunctionExpression

MakeBinary() публичный Метод

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.
Результат DbBinaryExpression

MakeDateTimeFunction() публичный Метод

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.
Результат DbDateTimeFunctionExpression

MakeJoin() публичный Метод

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.
Результат DbJoinExpression

MakeMathematicalFunction() публичный Метод

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.
Результат DbMathematicalFunctionExpression

MakeOrderBy() публичный Метод

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.
Результат DbOrderByExpression

MakeStringFunction() публичный Метод

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.
Результат DbStringFunctionExpression

MakeUnary() публичный Метод

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.
Результат DbUnaryExpression

Max() публичный Метод

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.
Результат DbAggregateFunctionExpression

Millisecond() публичный Метод

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.
Результат DbDateTimeFunctionExpression

Min() публичный Метод

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.
Результат DbAggregateFunctionExpression

Minute() публичный Метод

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.
Результат DbDateTimeFunctionExpression

Month() публичный Метод

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.
Результат DbDateTimeFunctionExpression

Multiply() публичный Метод

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.
Результат DbBinaryExpression

Not() публичный Метод

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.
Результат DbUnaryExpression

NotEqual() публичный Метод

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.
Результат DbBinaryExpression

Now() публичный Метод

Creates a DbDateTimeFunctionExpression that represents returning the current date and time.
public Now ( ) : DbDateTimeFunctionExpression
Результат DbDateTimeFunctionExpression

Or() публичный Метод

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.
Результат DbBinaryExpression

OrderByAscending() публичный Метод

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.
Результат DbOrderByExpression

OrderByDescending() публичный Метод

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.
Результат DbOrderByExpression

PI() публичный Метод

Creates a DbMathematicalFunctionExpression that represents returning the constant value of PI.
public PI ( ) : DbMathematicalFunctionExpression
Результат DbMathematicalFunctionExpression

Power() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Prefix() публичный Метод

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 .
Результат DbPrefixExpression

Radians() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Rand() публичный Метод

Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.
public Rand ( ) : DbMathematicalFunctionExpression
Результат DbMathematicalFunctionExpression

Rand() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Replace() публичный Метод

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 .
Результат DbStringFunctionExpression

Reverse() публичный Метод

Creates a DbStringFunctionExpression that represents reversing a string value.
public Reverse ( DbExpression expression ) : DbStringFunctionExpression
expression DbExpression The to convert.
Результат DbStringFunctionExpression

RightOuterJoin() публичный Метод

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.
Результат DbJoinExpression

Round() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Second() публичный Метод

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.
Результат DbDateTimeFunctionExpression

Select() публичный Метод

Creates a new DbSelectQuery that represents a sub query.
public Select ( ) : DbSelectQuery
Результат DbSelectQuery

Select() публичный Метод

Creates a new DbSelectQuery that represents a sub query.
public Select ( DbExpression expression ) : DbSelectQuery
expression DbExpression The that represents the projection.
Результат DbSelectQuery

SelectDistinct() публичный Метод

Creates a new DbSelectQuery that represents a distinct sub query.
public SelectDistinct ( ) : DbSelectQuery
Результат DbSelectQuery

SelectDistinct() публичный Метод

Creates a new DbSelectQuery that represents a distinct sub query.
public SelectDistinct ( DbExpression expression ) : DbSelectQuery
expression DbExpression The that represents the projection.
Результат DbSelectQuery

Sign() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Sin() публичный Метод

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.
Результат DbMathematicalFunctionExpression

SoundEx() публичный Метод

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.
Результат DbStringFunctionExpression

Sql() публичный Метод

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.
Результат DbSqlExpression

Sqrt() публичный Метод

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.
Результат DbMathematicalFunctionExpression

Square() публичный Метод

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.
Результат DbMathematicalFunctionExpression

SubString() публичный Метод

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.
Результат DbStringFunctionExpression

Subtract() публичный Метод

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.
Результат DbBinaryExpression

Sum() публичный Метод

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.
Результат DbAggregateFunctionExpression

Table() публичный Метод

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.
Результат DbAliasExpression

Table() публичный Метод

Creates a new DbColumnExpression.
public Table ( string tableName ) : DbTableExpression
tableName string The name of the table.
Результат DbTableExpression

Tan() публичный Метод

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.
Результат DbMathematicalFunctionExpression

ToDay() публичный Метод

Creates a DbDateTimeFunctionExpression that represents returning the current date.
public ToDay ( ) : DbDateTimeFunctionExpression
Результат DbDateTimeFunctionExpression

ToLower() публичный Метод

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.
Результат DbStringFunctionExpression

ToUpper() публичный Метод

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.
Результат DbStringFunctionExpression

Trim() публичный Метод

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.
Результат DbStringFunctionExpression

TrimEnd() публичный Метод

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.
Результат DbStringFunctionExpression

TrimStart() публичный Метод

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.
Результат DbStringFunctionExpression

Year() публичный Метод

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.
Результат DbDateTimeFunctionExpression