Filtering and Sorting Data by Using the Designer

Now that you’ve added your entity set query, you can start to apply filter and sort conditions. You can do this either through code or by using the graphical designer. In this section, we’ll show you how to use the graphical designer.

Filtering Query Data

You can use the graphical designer to create simple filters in your queries. Figure 6-10 illustrates the elements of the query designer that you would use to filter data.

The first query drop-down allows you to select the type of query. Choosing the Where option creates a query that includes the records that match your query condition. The Where Not option excludes records that match your query condition.