PrepAway - Latest Free Exam Questions & Answers

Which code segment should you insert in line 03?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 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 (click the Exhibit button).

The application includes the following code segment. (Line numbers are included for reference only.)

01 using(AdventureWorksEntities context = new AdventureWorksEntities())
02 {
03 …
04 foreach (SalesOrderHeader order in customer.SalesOrderHeader)
05 {
06 Console.WriteLine(String.Format(“Order: {0} “, order.SalesOrderNumber));
07 foreach (SalesOrderDetail item in order.SalesOrderDetail)
08 {
09 Console.WriteLine(String.Format(“Quantity: {0} “, item.Quantity));
10 Console.WriteLine(String.Format(“Product: {0} “, item.Product.Name));
11 }
12 }
13 }

You want to list all the orders for a specific customer. You need to ensure that the list contains following fields:
* Order number
* Quantity of products
* Product name

Which code segment should you insert in line 03?

PrepAway - Latest Free Exam Questions & Answers

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.
Contact customer = (from contact in context.Contact.Include(“SalesOrderHeader.SalesOrderDetail”)
select contact).FirstOrDefault();

D.
Contact customer = (from contact in context.Contact.Include(“SalesOrderHeader”)
select contact).FirstOrDefault();


Leave a Reply