You are developing an application that uses the Microsoft ADO.NET Entity Framework to retrieve order
information from a Microsoft SQL Server database. The application includes the following code. (Line numbers
are included for reference only.)
The application must meet the following requirements:
Return only orders that have an OrderDate value other than null.
Return only orders that were placed in the year specified in the OrderDate property or in a later year.
You need to ensure that the application meets the requirements.
Which code segment should you insert at line 08?
A.
Where order.OrderDate.Value != null && order.OrderDate.Value.Year > = year
B.
Where order.OrderDate.Value = = null && order.OrderDate.Value.Year = = year
C.
Where order.OrderDate.HasValue && order.OrderDate.Value.Year = = year
D.
Where order.OrderDate.Value.Year = = year
Explanation:
*For the requirement to use an OrderDate value other than null use:
OrderDate.Value != null
*For the requirement to use an OrderDate value for this year or a later year use:
OrderDate.Value>= year
c
0
9
That does not work for later year
6
0
c
0
9
Neither of the answers is correct. It should be:
where order.OrderDate.HasValue && order.OrderDate.Value.Year >= year
Because when you access DateTime? property Value, if it is null, it throws an InvalidOperationException, “Nullable object must have a value”.
4
2