This documentation is archived and is not being maintained.
System.Data.Common.CommandTrees Namespace
Visual Studio 2010
The System.Data.Common.CommandTrees namespace provides classes to build expressions that make up a command tree.
A command trees is an object model representation of a query that can be used to represent query, update, insert, and delete commands in the ADO.NET Entity Data Model (EDM) and storage metadata.
| Class | Description | |
|---|---|---|
![]() | DbAggregate | Implements the basic functionality required by aggregates in a GroupBy clause. |
![]() | DbAndExpression | Represents the logical AND of two Boolean arguments. This class cannot be inherited. |
![]() | DbApplyExpression | Represents an apply operation, which is the invocation of the specified function for each element in the specified input set. This class cannot be inherited. |
![]() | DbArithmeticExpression | Represents an arithmetic operation applied to numeric arguments. Addition, subtraction, multiplication, division, modulo, and negation are arithmetic operations. This class cannot be inherited. |
![]() | DbBinaryExpression | Implements the basic functionality required by expressions that accept two expression operands. |
![]() | DbCaseExpression | Represents the When, Then, and Else clauses of the DbCaseExpression. This class cannot be inherited. |
![]() | DbCastExpression | Represents the type conversion of a single argument to the specified type. This class cannot be inherited. |
![]() | DbCommandTree | An immutable class that implements the basic functionality for the Query, Insert, Update, Delete, and function invocation command tree types. |
![]() | DbComparisonExpression | Represents a comparison operation applied to two arguments. Equality, greater than, greater than or equal, less than, less than or equal, and inequality are comparison operations. This class cannot be inherited. |
![]() | DbConstantExpression | Represents different kinds of constants (literals). This class cannot be inherited. |
![]() | DbCrossJoinExpression | Represents an unconditional join operation between the given collection arguments. This class cannot be inherited. |
![]() | DbDeleteCommandTree | Represents a single row delete operation expressed as a command tree. This class cannot be inherited. |
![]() | DbDerefExpression | Represents the an expression that retrieves an entity based on the specified reference. This class cannot be inherited. |
![]() | DbDistinctExpression | Removes duplicate elements from the specified set argument. This class cannot be inherited. |
![]() | DbElementExpression | Represents the conversion of the specified set argument to a singleton. This class cannot be inherited. |
![]() | DbEntityRefExpression | Represents an expression that extracts a reference from the underlying entity instance. This class cannot be inherited. |
![]() | DbExceptExpression | Represents the set subtraction operation between the left and right operands. This class cannot be inherited. |
![]() | DbExpression | Implements the basic functionality required by expression types. |
![]() | DbExpressionBinding | Represents an input set to relational expressions such as DbFilterExpression, DbProjectExpression, and DbJoinExpression. This class cannot be inherited. |
![]() | DbExpressionVisitor | Defines the basic functionality that should be implemented by visitors that do not return a result value. |
![]() | DbExpressionVisitor<TResultType> | Defines the basic functionality that should be implemented by visitors that return a result value of a specific type. |
![]() | DbFilterExpression | Represents a predicate applied to filter an input set. This produces the set of elements that satisfy the predicate. This class cannot be inherited. |
![]() | DbFunctionAggregate | Supports standard aggregate functions, such as MIN, MAX, AVG, SUM, and so on. This class cannot be inherited. |
![]() | DbFunctionCommandTree | Represents the invocation of a database function. |
![]() | DbFunctionExpression | Represents an invocation of a function. This class cannot be inherited. |
![]() | DbGroupAggregate | Represents a collection of elements that compose a group. |
![]() | DbGroupByExpression | Represents a group by operation. A group by operation is a grouping of the elements in the input set based on the specified key expressions followed by the application of the specified aggregates. This class cannot be inherited. |
![]() | DbGroupExpressionBinding | Defines the binding for the input set to a DbGroupByExpression. This class cannot be inherited. |
![]() | DbInsertCommandTree | Represents a single row insert operation expressed as a command tree. This class cannot be inherited. |
![]() | DbIntersectExpression | Represents the set intersection operation between the left and right operands. This class cannot be inherited. |
![]() | DbIsEmptyExpression | Represents an empty set determination applied to a single set argument. This class cannot be inherited. |
![]() | DbIsNullExpression | Represents null determination applied to a single argument. This class cannot be inherited. |
![]() | DbIsOfExpression | Represents the type comparison of a single argument against the specified type. This class cannot be inherited. |
![]() | DbJoinExpression | Represents an inner, left outer, or full outer join operation between the given collection arguments on the specified join condition. |
![]() | DbLambda | Represents a lambda function that can be invoked to produce a DbLambdaExpression. This class cannot be inherited. |
![]() | DbLambdaExpression | Allows the application of a lambda function to arguments represented by DbExpression objects. |
![]() | DbLikeExpression | Represents a string comparison against the specified pattern with an optional escape string. This class cannot be inherited. |
![]() | DbLimitExpression | Represents the restriction of the number of elements in the argument collection to the specified limit value. |
![]() | DbModificationClause | Specifies a single clause in an insert or update modification operation. |
![]() | DbModificationCommandTree | Represents a data manipulation language (DML) operation expressed as a command tree. |
![]() | DbNewInstanceExpression | Represents the construction of a new instance of a given type, including set and record types. This class cannot be inherited. |
![]() | DbNotExpression | Represents the logical NOT of a single Boolean argument. This class cannot be inherited. |
![]() | DbNullExpression | Represents a reference to a typed null literal. This class cannot be inherited. |
![]() | DbOfTypeExpression | Represents the retrieval of elements of the specified type from the given set argument. This class cannot be inherited. |
![]() | DbOrExpression | Represents the logical OR of two Boolean arguments. This class cannot be inherited. |
![]() | DbParameterReferenceExpression | Represents a reference to a parameter declared on the command tree that contains this expression. This class cannot be inherited. |
![]() | DbProjectExpression | Represents the projection of a given input set over the specified expression. This class cannot be inherited. |
![]() | DbPropertyExpression | Provides methods and properties for retrieving an instance property. This class cannot be inherited. |
![]() | DbQuantifierExpression | Represents a quantifier operation of the specified kind over the elements of the specified input set. This class cannot be inherited. |
![]() | DbQueryCommandTree | Represents a query operation expressed as a command tree. This class cannot be inherited. |
![]() | DbRefExpression | Represents a strongly typed reference to a specific instance within an entity set. This class cannot be inherited. |
![]() | DbRefKeyExpression | Represents the retrieval of the key value (in its structural form) from the underlying reference value. This class cannot be inherited. |
![]() | DbRelationshipNavigationExpression | Represents the navigation of a relationship. This class cannot be inherited. |
![]() | DbScanExpression | Represents a scan over an entity set or relationship set, as indicated by the Target property. This class cannot be inherited. |
![]() | DbSetClause | Specifies the clause in a modification operation that sets the value of a property. This class cannot be inherited. |
![]() | DbSkipExpression | Skips a specified number of elements in the input set. DbSkipExpression can only be used after the input collection has been sorted as specified by the sort keys. |
![]() | DbSortClause | Specifies a sort key that can be used as part of the sort order in a DbSortExpression. This class cannot be inherited. |
![]() | DbSortExpression | Represents a sort operation applied to the elements of the specified input set based on the given sort keys. This class cannot be inherited. |
![]() | DbTreatExpression | Represents a type conversion operation applied to a polymorphic argument. This class cannot be inherited. |
![]() | DbUnaryExpression | Implements the basic functionality required by expressions that accept a single expression argument. |
![]() | DbUnionAllExpression | Represents the set union (without duplicate removal) operation between the left and right operands. This class cannot be inherited. |
![]() | DbUpdateCommandTree | Represents a single-row update operation expressed as a command tree. This class cannot be inherited. |
![]() | DbVariableReferenceExpression | Represents a reference to a variable that is currently in scope. This class cannot be inherited. |
| Enumeration | Description | |
|---|---|---|
![]() | DbExpressionKind | Contains values that each expression class uses to denote the operation it represents. The ExpressionKind property of an DbExpression can be retrieved to determine which operation that expression represents. |
Show:

