Windows apps
Collapse the table of content
Expand the table of content
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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:
© 2017 Microsoft