You are developing an order processing application that uses the ADO.NET Entity Framework against a
SQL Server database. Lazy loading has been disabled. The application displays orders and their
associated order details. Order details are filtered based on the category of the product in each order.
The Order class is shown below.
The OrderDetail class is shown below.
The Product class is shown below.
The Category class is shown below.
You need to return orders with their filtered list of order details included in a single round trip to the
database.
Which code segment should you use?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
why ToList() not at the end of query?
why not option A
+