DbExceptExpression Class

Definition

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

C#
public sealed class DbExceptExpression : System.Data.Common.CommandTrees.DbBinaryExpression
Inheritance

Remarks

This class requires that its arguments have a common collection result type.

Properties

ExpressionKind

Gets the kind of the expression, which indicates the operation of this expression.

(Inherited from DbExpression)
Left

Gets or sets the DbExpression that defines the left argument.

(Inherited from DbBinaryExpression)
ResultType

Gets the type metadata for the result type of the expression.

(Inherited from DbExpression)
Right

Gets or sets the DbExpression that defines the right argument.

(Inherited from DbBinaryExpression)

Methods

Accept(DbExpressionVisitor)

Implements the visitor pattern for expressions that do not produce a result value.

Accept<TResultType>(DbExpressionVisitor<TResultType>)

Implements the visitor pattern for expressions that produce a result value of a specific type.

Equals(Object)

Determines whether the specified Object is equal to the current DbExpression instance.

(Inherited from DbExpression)
GetHashCode()

Serves as a hash function for the type.

(Inherited from DbExpression)
GetType()

Gets the Type of the current instance.

(Inherited from Object)
MemberwiseClone()

Creates a shallow copy of the current Object.

(Inherited from Object)
ToString()

Returns a string that represents the current object.

(Inherited from Object)

Extension Methods

All(DbExpression, Func<DbExpression,DbExpression>)

Creates a new DbQuantifierExpression that determines whether the given predicate holds for all elements of the input set.

And(DbExpression, DbExpression)

Creates an DbAndExpression that performs the logical And of the left and right arguments.

Any(DbExpression, Func<DbExpression,DbExpression>)

Creates a new DbQuantifierExpression that determines whether the given predicate holds for any element of the input set.

Any(DbExpression)

Creates a new DbExpression that determines whether the specified set argument is non-empty.

As(DbExpression, String)

Returns the specified arguments as a key/value pair object.

Bind(DbExpression)

Creates a new DbExpressionBinding that uses a generated variable name to bind the given expression.

BindAs(DbExpression, String)

Creates a new DbExpressionBinding that uses the specified variable name to bind the given expression.

CastTo(DbExpression, TypeUsage)

Creates a new DbCastExpression that applies a cast operation to a polymorphic argument.

CrossApply(DbExpression, Func<DbExpression,KeyValuePair<String,DbExpression>>)

Creates a new DbApplyExpression that evaluates the given apply expression once for each element of a given input set, producing a collection of rows with corresponding input and apply columns. Rows for which apply evaluates to an empty set are not included.

Deref(DbExpression)

Creates a new DbDerefExpression that retrieves a specific Entity given a reference expression.

Distinct(DbExpression)

Creates a new DbDistinctExpression that removes duplicates from the given set argument.

Divide(DbExpression, DbExpression)

Creates a new DbArithmeticExpression that divides the left argument by the right argument.

Element(DbExpression)

Creates a new DbElementExpression that converts a set into a singleton.

Equal(DbExpression, DbExpression)

Creates a new DbComparisonExpression that compares the left and right arguments for equality.

Except(DbExpression, DbExpression)

Creates a new DbExceptExpression that computes the subtraction of the right set argument from the left set argument.

Exists(DbExpression)

Creates a new DbExpression that determines whether the specified set argument is non-empty.

FullOuterJoin(DbExpression, DbExpression, Func<DbExpression,DbExpression,DbExpression>)

Creates a new DbJoinExpression that joins the sets specified by the left and right expressions, on the specified join condition, using FullOuterJoin as the DbExpressionKind.

GetEntityRef(DbExpression)

Creates a new DbEntityRefExpression that retrieves the ref of the specified entity in structural form.

GetRefKey(DbExpression)

Creates a new DbRefKeyExpression that retrieves the key values of the specified reference in structural form.

GreaterThan(DbExpression, DbExpression)

Creates a new DbComparisonExpression that determines whether the left argument is greater than the right argument.

GreaterThanOrEqual(DbExpression, DbExpression)

Creates a new DbComparisonExpression that determines whether the left argument is greater than or equal to the right argument.

GroupBind(DbExpression)

Creates a new group expression binding that uses generated variable and group variable names to bind the given expression.

GroupBindAs(DbExpression, String, String)

Creates a new DbGroupExpressionBinding that uses the specified variable name and group variable names to bind the given expression.

InnerJoin(DbExpression, DbExpression, Func<DbExpression,DbExpression,DbExpression>)

Creates a new DbJoinExpression that joins the sets specified by the left and right expressions, on the specified join condition, using InnerJoin as the DbExpressionKind.

Intersect(DbExpression, DbExpression)

Creates a new DbIntersectExpression that computes the intersection of the left and right set arguments.

IsEmpty(DbExpression)

Creates a new DbIsEmptyExpression that determines whether the specified set argument is an empty set.

IsNull(DbExpression)

Creates a new DbIsNullExpression that determines whether the specified argument is null.

IsOf(DbExpression, TypeUsage)

Creates a new DbIsOfExpression that determines whether the given argument is of the specified type or a subtype.

IsOfOnly(DbExpression, TypeUsage)

Creates a new DbIsOfExpression expression that determines whether the given argument is of the specified type, and only that type (not a subtype).

Join(DbExpression, DbExpression, Func<DbExpression,DbExpression>, Func<DbExpression,DbExpression>)

Creates a new DbJoinExpression that joins the sets specified by the outer and inner expressions, on an equality condition between the specified outer and inner keys, using InnerJoin as the DbExpressionKind.

Join<TSelector>(DbExpression, DbExpression, Func<DbExpression, DbExpression>, Func<DbExpression,DbExpression>, Func<DbExpression, DbExpression,TSelector>)

Creates a new DbProjectExpression that projects the specified selector over the sets specified by the outer and inner expressions, joined on an equality condition between the specified outer and inner keys, using InnerJoin as the DbExpressionKind.

LeftOuterJoin(DbExpression, DbExpression, Func<DbExpression,DbExpression,DbExpression>)

Creates a new DbJoinExpression that joins the sets specified by the left and right expressions, on the specified join condition, using LeftOuterJoin as the DbExpressionKind.

LessThan(DbExpression, DbExpression)

Creates a new DbComparisonExpression that determines whether the left argument is less than the right argument.

LessThanOrEqual(DbExpression, DbExpression)

Creates a new DbComparisonExpression that determines whether the left argument is less than or equal to the right argument.

Like(DbExpression, DbExpression, DbExpression)

Creates a new DbLikeExpression that compares the specified input string to the given pattern using the optional escape.

Like(DbExpression, DbExpression)

Creates a new DbLikeExpression that compares the specified input string to the given pattern.

Limit(DbExpression, DbExpression)

Creates a new DbLimitExpression that restricts the number of elements in the Argument collection to the specified count Limit value. Tied results are not included in the output.

Minus(DbExpression, DbExpression)

Creates a new DbArithmeticExpression that subtracts the right argument from the left argument.

Modulo(DbExpression, DbExpression)

Creates a new DbArithmeticExpression that computes the remainder of the left argument divided by the right argument.

Multiply(DbExpression, DbExpression)

Creates a new DbArithmeticExpression that multiplies the left argument by the right argument.

Navigate(DbExpression, RelationshipEndMember, RelationshipEndMember)

Creates a new DbRelationshipNavigationExpression representing the navigation of a composition or association relationship.

Negate(DbExpression)

Creates a new DbArithmeticExpression that negates the value of the argument.

Not(DbExpression)

Creates a DbNotExpression that performs the logical negation of the given argument.

NotEqual(DbExpression, DbExpression)

Creates a new DbComparisonExpression that compares the left and right arguments for inequality.

OfType(DbExpression, TypeUsage)

Creates a new DbOfTypeExpression that produces a set consisting of the elements of the given input set that are of the specified type.

OfTypeOnly(DbExpression, TypeUsage)

Creates a new DbOfTypeExpression that produces a set consisting of the elements of the given input set that are of exactly the specified type.

Or(DbExpression, DbExpression)

Creates an DbOrExpression that performs the logical Or of the left and right arguments.

OrderBy(DbExpression, Func<DbExpression,DbExpression>, String)

Creates a new DbSortExpression that sorts the given input set by the specified sort key, with ascending sort order and the specified collation.

OrderBy(DbExpression, Func<DbExpression,DbExpression>)

Creates a new DbSortExpression that sorts the given input set by the specified sort key, with ascending sort order and default collation.

OrderByDescending(DbExpression, Func<DbExpression,DbExpression>, String)

Creates a new DbSortExpression that sorts the given input set by the specified sort key, with descending sort order and the specified collation.

OrderByDescending(DbExpression, Func<DbExpression,DbExpression>)

Creates a new DbSortExpression that sorts the given input set by the specified sort key, with descending sort order and default collation.

OuterApply(DbExpression, Func<DbExpression,KeyValuePair<String,DbExpression>>)

Creates a new DbApplyExpression that evaluates the given apply expression once for each element of a given input set, producing a collection of rows with corresponding input and apply columns. Rows for which apply evaluates to an empty set have an apply column value of null.

Plus(DbExpression, DbExpression)

Creates a new DbArithmeticExpression that adds the left argument to the right argument.

Property(DbExpression, EdmProperty)

Creates a new DbPropertyExpression representing the retrieval of the specified property.

Property(DbExpression, NavigationProperty)

Creates a new DbPropertyExpression representing the retrieval of the specified navigation property.

Property(DbExpression, RelationshipEndMember)

Creates a new DbPropertyExpression representing the retrieval of the specified relationship end member.

Property(DbExpression, String)

Creates a new DbPropertyExpression representing the retrieval of the instance property with the specified name from the given instance.

Select<TProjection>(DbExpression, Func<DbExpression,TProjection>)

Creates a new DbProjectExpression that selects the specified expression over the given input set.

SelectMany(DbExpression, Func<DbExpression,DbExpression>)

Creates a new DbApplyExpression that evaluates the given apply expression once for each element of a given input set, producing a collection of rows with corresponding input and apply columns. Rows for which apply evaluates to an empty set are not included. A DbProjectExpression is then created that selects the apply column from each row, producing the overall collection of apply results.

SelectMany<TSelector>(DbExpression, Func<DbExpression,DbExpression>, Func<DbExpression,DbExpression,TSelector>)

Creates a new DbApplyExpression that evaluates the given apply expression once for each element of a given input set, producing a collection of rows with corresponding input and apply columns. Rows for which apply evaluates to an empty set are not included. A DbProjectExpression is then created that selects the specified selector over each row, producing the overall collection of results.

Take(DbExpression, DbExpression)

Creates a new DbLimitExpression that restricts the number of elements in the Argument collection to the specified count Limit value. Tied results are not included in the output.

ToSortClause(DbExpression, String)

Creates a new DbSortClause with an ascending sort order and the specified collation.

ToSortClause(DbExpression)

Creates a new DbSortClause with an ascending sort order and default collation.

ToSortClauseDescending(DbExpression, String)

Creates a new DbSortClause with a descending sort order and the specified collation.

ToSortClauseDescending(DbExpression)

Creates a new DbSortClause with a descending sort order and default collation.

TreatAs(DbExpression, TypeUsage)

Creates a new DbTreatExpression.

UnaryMinus(DbExpression)

Creates a new DbArithmeticExpression that negates the value of the argument.

Union(DbExpression, DbExpression)

Creates a new DbExpression that computes the union of the left and right set arguments with duplicates removed.

UnionAll(DbExpression, DbExpression)

Creates a new DbUnionAllExpression that computes the union of the left and right set arguments and does not remove duplicates.

Where(DbExpression, Func<DbExpression,DbExpression>)

Creates a new DbFilterExpression that filters the elements in the given input set using the specified predicate.

Abs(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Abs' function with the specified argument, which must each have a numeric result type. The result type of the expression is the same as the result type of value.

AddDays(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddDays' function with the specified arguments, which must have DateTime or DateTimeOffset and integer result types. The result type of the expression is the same as the result type of dateValue.

AddHours(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddHours' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

AddMicroseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddMicroseconds' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

AddMilliseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddMilliseconds' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

AddMinutes(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddMinutes' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

AddMonths(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddMonths' function with the specified arguments, which must have DateTime or DateTimeOffset and integer result types. The result type of the expression is the same as the result type of dateValue.

AddNanoseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddNanoseconds' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

AddSeconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddSeconds' function with the specified arguments, which must have DateTime, DateTimeOffset or Time, and integer result types. The result type of the expression is the same as the result type of timeValue.

AddYears(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AddYears' function with the specified arguments, which must have DateTime or DateTimeOffset and integer result types. The result type of the expression is the same as the result type of dateValue.

Average(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Avg' function over the specified collection. The result type of the expression is the same as the element type of the collection.

BitwiseAnd(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BitwiseAnd' function with the specified arguments, which must have the same integer numeric result type. The result type of the expression is the same as the type of the arguments.

BitwiseNot(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BitwiseNot' function with the specified argument, which must have an integer numeric result type. The result type of the expression is the same as the type of the arguments.

BitwiseOr(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BitwiseOr' function with the specified arguments, which must have the same integer numeric result type. The result type of the expression is the same as the type of the arguments.

BitwiseXor(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BitwiseXor' function with the specified arguments, which must have the same integer numeric result type. The result type of the expression is the same as the type of the arguments.

Ceiling(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Ceiling' function with the specified argument, which must each have a single, double or decimal result type. The result type of the expression is the same as the result type of value.

Concat(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Concat' function with the specified arguments, which must each have a string result type. The result type of the expression is string.

Contains(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Contains' function with the specified arguments, which must each have a string result type. The result type of the expression is Boolean.

Count(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Count' function over the specified collection. The result type of the expression is Edm.Int32.

Day(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Day' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

DayOfYear(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DayOfYear' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

DiffDays(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffDays' function with the specified arguments, which must each have DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

DiffHours(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffHours' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

DiffMicroseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffMicroseconds' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

DiffMilliseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffMilliseconds' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

DiffMinutes(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffMinutes' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

DiffMonths(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffMonths' function with the specified arguments, which must each have DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

DiffNanoseconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffNanoseconds' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

DiffSeconds(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffSeconds' function with the specified arguments, which must each have DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

DiffYears(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'DiffYears' function with the specified arguments, which must each have DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

EndsWith(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'EndsWith' function with the specified arguments, which must each have a string result type. The result type of the expression is Boolean.

Floor(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Floor' function with the specified argument, which must each have a single, double or decimal result type. The result type of the expression is the same as the result type of value.

GetTotalOffsetMinutes(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'GetTotalOffsetMinutes' function with the specified argument, which must have a DateTimeOffset result type. The result type of the expression is Edm.Int32.

Hour(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Hour' function with the specified argument, which must have a DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

IndexOf(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'IndexOf' function with the specified arguments, which must each have a string result type. The result type of the expression is Edm.Int32.

Left(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Left' function with the specified arguments, which must have a string and integer numeric result type. The result type of the expression is string.

Length(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Length' function with the specified argument, which must have a string result type. The result type of the expression is Edm.Int32.

LongCount(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'BigCount' function over the specified collection. The result type of the expression is Edm.Int64.

Max(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Max' function over the specified collection. The result type of the expression is the same as the element type of the collection.

Millisecond(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Millisecond' function with the specified argument, which must have a DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

Min(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Min' function over the specified collection. The result type of the expression is the same as the element type of the collection.

Minute(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Minute' function with the specified argument, which must have a DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

Month(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Month' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

Power(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Power' function with the specified arguments, which must have numeric result types. The result type of the expression is the same as the result type of baseArgument.

Replace(DbExpression, DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Replace' function with the specified arguments, which must each have a string result type. The result type of the expression is also string.

Reverse(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Reverse' function with the specified argument, which must have a string result type. The result type of the expression is also string.

Right(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Right' function with the specified arguments, which must have a string and integer numeric result type. The result type of the expression is string.

Round(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Round' function with the specified arguments, which must have a single, double or decimal, and integer result types. The result type of the expression is the same as the result type of value.

Round(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Round' function with the specified argument, which must each have a single, double or decimal result type. The result type of the expression is the same as the result type of value.

Second(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Second' function with the specified argument, which must have a DateTime, DateTimeOffset or Time result type. The result type of the expression is Edm.Int32.

StartsWith(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'StartsWith' function with the specified arguments, which must each have a string result type. The result type of the expression is Boolean.

StDev(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'StDev' function over the non-null members of the specified collection. The result type of the expression is Edm.Double.

StDevP(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'StDevP' function over the population of the specified collection. The result type of the expression is Edm.Double.

Substring(DbExpression, DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Substring' function with the specified arguments, which must have a string and integer numeric result types. The result type of the expression is string.

Sum(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Sum' function over the specified collection. The result type of the expression is the same as the element type of the collection.

ToLower(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'ToLower' function with the specified argument, which must have a string result type. The result type of the expression is also string.

ToUpper(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'ToUpper' function with the specified argument, which must have a string result type. The result type of the expression is also string.

Trim(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Trim' function with the specified argument, which must have a string result type. The result type of the expression is also string.

TrimEnd(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'RTrim' function with the specified argument, which must have a string result type. The result type of the expression is also string.

TrimStart(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'LTrim' function with the specified argument, which must have a string result type. The result type of the expression is also string.

Truncate(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Truncate' function with the specified arguments, which must have a single, double or decimal, and integer result types. The result type of the expression is the same as the result type of value.

TruncateTime(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'TruncateTime' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is the same as the result type of dateValue.

Var(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Var' function over the non-null members of the specified collection. The result type of the expression is Edm.Double.

VarP(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'VarP' function over the population of the specified collection. The result type of the expression Edm.Double.

Year(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Year' function with the specified argument, which must have a DateTime or DateTimeOffset result type. The result type of the expression is Edm.Int32.

Area(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Area' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Double.

AsBinary(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AsBinary' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Binary.

AsGml(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AsGml' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.String.

AsText(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'AsText' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.String.

Centroid(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Centroid' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Geometry.

CoordinateSystemId(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'CoordinateSystemId' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Int32.

Distance(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Distance' function with the specified arguments, which must each have an Edm.Geography or Edm.Geometry result type. The result type of spatialValue1 must match the result type of spatialValue2. The result type of the expression is Edm.Double.

Elevation(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Elevation' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Double.

EndPoint(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'EndPoint' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type is the same as that of spatialValue.

ExteriorRing(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'ExteriorRing' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Geometry.

InteriorRingAt(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'InteriorRingAt' function with the specified arguments. The first argument must have an Edm.Geometry result type. The second argument must have an integer numeric result types. The result type of the expression is Edm.Geometry.

InteriorRingCount(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'InteriorRingCount' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Int32.

IsClosedSpatial(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'IsClosedSpatial' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type is Edm.Boolean.

IsEmptySpatial(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'IsEmptySpatial' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Boolean.

IsRing(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'IsRing' function with the specified argument, which must have an Edm.Geometry result type. The result type is Edm.Boolean.

IsSimpleGeometry(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'IsSimpleGeometry' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Boolean.

IsValidGeometry(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'IsValidGeometry' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Boolean.

Latitude(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Latitude' function with the specified argument, which must have an Edm.Geography result type. The result type of the expression is Edm.Double.

Longitude(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Longitude' function with the specified argument, which must have an Edm.Geography result type. The result type of the expression is Edm.Double.

Measure(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'Measure' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Double.

PointAt(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'PointAt' function with the specified arguments. The first argument must have an Edm.Geography or Edm.Geometry result type. The second argument must have an integer numeric result type. The result type of the expression is the same as that of spatialValue.

PointCount(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'PointCount' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Int32.

PointOnSurface(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'PointOnSurface' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Geometry.

SpatialBoundary(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialBoundary' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Geometry.

SpatialBuffer(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialBuffer' function with the specified arguments, which must have a Edm.Geography or Edm.Geometry and Edm.Double result types. The result type of the expression is Edm.Geometry.

SpatialContains(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialContains' function with the specified arguments, which must each have an Edm.Geometry result type. The result type of the expression is Edm.Boolean.

SpatialConvexHull(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialConvexHull' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Geometry.

SpatialCrosses(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialCrosses' function with the specified arguments, which must each have an Edm.Geometry result type. The result type of the expression is Edm.Boolean.

SpatialDifference(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialDifference' function with the specified arguments, which must each have an Edm.Geography or Edm.Geometry result type. The result type of spatialValue1 must match the result type of spatialValue2. The result type of the expression is the same as the type of spatialValue1 and spatialValue2.

SpatialDimension(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialDimension' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Int32.

SpatialDisjoint(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialDisjoint' function with the specified arguments, which must each have an Edm.Geography or Edm.Geometry result type. The result type of spatialValue1 must match the result type of spatialValue2. The result type of the expression is Edm.Boolean.

SpatialElementAt(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialElementAt' function with the specified arguments. The first argument must have an Edm.Geography or Edm.Geometry result type. The second argument must have an integer numeric result type. The result type of the expression is the same as that of spatialValue.

SpatialElementCount(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialElementCount' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Int32.

SpatialEnvelope(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialEnvelope' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Geometry.

SpatialEquals(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialEquals' function with the specified arguments, which must each have an Edm.Geography or Edm.Geometry result type. The result type of spatialValue1 must match the result type of spatialValue2. The result type of the expression is Edm.Boolean.

SpatialIntersection(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialIntersection' function with the specified arguments, which must each have an Edm.Geography or Edm.Geometry result type. The result type of spatialValue1 must match the result type of spatialValue2. The result type of the expression is the same as the type of spatialValue1 and spatialValue2.

SpatialIntersects(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialIntersects' function with the specified arguments, which must each have an Edm.Geography or Edm.Geometry result type. The result type of spatialValue1 must match the result type of spatialValue2. The result type of the expression is Edm.Boolean.

SpatialLength(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialLength' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.Double.

SpatialOverlaps(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialOverlaps' function with the specified arguments, which must each have an Edm.Geometry result type. The result type of the expression is Edm.Boolean.

SpatialRelate(DbExpression, DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialRelate' function with the specified arguments, which must have Edm.Geometry and string result types. The result type of the expression is Edm.Boolean.

SpatialSymmetricDifference(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialSymmetricDifference' function with the specified arguments, which must each have an Edm.Geography or Edm.Geometry result type. The result type of spatialValue1 must match the result type of spatialValue2. The result type of the expression is the same as the type of spatialValue1 and spatialValue2.

SpatialTouches(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialTouches' function with the specified arguments, which must each have an Edm.Geometry result type. The result type of the expression is Edm.Boolean.

SpatialTypeName(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialTypeName' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type of the expression is Edm.String.

SpatialUnion(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialUnion' function with the specified arguments, which must each have an Edm.Geography or Edm.Geometry result type. The result type of spatialValue1 must match the result type of spatialValue2. The result type of the expression is the same as the type of spatialValue1 and spatialValue2.

SpatialWithin(DbExpression, DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'SpatialWithin' function with the specified arguments, which must each have an Edm.Geometry result type. The result type of the expression is Edm.Boolean.

StartPoint(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'StartPoint' function with the specified argument, which must have an Edm.Geography or Edm.Geometry result type. The result type is the same as that of spatialValue.

XCoordinate(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'XCoordinate' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Double.

YCoordinate(DbExpression)

Creates a DbFunctionExpression that invokes the canonical 'YCoordinate' function with the specified argument, which must have an Edm.Geometry result type. The result type of the expression is Edm.Double.

Applies to

Product Versions
.NET Framework 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1