You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses the ADO.NET Entity
Framework to model entities. The database includes objects based on the exhibit. The application
includes the following code segment. (Line numbers are included for reference only.)
01 using (AdventureWorksEntities context = new AdventureWorksEntities()){
02
03 foreach (SalesOrderHeader order in customer.SalesOrderHeader){
04Console.WriteLine(String.Format(“Order: {0} “, order.SalesOrderNumber));
05 foreach (SalesOrderDetail item in order.SalesOrderDetail){
06Console.WriteLine(String.Format(“Quantity: {0} “, item.Quantity));
07Console.WriteLine(String.Format(“Product: {0} “, item.Product.Name));
08}
09}
10}
You want to list all the orders for a specified customer. You need to ensure that the list contains the
following fields:
“Order number
“Quantity of products
“Product name
Which code segment should you insert at line 02?
A.
Contact customer = context.Contact.Where(“it.ContactID = @customerId”, new ObjectParameter
(“@customerId”, customerId)).First();
B.
Contact customer = context.Contact.Where(“it.ContactID = @customerId”, new ObjectParameter
(“customerId”, customerId)).First();
C.
context.ContextOptions.LazyLoadingEnabled = true; Contact customer = (From contact in
context.Contact include(“SalesOrderHeader.SalesOrderDetail”) select conatct). FirstOrDefault();
D.
Contact customer = (From contact in context.Contact include(“SalesOrderHeader”) select
conatct). FirstOrDefault();
Explanation: