Reference: Query Designer Properties

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.

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.

Return Type

The entity that the query returns when the query is executed.

Description

The text that appears as a tooltip.