메소드 | 설명 | |
---|---|---|
Abs ( |
Creates a DbMathematicalFunctionExpression that represents returning the absolute (positive) value of the specified numeric expression.
|
|
Acos ( |
Creates a DbMathematicalFunctionExpression that represents returning the angle, in radians, whose cosine is the specified float expression; also called arccosine.
|
|
Add ( |
Creates a DbBinaryExpression that represents arithmetic addition.
|
|
AddDays ( |
Creates a DbDateTimeFunctionExpression that represents adding the specified number of days to the target date time.
|
|
AddHours ( |
Creates a DbDateTimeFunctionExpression that represents adding the specified number of hours to the target date time.
|
|
AddMilliseconds ( |
Creates a DbDateTimeFunctionExpression that represents adding the specified number of milliseconds to the target date time.
|
|
AddMinutes ( |
Creates a DbDateTimeFunctionExpression that represents adding the specified number of minutes to the target date time.
|
|
AddMonths ( |
Creates a DbDateTimeFunctionExpression that represents adding the specified number of months to the target date time.
|
|
AddSeconds ( |
Creates a DbDateTimeFunctionExpression that represents adding the specified number of seconds to the target date time.
|
|
AddYears ( |
Creates a DbDateTimeFunctionExpression that represents adding the specified number of years to the target date time.
|
|
Alias ( |
Creates a new DbAliasExpression.
|
|
And ( |
Creates a DbBinaryExpression that represents a logical AND operation.
|
|
Asin ( |
Creates a DbMathematicalFunctionExpression that represents returning the angle, in radians, whose cosine is the specified float expression; also called arccosine.
|
|
Assign ( |
Creates a DbBinaryExpression that represents a column or variable assignment.
|
|
Atan ( |
Creates a DbMathematicalFunctionExpression that represents returning the angle in radians whose tangent is a specified float expression. This is also called arctangent.
|
|
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.
|
|
Avg ( |
Creates a DbAggregateFunctionExpression that represents returning the average of the values in the target expression.
|
|
Batch ( IEnumerable |
Creates a new DbBatchExpression.
|
|
Cast ( |
Creates a new DbUnaryExpression that represents a conversion operation.
|
|
Ceiling ( |
Creates a DbMathematicalFunctionExpression that represents returning the smallest integer greater than, or equal to, the specified numeric expression.
|
|
Column ( string columnName ) : |
Creates a new DbColumnExpression.
|
|
Column ( string prefix, string columnName ) : |
Creates a new DbColumnExpression that is wrapped inside a DbPrefixExpression.
|
|
Concat ( |
Creates a new DbConcatExpression.
|
|
Conditional ( |
Creates a new DbConditionalExpression.
|
|
Constant ( object value ) : |
Creates a new DbConstantExpression.
|
|
Cos ( |
Creates a DbMathematicalFunctionExpression that represents returning the trigonometric cosine of the specified angle, in radians, in the specified expression.
|
|
Cot ( |
Creates a DbMathematicalFunctionExpression that represents returning the trigonometric cotangent of the specified angle, in radians, in the specified float expression.
|
|
Count ( |
Creates a DbAggregateFunctionExpression that represents returning the number of items in the target expression.
|
|
Date ( |
Creates a DbDateTimeFunctionExpression that represents returning the date portion of a date time value.
|
|
DayOfMonth ( |
Creates a DbDateTimeFunctionExpression that represents returning the day of the month.
|
|
DayOfWeek ( |
Creates a DbDateTimeFunctionExpression that represents returning the day of the week.
|
|
DayOfYear ( |
Creates a DbDateTimeFunctionExpression that represents returning the day of the year.
|
|
Degrees ( |
Creates a DbMathematicalFunctionExpression that represents returning the corresponding angle in degrees for an angle specified in radians.
|
|
Delete ( |
Creates a new DbDeleteExpression that represents delete statement.
|
|
Divide ( |
Creates a DbBinaryExpression that represents arithmetic division.
|
|
Equal ( |
Creates a DbBinaryExpression that represents an equality comparison.
|
|
Exists ( DbQuery |
Creates a new DbExistsExpression.
|
|
Exists ( Func |
Creates a new DbExistsExpression.
|
|
Exp ( |
Creates a DbMathematicalFunctionExpression that represents returning the exponential value of the specified float expression.
|
|
Floor ( |
Creates a DbMathematicalFunctionExpression that represents returning the largest integer less than or equal to the specified numeric expression.
|
|
GreaterThan ( |
Creates a DbBinaryExpression that represents a 'greater than' comparison.
|
|
GreaterThanOrEqual ( |
Creates a DbBinaryExpression that represents a 'greater than or equal' comparison.
|
|
Hour ( |
Creates a DbDateTimeFunctionExpression that represents returning hour component of a date/time value.
|
|
In ( |
Creates a new DbInExpression.
|
|
In ( |
Creates a new DbInExpression.
|
|
In ( |
Creates a new DbInExpression.
|
|
InnerJoin ( |
Create a new DbJoinExpression that represents an 'INNER JOIN'.
|
|
LeftOuterJoin ( |
Create a new DbJoinExpression that represents a 'LEFT OUTER JOIN'.
|
|
Length ( |
Creates a DbStringFunctionExpression that returns the length of the expression.
|
|
LessThan ( |
Creates a DbBinaryExpression that represents a 'less than' comparison.
|
|
LessThanOrEqual ( |
Creates a DbBinaryExpression that represents a 'less than or equal' comparison.
|
|
List ( ) : DbListExpression |
Creates a new DbListExpression.
|
|
List ( IEnumerable |
Creates a new DbListExpression.
|
|
Log ( |
Creates a DbMathematicalFunctionExpression that represents returning the natural logarithm of the specified float expression.
|
|
Log10 ( |
Creates a DbMathematicalFunctionExpression that represents returning the base-10 logarithm of the specified float expression.
|
|
MakeAggregateFunction ( DbAggregateFunctionExpressionType aggregateFunctionExpressionType, |
Creates a DbAggregateFunctionExpression.
|
|
MakeBinary ( DbBinaryExpressionType binaryExpressionType, |
Creates a DbBinaryExpression.
|
|
MakeDateTimeFunction ( DbDateTimeFunctionExpressionType dateTimeFunctionExpressionType, |
Creates a new DbDateTimeFunctionExpression.
|
|
MakeJoin ( DbJoinExpressionType joinType, |
Creates a new DbJoinExpression.
|
|
MakeMathematicalFunction ( DbMathematicalFunctionExpressionType mathematicalFunctionExpressionType, |
Creates a new DbDateTimeFunctionExpression.
|
|
MakeOrderBy ( DbOrderByExpressionType orderByExpressionType, |
Creates a new DbOrderByExpression that represents ordering the result set.
|
|
MakeStringFunction ( DbStringFunctionExpressionType stringFunctionExpressionType, |
Creates a new DbStringFunctionExpression.
|
|
MakeUnary ( DbUnaryExpressionType unaryExpressionType, |
Creates a new DbUnaryExpression.
|
|
Max ( |
Creates a DbAggregateFunctionExpression that represents returning the maximum value in the target expression.
|
|
Millisecond ( |
Creates a DbDateTimeFunctionExpression that represents returning millisecond component of a date/time value.
|
|
Min ( |
Creates a DbAggregateFunctionExpression that represents returning the minimum value in the target expression.
|
|
Minute ( |
Creates a DbDateTimeFunctionExpression that represents returning minute component of a date/time value.
|
|
Month ( |
Creates a DbDateTimeFunctionExpression that represents returning month component of a date/time value.
|
|
Multiply ( |
Creates a DbBinaryExpression that represents arithmetic multiplication.
|
|
Not ( |
Creates a new DbUnaryExpression that represents negating the result of a boolean DbExpression.
|
|
NotEqual ( |
Creates a DbBinaryExpression that represents an inequality comparison.
|
|
Now ( ) : |
Creates a DbDateTimeFunctionExpression that represents returning the current date and time.
|
|
Or ( |
Creates a DbBinaryExpression that represents a logical OR operation.
|
|
OrderByAscending ( |
Creates a new DbOrderByExpression that represents an ascending ordering of the result set.
|
|
OrderByDescending ( |
Creates a new DbOrderByExpression that represents an descending ordering of the result set.
|
|
PI ( ) : |
Creates a DbMathematicalFunctionExpression that represents returning the constant value of PI.
|
|
Power ( |
Creates a DbMathematicalFunctionExpression that represents returning the value of the specified expression to the specified power.
|
|
Prefix ( |
Creates a new DbPrefixExpression.
|
|
Radians ( |
Creates a DbMathematicalFunctionExpression that represents returning the radians of the specified numeric expression.
|
|
Rand ( ) : |
Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.
|
|
Rand ( |
Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.
|
|
Replace ( |
Creates a DbStringFunctionExpression that represents replacing all occurrences of a specified string value with another string value.
|
|
Reverse ( |
Creates a DbStringFunctionExpression that represents reversing a string value.
|
|
RightOuterJoin ( |
Create a new DbJoinExpression that represents a 'RIGHT OUTER JOIN'.
|
|
Round ( |
Creates a DbMathematicalFunctionExpression that represents returning a pseudo-random float value from 0 through 1, exclusive.
|
|
Second ( |
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 ( |
Creates a new DbSelectQuery that represents a sub query.
|
|
SelectDistinct ( ) : DbSelectQuery |
Creates a new DbSelectQuery that represents a distinct sub query.
|
|
SelectDistinct ( |
Creates a new DbSelectQuery that represents a distinct sub query.
|
|
Sign ( |
Creates a DbMathematicalFunctionExpression that represents returning the positive (+1), zero (0), or negative (-1) sign of the specified expression.
|
|
Sin ( |
Creates a DbMathematicalFunctionExpression that represents returning the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression.
|
|
SoundEx ( |
Creates a DbStringFunctionExpression that represents returning a four-character code to evaluate the similarity of two strings.
|
|
Sql ( string sqlFragment ) : |
Creates a new DbSqlExpression that represents the SQL created when translating a DbExpression instance.
|
|
Sqrt ( |
Creates a DbMathematicalFunctionExpression that represents returning the square root of the specified float value.
|
|
Square ( |
Creates a DbMathematicalFunctionExpression that represents returning the square of the specified float value.
|
|
SubString ( |
Creates a DbStringFunctionExpression that represents returning the substring from a string.
|
|
Subtract ( |
Creates a DbBinaryExpression that represents arithmetic subtraction.
|
|
Sum ( |
Creates a DbAggregateFunctionExpression that represents returning the sum of all values in the target expression.
|
|
Table ( string tableName, string alias ) : |
Creates a new DbTableExpression that is wrapped inside a DbAliasExpression.
|
|
Table ( string tableName ) : |
Creates a new DbColumnExpression.
|
|
Tan ( |
Creates a DbMathematicalFunctionExpression that represents returning the tangent of the input expression.
|
|
ToDay ( ) : |
Creates a DbDateTimeFunctionExpression that represents returning the current date.
|
|
ToLower ( |
Creates a DbStringFunctionExpression that converts the result of the expression to an 'lower' textual representation.
|
|
ToUpper ( |
Creates a DbStringFunctionExpression that converts the result of the expression to an 'UPPER' textual representation.
|
|
Trim ( |
Creates a DbStringFunctionExpression that represents removing all leading and trailing spaces from a string.
|
|
TrimEnd ( |
Creates a DbStringFunctionExpression that represents removing all trailing spaces from a string.
|
|
TrimStart ( |
Creates a DbStringFunctionExpression that represents removing all leading spaces from a string.
|
|
Year ( |
Creates a DbDateTimeFunctionExpression that represents returning year component of a date/time value.
|
public Abs ( |
||
target | The target |
|
리턴 |
public Acos ( |
||
target | The target |
|
리턴 |
public Add ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public AddDays ( |
||
target | A |
|
numberExpression | A |
|
리턴 |
public AddHours ( |
||
target | A |
|
numberExpression | A |
|
리턴 |
public AddMilliseconds ( |
||
target | A |
|
numberExpression | A |
|
리턴 |
public AddMinutes ( |
||
target | A |
|
numberExpression | A |
|
리턴 |
public AddMonths ( |
||
target | A |
|
numberExpression | A |
|
리턴 |
public AddSeconds ( |
||
target | A |
|
numberExpression | A |
|
리턴 |
public AddYears ( |
||
target | A |
|
numberExpression | A |
|
리턴 |
public Alias ( |
||
target | The target |
|
alias | string | the alias to be used to reference the |
리턴 |
public And ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public Asin ( |
||
target | The target |
|
리턴 |
public Assign ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public Atan ( |
||
expression | The target |
|
리턴 |
public Atan2 ( |
||
x | A |
|
y | A |
|
리턴 |
public Avg ( |
||
target | The |
|
리턴 |
public Batch ( IEnumerable |
||
dbExpressions | IEnumerable |
A |
리턴 |
public Cast ( |
||
operand | The |
|
targetType | The |
|
리턴 |
public Ceiling ( |
||
target | The target |
|
리턴 |
public Column ( string columnName ) : |
||
columnName | string | The name of the column. |
리턴 |
public Column ( string prefix, string columnName ) : |
||
prefix | string | The column prefix. |
columnName | string | The name of the column. |
리턴 |
public Concat ( |
||
leftExpression | The left operand of the concatenate operation. | |
rightExpression | The right operand of the concatenate operation. | |
리턴 |
public Conditional ( |
||
condition | The |
|
trueExpression | The |
|
falseExpression | The |
|
리턴 |
public Constant ( object value ) : |
||
value | object | The value that this |
리턴 |
public Cos ( |
||
target | The target |
|
리턴 |
public Cot ( |
||
target | The target |
|
리턴 |
public Count ( |
||
target | The |
|
리턴 |
public Date ( |
||
target | A |
|
리턴 |
public DayOfMonth ( |
||
target | A |
|
리턴 |
public DayOfWeek ( |
||
target | A |
|
리턴 |
public DayOfYear ( |
||
target | A |
|
리턴 |
public Degrees ( |
||
target | The target |
|
리턴 |
public Delete ( |
||
target | The |
|
fromExpression | The |
|
whereExpression | the |
|
리턴 |
public Divide ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public Equal ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public Exists ( DbQuery |
||
subSelectQuery | DbQuery |
The |
리턴 |
public Exists ( Func |
||
subQuerySelector | Func |
The |
리턴 |
public Exp ( |
||
target | The target |
|
리턴 |
public Floor ( |
||
target | The target |
|
리턴 |
public GreaterThan ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public GreaterThanOrEqual ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public Hour ( |
||
target | A |
|
리턴 |
public In ( |
||
target | The target |
|
expression | The |
|
리턴 |
public In ( |
||
target | The target |
|
selectQuery | DbQuery |
A sub query that has a result set of one column. |
리턴 |
public In ( |
||
target | The target |
|
values | object | A list of values to test for a match. |
리턴 |
public InnerJoin ( |
||
target | The join target. | |
condition | The join condition. | |
리턴 |
public LeftOuterJoin ( |
||
target | The join target. | |
condition | The join condition. | |
리턴 |
public Length ( |
||
expression | The |
|
리턴 |
public LessThan ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public LessThanOrEqual ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public List ( IEnumerable |
||
dbExpressions | IEnumerable |
A |
리턴 | DbListExpression |
public Log ( |
||
target | The target |
|
리턴 |
public Log10 ( |
||
target | The target |
|
리턴 |
public MakeAggregateFunction ( DbAggregateFunctionExpressionType aggregateFunctionExpressionType, |
||
aggregateFunctionExpressionType | DbAggregateFunctionExpressionType | The |
target | The |
|
리턴 |
public MakeBinary ( DbBinaryExpressionType binaryExpressionType, |
||
binaryExpressionType | DbBinaryExpressionType | The |
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public MakeDateTimeFunction ( DbDateTimeFunctionExpressionType dateTimeFunctionExpressionType, |
||
dateTimeFunctionExpressionType | DbDateTimeFunctionExpressionType | The |
arguments | A list of |
|
리턴 |
public MakeJoin ( DbJoinExpressionType joinType, |
||
joinType | DbJoinExpressionType | The |
target | The join target. | |
condition | The join condition. | |
리턴 |
public MakeMathematicalFunction ( DbMathematicalFunctionExpressionType mathematicalFunctionExpressionType, |
||
mathematicalFunctionExpressionType | DbMathematicalFunctionExpressionType | The |
arguments | A list of |
|
리턴 |
public MakeOrderBy ( DbOrderByExpressionType orderByExpressionType, |
||
orderByExpressionType | DbOrderByExpressionType | The |
expression | The |
|
리턴 |
public MakeStringFunction ( DbStringFunctionExpressionType stringFunctionExpressionType, |
||
stringFunctionExpressionType | DbStringFunctionExpressionType | The |
arguments | A list of |
|
리턴 |
public MakeUnary ( DbUnaryExpressionType unaryExpressionType, |
||
unaryExpressionType | DbUnaryExpressionType | The |
operand | The |
|
targetType | The |
|
리턴 |
public Max ( |
||
target | The |
|
리턴 |
public Millisecond ( |
||
target | A |
|
리턴 |
public Min ( |
||
target | The |
|
리턴 |
public Minute ( |
||
target | A |
|
리턴 |
public Month ( |
||
target | A |
|
리턴 |
public Multiply ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public Not ( |
||
operand | The |
|
리턴 |
public NotEqual ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public Or ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public OrderByAscending ( |
||
expression | The |
|
리턴 |
public OrderByDescending ( |
||
expression | The |
|
리턴 |
public Power ( |
||
target | The target |
|
y | The power to which to raise the numeric value. | |
리턴 |
public Prefix ( |
||
target | The target |
|
prefix | string | the prefix to be used to reference the |
리턴 |
public Radians ( |
||
target | The target |
|
리턴 |
public Rand ( ) : |
||
리턴 |
public Rand ( |
||
seed | The target |
|
리턴 |
public Replace ( |
||
expression | The |
|
oldValue | The value to be replaced. | |
newValue | The value to replace all occurrences of |
|
리턴 |
public Reverse ( |
||
expression | The |
|
리턴 |
public RightOuterJoin ( |
||
target | The join target. | |
condition | The join condition. | |
리턴 |
public Round ( |
||
target | The target |
|
precision | A |
|
리턴 |
public Second ( |
||
target | A |
|
리턴 |
public Select ( |
||
expression | The |
|
리턴 | DbSelectQuery |
public SelectDistinct ( |
||
expression | The |
|
리턴 | DbSelectQuery |
public Sign ( |
||
target | The target |
|
리턴 |
public Sin ( |
||
target | The target |
|
리턴 |
public SoundEx ( |
||
expression | The |
|
리턴 |
public Sql ( string sqlFragment ) : |
||
sqlFragment | string | The SQL that this |
리턴 |
public Sqrt ( |
||
target | The target |
|
리턴 |
public Square ( |
||
target | The target |
|
리턴 |
public SubString ( |
||
expression | The |
|
startExpression | The |
|
lengthExpression | The |
|
리턴 |
public Subtract ( |
||
leftExpression | A |
|
rightExpression | A |
|
리턴 |
public Sum ( |
||
target | The |
|
리턴 |
public Table ( string tableName, string alias ) : |
||
tableName | string | The name of the table. |
alias | string | The table alias. |
리턴 |
public Table ( string tableName ) : |
||
tableName | string | The name of the table. |
리턴 |
public Tan ( |
||
target | The target |
|
리턴 |
public ToLower ( |
||
expression | The |
|
리턴 |
public ToUpper ( |
||
expression | The |
|
리턴 |
public Trim ( |
||
expression | The |
|
리턴 |
public TrimEnd ( |
||
expression | The |
|
리턴 |
public TrimStart ( |
||
expression | The |
|
리턴 |
public Year ( |
||
target | A |
|
리턴 |