Reference: Query Designer Properties

You can modify the appearance and behavior of a query by setting the value of properties in the Properties window. The following tables describe each property.

General

Name	Description
Number of Results Returned	Indicates whether the query returns one row or multiple rows. Select one of the following values: Many if you intend for this query to return a collection of rows (For example: a collection of customers). One if you intend for this query to return only one row (For example: a customer). If no data matches the conditions of the query, the query returns null or Nothing in Visual Basic. If more than one row of data matches the conditions of the query, an InvalidOperationException is thrown.
Name	The name of the query.
Is Optional	Indicates whether a parameter value is required or optional. Select one of the following values: True if you want the query to exclude filter conditions that use the parameter when the value of the parameter is null. False if you want the query to include filter conditions that use the parameter when the value of the parameter is null. Each row of data will be tested for the presence of a null value. Applies to query parameters only.
Source	The data source of the query (For example: the Customers entity set).
Return Type	The entity that the query returns when the query is executed.

Appearance

Name	Description
Description	The text that appears as a tooltip.
Display Name	The name that appears on the screen.

See Also

Concepts

Reference: Screen Designer Properties

Reference: Data Designer Properties

Other Resources

Queries: Retrieving Information from a Data Source