System.Data.Common.CommandTrees
TOC
Collapse the table of content
Expand the table of content

System.Data.Common.CommandTrees Namespace

 

The System.Data.Common.CommandTrees namespace provides classes to build expressions that make up a command tree.

ClassDescription
System_CAPS_pubclassDbAggregate

Implements the basic functionality required by aggregates in a GroupBy clause.

System_CAPS_pubclassDbAndExpression

Represents the logical AND of two Boolean arguments. This class cannot be inherited.

System_CAPS_pubclassDbApplyExpression

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.

System_CAPS_pubclassDbArithmeticExpression

Represents an arithmetic operation applied to numeric arguments. Addition, subtraction, multiplication, division, modulo, and negation are arithmetic operations. This class cannot be inherited.

System_CAPS_pubclassDbBinaryExpression

Implements the basic functionality required by expressions that accept two expression operands.

System_CAPS_pubclassDbCaseExpression

Represents the When, Then, and Else clauses of the DbCaseExpression. This class cannot be inherited.

System_CAPS_pubclassDbCastExpression

Represents the type conversion of a single argument to the specified type. This class cannot be inherited.

System_CAPS_pubclassDbCommandTree

An immutable class that implements the basic functionality for the Query, Insert, Update, Delete, and function invocation command tree types.

System_CAPS_pubclassDbComparisonExpression

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.

System_CAPS_pubclassDbConstantExpression

Represents different kinds of constants (literals). This class cannot be inherited.

System_CAPS_pubclassDbCrossJoinExpression

Represents an unconditional join operation between the given collection arguments. This class cannot be inherited.

System_CAPS_pubclassDbDeleteCommandTree

Represents a single row delete operation expressed as a command tree. This class cannot be inherited.

System_CAPS_pubclassDbDerefExpression

Represents the an expression that retrieves an entity based on the specified reference. This class cannot be inherited.

System_CAPS_pubclassDbDistinctExpression

Removes duplicate elements from the specified set argument. This class cannot be inherited.

System_CAPS_pubclassDbElementExpression

Represents the conversion of the specified set argument to a singleton. This class cannot be inherited.

System_CAPS_pubclassDbEntityRefExpression

Represents an expression that extracts a reference from the underlying entity instance. This class cannot be inherited.

System_CAPS_pubclassDbExceptExpression

Represents the set subtraction operation between the left and right operands. This class cannot be inherited.

System_CAPS_pubclassDbExpression

Represents the base type for all expressions.

System_CAPS_pubclassDbExpressionBinding

Represents an input set to relational expressions such as DbFilterExpression, DbProjectExpression, and DbJoinExpression. This class cannot be inherited.

System_CAPS_pubclassDbExpressionVisitor

Defines the basic functionality that should be implemented by visitors that do not return a result value.

System_CAPS_pubclassDbExpressionVisitor<TResultType>

Defines the basic functionality that should be implemented by visitors that return a result value of a specific type.

System_CAPS_pubclassDbFilterExpression

Represents a predicate applied to filter an input set. This produces the set of elements that satisfy the predicate. This class cannot be inherited.

System_CAPS_pubclassDbFunctionAggregate

Supports standard aggregate functions, such as MIN, MAX, AVG, SUM, and so on. This class cannot be inherited.

System_CAPS_pubclassDbFunctionCommandTree

Represents the invocation of a database function.

System_CAPS_pubclassDbFunctionExpression

Represents an invocation of a function. This class cannot be inherited.

System_CAPS_pubclassDbGroupAggregate

Represents a collection of elements that compose a group.

System_CAPS_pubclassDbGroupByExpression

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.

System_CAPS_pubclassDbGroupExpressionBinding

Defines the binding for the input set to a DbGroupByExpression. This class cannot be inherited.

System_CAPS_pubclassDbInsertCommandTree

Represents a single row insert operation expressed as a command tree. This class cannot be inherited.

System_CAPS_pubclassDbIntersectExpression

Represents the set intersection operation between the left and right operands. This class cannot be inherited.

System_CAPS_pubclassDbIsEmptyExpression

Represents an empty set determination applied to a single set argument. This class cannot be inherited.

System_CAPS_pubclassDbIsNullExpression

Represents null determination applied to a single argument. This class cannot be inherited.

System_CAPS_pubclassDbIsOfExpression

Represents the type comparison of a single argument against the specified type. This class cannot be inherited.

System_CAPS_pubclassDbJoinExpression

Represents an inner, left outer, or full outer join operation between the given collection arguments on the specified join condition.

System_CAPS_pubclassDbLambda

Represents a Lambda function that can be invoked to produce a DbLambdaExpression.

System_CAPS_pubclassDbLambdaExpression

Allows the application of a lambda function to arguments represented by DbExpression objects.

System_CAPS_pubclassDbLikeExpression

Represents a string comparison against the specified pattern with an optional escape string. This class cannot be inherited.

System_CAPS_pubclassDbLimitExpression

Represents the restriction of the number of elements in the argument collection to the specified limit value.

System_CAPS_pubclassDbModificationClause

Specifies a single clause in an insert or update modification operation.

System_CAPS_pubclassDbModificationCommandTree

Represents a data manipulation language (DML) operation expressed as a command tree.

System_CAPS_pubclassDbNewInstanceExpression

Represents the construction of a new instance of a given type, including set and record types. This class cannot be inherited.

System_CAPS_pubclassDbNotExpression

Represents the logical NOT of a single Boolean argument. This class cannot be inherited.

System_CAPS_pubclassDbNullExpression

Represents a reference to a typed null literal. This class cannot be inherited.

System_CAPS_pubclassDbOfTypeExpression

Represents the retrieval of elements of the specified type from the given set argument. This class cannot be inherited.

System_CAPS_pubclassDbOrExpression

Represents the logical OR of two Boolean arguments. This class cannot be inherited.

System_CAPS_pubclassDbParameterReferenceExpression

Represents a reference to a parameter declared on the command tree that contains this expression. This class cannot be inherited.

System_CAPS_pubclassDbProjectExpression

Represents the projection of a given input set over the specified expression. This class cannot be inherited.

System_CAPS_pubclassDbPropertyExpression

Provides methods and properties for retrieving an instance property. This class cannot be inherited.

System_CAPS_pubclassDbQuantifierExpression

Represents a quantifier operation of the specified kind over the elements of the specified input set. This class cannot be inherited.

System_CAPS_pubclassDbQueryCommandTree

Represents a query operation expressed as a command tree. This class cannot be inherited.

System_CAPS_pubclassDbRefExpression

Represents a strongly typed reference to a specific instance within an entity set. This class cannot be inherited.

System_CAPS_pubclassDbRefKeyExpression

Represents the retrieval of the key value (in its structural form) from the underlying reference value. This class cannot be inherited.

System_CAPS_pubclassDbRelationshipNavigationExpression

Represents the navigation of a relationship. This class cannot be inherited.

System_CAPS_pubclassDbScanExpression

Represents a scan over an entity set or relationship set, as indicated by the Target property. This class cannot be inherited.

System_CAPS_pubclassDbSetClause

Specifies the clause in a modification operation that sets the value of a property. This class cannot be inherited.

System_CAPS_pubclassDbSkipExpression

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.

System_CAPS_pubclassDbSortClause

Specifies a sort key that can be used as part of the sort order in a DbSortExpression. This class cannot be inherited.

System_CAPS_pubclassDbSortExpression

Represents a sort operation applied to the elements of the specified input set based on the given sort keys. This class cannot be inherited.

System_CAPS_pubclassDbTreatExpression

Represents a type conversion operation applied to a polymorphic argument. This class cannot be inherited.

System_CAPS_pubclassDbUnaryExpression

Implements the basic functionality required by expressions that accept a single expression argument.

System_CAPS_pubclassDbUnionAllExpression

Represents the set union (without duplicate removal) operation between the left and right operands. This class cannot be inherited.

System_CAPS_pubclassDbUpdateCommandTree

Represents a single-row update operation expressed as a command tree. This class cannot be inherited.

System_CAPS_pubclassDbVariableReferenceExpression

Represents a reference to a variable that is currently in scope. This class cannot be inherited.

System_CAPS_pubclassDefaultExpressionVisitor

Visits each element of an expression tree from a given root expression. If any element changes, the tree is rebuilt back to the root and the new root expression is returned; otherwise the original root expression is returned.

EnumerationDescription
System_CAPS_pubenumDbExpressionKind

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.

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.

Return to top
Show:
© 2016 Microsoft