C# 클래스 DbExpressions.DbExpressionFactory

Contains the methods to create the various DbExpression types.
파일 보기 프로젝트 열기: seesharper/DbExpressions 1 사용 예제들

공개 메소드들

메소드 설명
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