Review

Based on what you’ve learned about Entity SQL, can you answer the following questions?

What is the difference between SELECT and SELECT VALUE in an Entity SQL query expression?

Why isn’t it necessary for Entity SQL expressions to begin with the FROM clause?

If the Amount property of a RecipeIngredient is stored as a decimal value in the database, how would you write a WHERE clause to retrieve amounts of 1.5?

Parameterized Entity SQL queries require the creation of two separate objects. What are they?

If a query has a parameter named city, how would you reference that parameter in an Entity SQL query expression?