EdmFunctions.DiffYears Method (DbExpression, DbExpression)

.NET Framework (current version)
 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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.

Namespace:   System.Data.Common.CommandTrees.ExpressionBuilder
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

public static DbFunctionExpression DiffYears(
	this DbExpression dateValue1,
	DbExpression dateValue2
)

Parameters

dateValue1
Type: System.Data.Common.CommandTrees.DbExpression

An expression that specifies the first date value argument.

dateValue2
Type: System.Data.Common.CommandTrees.DbExpression

An expression that specifies the second date value argument.

Return Value

Type: System.Data.Common.CommandTrees.DbFunctionExpression

A new DbFunctionExpression that returns the number of years that is the difference between dateValue1 and dateValue2.

.NET Framework
Available since 4.5
Return to top
Show: