PrepAway - Latest Free Exam Questions & Answers

Which code segment should you insert at line 04?

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 following object query to load a product from the database.
(Line numbers are included for reference only.)

01 using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities())
02 {
03 ObjectQuery <Product> productQuery = advWorksContext.Product.Where(“it.ProductID = 900”);
04 …
05 }

You need to log the command that the query executes against the data source. Which code segment should you insert at line 04?

PrepAway - Latest Free Exam Questions & Answers

A.
Trace.WriteLine(productQuery.ToString());

B.
Trace.WriteLine(productQuery.ToTraceString());

C.
Trace.WriteLine(productQuery.CommandText);

D.
Trace.WriteLine(((IQueryable)productQuery).Expression);

Explanation:
CHAPTER 8 Developing Reliable Applications
Lesson 1: Monitoring and Collecting Performance Data
Accessing SQL Generated by the Entity Framework (page 509)


Leave a Reply