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.
-Not raise an exeption
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
C
and A
Answer is C. (A is wrong).
Checked in Visual Studio, and it hints:
DateTime DateTime?.Value{ get; }
Gets the value of the current Nullable object if it has been assigned a valid underlying value.
So, it object must have a valid value before you can call the value attribute.