Microsoft
70-516 · Question #167
You use Microsoft .NET Framework 4.0 to develop an application that uses Entity Framework. The application includes the following Entity SQL (ESQL) query. SELECT VALUE product FROM…
The correct answer is B. SELECT VALUE product. Entity SQL Reference How to: Page Through Query Results
Querying Data
Question
You use Microsoft .NET Framework 4.0 to develop an application that uses Entity Framework. The application includes the following Entity SQL (ESQL) query. SELECT VALUE product FROM AdventureWorksEntities.Products AS product ORDER BY product.ListPrice You need to modify the query to support paging of the query results. Which query should you use?
Options
- ASELECT TOP Stop VALUE product
- BSELECT VALUE product
- CSELECT SKIP @skip VALUE product
- DSELECT SKIP @skip TOP Stop VALUE product
How the community answered
(37 responses)- A3% (1)
- B84% (31)
- C11% (4)
- D3% (1)
Explanation
Entity SQL Reference How to: Page Through Query Results
Topics
#Entity SQL#paging#SKIP#TOP
Community Discussion
No community discussion yet for this question.